how to get latitude and logitude from sql server Asp.net

taqi nazir

10y2.1k.NET

how to get latitude and logitude from sql server 2008 ,Asp.net web form

i want to get title, latitude ,logitude and description from sql server 2008?

how to conncet sql server 2008?

i want to get title, latitude ,logitude and description from sql server 2008?

please guide me??

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="gmap.ascx.cs" Inherits="line.usercontrol.GMap" %>

20 Replies

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

Vinay Singh10y ago
Accepted answer
Hi
Please check the link for the solution
Display Latitude and Longitude Value on Google Map from Sql Server Data Base in Asp.net Using C#.Net
0
taqi nazir10y ago
hiVinay Singh
thank you so much for guide me ...
0
Vinay Singh10y ago
Hi
try as
var markers =<%=outputVal%>;
there should not be any space
OR just download the sample and then do as per the sample
https://app.box.com/s/dzyliltxaznp53o59klezr4adlmrl3we
0
taqi nazir10y ago
Hi Vinay Singh
now i am using output val in in javascript but it shows the syntax error
var markers =<%=outputVal %>; (it shows the syntax error)
0
taqi nazir10y ago
HiVinay Singh
now i am using output val in in javascript butit shows the syntax error
var markers =<%=outputVal %>;(it shows the syntax error)
my code is given below
0
taqi nazir10y ago
HiVinay Singh
now i am using output val in in javascript butit shows the syntax error
var markers =<%=outputVal %>;(it shows the syntax error)
my code is given below
0
Vinay Singh10y ago
Hi
U r using output val in wrong way in javascript
U are using
var markers =outputVal;
But it should be used as
var markers =<%=outputVal %>;
0
taqi nazir10y ago
hiVinay Singh,
i have perform all work as you perform..
Data access in backend from database i checked it by using breakpoint.
but google map is not appear in webform.??
thanks for help...
0
taqi nazir10y ago
hiVinay Singh
i have passing value from code behind to javascript function
var markers =outputVal;
after this there is no error..
when i debug.... data show in outputVal = output;from the database Table..
but Google map not showing on the webform??
please guide me
thanks
0
Vinay Singh10y ago
Hi
public string outputVal = ""; is a public variable. in this variable i am using for storing the json object and accessing it in .aspx page javscript function.
So simley we can say that we are passing value from code behind to javascript function
0
taqi nazir10y ago
hiVinay Singh,
thanks you so muchVinay Singh,
i have created new table and form as you created.
and connect it using connection string..
but there are some issues..please explain wind example.
After table we will create a new asp.net application and add the below html code on the page.
var markers =<%=outputVal%>;??? what is thethis?
Now we will check the code behind code.
public string outputVal = "";what is this?
string output = ConvertDataTableToJSON(dt);??(how to ConvertDataTableToJSON)
http://www.c-sharpcorner.com/UploadFile/9bff34/3-ways-to-convert-datatable-to-json-string-in-Asp-Net-C-Sharp/
0
Vinay Singh10y ago
hi
sorry for late reply.I was looking for the solution of your problem. After lots of search i got the solution and creating the demo. max to max by today EOD i will provide you the solution.
Thanks
0
taqi nazir10y ago
hiVinay Singh,
i am waiting your reply....with code example...
i can't understand how to load latitude and longitude from database and show a related location and marker on GOOGLE MAP in my web form...
thanks for help...
0
taqi nazir10y ago
hiVinay Singh,
i am waiting your reply....with code example...
i can't understand how to load latitude and longitude from database and show a related location and marker on GOOGLE MAP in my web form...
thanks for help...
0
Rajeesh Menoth10y ago
Hi,

Welcome taqi nazir :)

Google Map have some limitations that's why I given that article reference. Do you want to study new technology then go with Asp.Net MVC.

Reference for MVC :

http://www.w3schools.com/aspnet/mvc_intro.asp

http://www.asp.net/mvc/overview

The answer is helpful. Then please accept it..!!
0
taqi nazir10y ago
HiRajeesh Menoth,
thank you so much...
i am new and not good in programming.
i am working in Asp.net web forms and Sql server 2008.
i don't know about MVC but i will try this solution and create a new project but when i create a controller the there is an error model is not created.
..basically i want to load latitude and longitude from data base and show a related location and marker on GOOGLE MAP in my web form...
0
Vinay Singh10y ago
Hi
Please give me some time to prepare a sample code for you
+1
Rajeesh Menoth10y ago
Hi,

I think this article will more help you.

Reference :

http://www.c-sharpcorner.com/article/get-user-location-using-latitude-and-longitude-with-openstre/
0
taqi nazir10y ago
Hi Vinay Singh
thanks you so much ....i am new . i am not good in programming.
i have created data base in SQL Server 2008.table name is UolMap.i have also enter some data in table ..
please guide me how can i connect VS2013 to SQL server 2008 and how can access the table value to prepare a string in the format.?
0
Vinay Singh10y ago
Hi
For this first you need to save all the latitude and logitude in your DB table and then access the table value to prepare a string in the format you need the date. After preparing string assign the string value to Hidden field and then access the hidden field value in you javascript code,
Eg:
suppose your hidden field value is

Now access the hidden field value
function initialize() {
//-----Here you will get all the value in hidden field.
var cordinateVal=document.GetElemntById("txtCordinate").value;
var markers = [
cordinateVal

];----------
-------------rest code
0

how to get latitude and logitude from sql server Asp.net

hiVinay Singh

Hi Vinay Singh