<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <%@ Import Namespace="using System.Data.OleDb"%> <%@ Import Namespace="using System.Data" %> <%@ Import Namespace="using System.Configuration"%> <script runat="server"> static int rno = 0; string cs = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString; protected void Page_Load(object sender, EventArgs e) { OleDbConnection con = new OleDbConnection(cs); con.Open(); OleDbCommand cmd = new OleDbCommand("SELECT Latitude,Longitude FROM googlemap ", con); //OleDbDataReader dr = cmd.ExecuteReader(); OleDbDataAdapter da = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable(); da.Fill(dt);
...

Go to the complete details ...