gianitoo
asked on
how to get the longitude and latitude from street address in asp.net
This code below retrieves street address. how can i create a function that will generate the longitude and latitude of that specific address?
Dim conn As New Data.SqlClient.SqlConnecti on(Configu rationSett ings.AppSe ttings("co nnectionUS SL"))
conn.Open()
Dim cmd As New Data.SqlClient.SqlCommand( "salesquot eschecker" , conn)
cmd.CommandType = CommandType.StoredProcedur e
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Request.QueryString("id"). ToString()
Dim dr As Data.SqlClient.SqlDataRead er = Nothing
dr = cmd.ExecuteReader()
While dr.Read()
Session("street") = dr("street").ToString()
Session("city") = dr("city").ToString()
Session("state") = dr("state").ToString()
Session("zip") = dr("zip").ToString()
End While
conn.Close()
conn.Dispose()
Dim conn As New Data.SqlClient.SqlConnecti
conn.Open()
Dim cmd As New Data.SqlClient.SqlCommand(
cmd.CommandType = CommandType.StoredProcedur
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Request.QueryString("id").
Dim dr As Data.SqlClient.SqlDataRead
dr = cmd.ExecuteReader()
While dr.Read()
Session("street") = dr("street").ToString()
Session("city") = dr("city").ToString()
Session("state") = dr("state").ToString()
Session("zip") = dr("zip").ToString()
End While
conn.Close()
conn.Dispose()
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.