circle with database..in google maps

Amitesh Verma

13y2.2k.NET

Creating and Using an InfoBox

its shows that it gets data from database and displays in circle...

its showing the error...
Error: Unterminated string constant

around the :

var markers = JSON.parse('<%=ConvertDataTabletoString() %>');

help

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
I think some string value containing some semicolon or some special character while executing the below query

select name1=NAME,mon1=MNO,load=M_load,lat=x,long=y from overload

since you are not using NAME, MNO and M_Load in your script, so just try like this

select lat=x,long=y from overload

Regards,
Iftikar
0
Amitesh Verma13y ago
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
public string ConvertDataTabletoString()
{
string constring = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(constring))
{
using (SqlCommand cmd = new SqlCommand("select name1=NAME,mon1=MNO,load=M_load,lat=x,long=y from overload ", con))
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List> rows = new List>();
Dictionary row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
return serializer.Serialize(rows);
}
}
}

}
0
Iftikar Hussain13y ago
Hi,
How you have returning the value from ConvertDataTabletoString

Regards,
Iftikar
0