TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
xuan xuan
NA
1
0
Calculate value for specific label in DataList
May 19 2010 11:46 PM
hiex! i've been figuring out this problem for days....seriously need help...
This function i m working on is to calculate the shortest distance between the delivery man and the destination by using GPS coordinates. After clicking a button, named as btnShortestDist, it will retrieve all delivery man details on a page. I can't create that many sql statement to call all delivery men's details out. Thus, I used DataList and databind it with the database on sql server.
The problem is, for each delivery man, I need to calculate the shortest distance. I dragged a label to the DataList's item template. This label, named as DistanceLabel, should use the distance calculation method in the c# page and give an output of the calculated distance. How do I do this for all the delivery men? Is it possible?
My C# distance calculation method:
public static double CalculateDistance(double lon1, double lat1, double lon2, double lat2) {
const double R = 3956;
const double degreesToRadians = Math.PI / 180;
//convert from fractional degrees (GPS) to radians
lon1 *= degreesToRadians;
lat1 *= degreesToRadians;
lon2 *= degreesToRadians;
lat2 *= degreesToRadians;
double dlon = lon2 - lon1;
double dlat = lat2 - lat1;
double a = Math.Pow(Math.Sin(dlat / 2), 2) + Math.Cos(lat1) * Math.Cos(lat2) * Math.Pow(Math.Sin(dlon / 2), 2);
double c = 2 * Math.Atan2(Math.Sqrt(a), Math.Sqrt(1 - a));
double d = R * c;
return d;
}
The DataList code that i did for now:
<asp:DataList ID="DataList1" runat="server" DataKeyField="StaffID"
DataSourceID="SqlDataSource1" RepeatColumns="3"
RepeatDirection="Horizontal">
<ItemTemplate>
StaffID:
<asp:Label ID="StaffIDLabel" runat="server" Text='<%# Eval("StaffID") %>' />
<br />
StaffName:
<asp:Label ID="StaffNameLabel" runat="server" Text='<%# Eval("StaffName") %>' />
<br />
Distance:
<asp:Label ID="DistanceLabel" runat="server" Text="Label"></asp:Label>
<br />
<br />
</ItemTemplate>
</asp:DataList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:VCdeliveryconnectionString %>"
SelectCommand="SELECT [StaffID], [StaffName] FROM [Staff] WHERE ([Role] = @Role)">
<SelectParameters>
<asp:Parameter DefaultValue="DeliveryMan" Name="Role" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
Reply
Answers (
1
)
The properties of application domain
Face book API