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
sarthi urs
NA
3
8.1k
Not Able to Display Multiple Markers asp.net from database
Mar 2 2015 4:30 AM
Hi Everyone,
I am unable to display multiple markers due to this error i.e;
Index and length must refer to a location within the string.
Parameter name: length
Src code:
protected void Page_Load(object sender, EventArgs e)
{
string markers = GetMarkers();
Literal1.Text = @"
<script type='text/javascript'>
function initialize() {
var mapOptions = {
center: new google.maps.LatLng(28.3213, 77.5435),
zoom: 2,
mapTypeId: google.maps.MapTypeId.ROADMAP
};
var myMap = new google.maps.Map(document.getElementById('mapArea'),
mapOptions);"
+ markers +
@"}
</script>";
}
protected string GetMarkers()
{
string markers = "";
using (SqlConnection con = new
SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["HostelConnectionString"].ConnectionString))
{
SqlCommand cmd = new SqlCommand("select VillageNm,lattitude,longitude,HostelName,DistrictCd,TalukCd,Hostel_Coordinates from FinYearHostelDetails left join Hostelinformation on FinYearHostelDetails.Hostelcd=Hostelinformation.Hostelcd", con);
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
int i = 0;
while (reader.Read())
{
i++;
markers +=
@"var marker" + i.ToString() + @" = new google.maps.Marker({
position: new google.maps.LatLng(" + ConvertDegree(reader["Lattitude"].ToString()) + ", " +
ConvertDegree(reader["Longitude"].ToString()) + ")," +
@"map: myMap,
title:'" + reader["HostelName"].ToString() + "'});";
}
}
return markers;
}
public double ConvertDegree(string input)
{
double sd = 0.0;
double min = 0.0;
double sec = 0.0;
double deg = 0.0;
string direction = input.Substring(0, 1);
string sign = "";
if ((direction.ToUpper() == "S") || (direction.ToUpper() == "W"))
{
sign = "-";
}
string[] arr = input.Split(new char[] { ' ' });
min = Convert.ToDouble(arr[2]);
string[] arr1 = arr[3].Split(new char[] { '.' });
sec = Convert.ToDouble(arr1[0]);
deg = Convert.ToDouble(arr[1]);
min = min / ((double)60);
sec = sec / ((double)3600);
sd = deg + min + sec;
if (!(string.IsNullOrEmpty(sign)))
{
sd = sd * (-1);
}
sd = Math.Round(sd, 6);
string sdnew = Convert.ToString(sd);
string sdnew1 = "";
sdnew1 = string.Format("{0:0.000000}", sd);
double manu = Convert.ToDouble(sdnew1.ToString());
return manu;
}
Solution please
Reply
Answers (
0
)
this WVC does not support the .mp4 &.mov file format
How to expand only the selected node in treeview control?