Click here to Skip to main content
15,895,142 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
CSS
Figure : 1,
 Database table

Vehicleid   Latitude    Longitude   datetime
1   16.43924553090  79.92235564210  2012-12-19 16:00:00.000
1   16.43517902890  79.92466106060  2012-12-19 16:02:00.000
1   16.43111252690  79.92498125760  2012-12-19 16:04:00.000
1   16.42797459620  79.92517337580  2012-12-19 16:06:00.000
2   14.68807134570  79.50083987840  2012-12-19 17:12:00.000
2   14.68514259410  79.51420230760  2012-12-19 17:14:00.000
3   18.56690251930  82.50047999880  2012-12-19 18:22:00.000
3   18.56884750210  82.50426359800  2012-12-19 18:24:00.000

Based on above figure1 (database table), how to calculate distance between starting and ending points by using c# .net  and also at the same time insert the starting( lat& long) and ending (lat & long) as well as strating time, ending time, distance values in another table like below table


Vehicleid   Starting(lat & long)    Ending (lat  & long)    Distance(in kms)    Strat time  End time
1   16.43924553090, 79.92235564210  16.43517902890,
79.92466106060  ?   2012-12-19 16:00:00.000 2012-12-19 16:02:00.000
1   16.43517902890,
79.92466106060  16.43111252690,
79.92498125760  ?   2012-12-19 16:02:00.000 2012-12-19 16:04:00.000
1   16.43111252690,
79.92498125760  16.42797459620,
79.92517337580  ?   2012-12-19 16:04:00.000 2012-12-19 16:06:00.000
Posted

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900