The best way to send data to JavaScript functions from a Microsoft SQL Server Database

Question

I have a bunch of location data (longitude and latitude pairs) sitting in a Microsoft SQL Server DB.

I need to plot those points on a Map (OpenLayers+OSM), and the only way to draw on the map is to use JavaScript.

So far, I have no idea how to achieve this goal. The only thing I know is that I do not want to establish a database connection in JavaScript. In other words, I need to somehow use c# to pass the data from database to Javascript. Any suggestions? All help is appreciated!

Ajax. You expose a HTTP service (WCF?) from .NET land that returns data from MSSQL and then talk to that service using ajax — Raynos
– Raynos, Commented Sep 22, 2011 at 21:26

Carlos Paulino · Accepted Answer · 2011-09-22 21:28:30Z

2

Write a asp.net generic handler page that fetches the data from the database and outputs a json string.

Then with jQuery parse that output and plot.

answered Sep 22, 2011 at 21:28

Carlos Paulino

7966 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

YoYoMyo Over a year ago

Your answer combined with tugberk's give me a general direction to the problem. Thanks!

tugberk · Accepted Answer · 2011-09-22 21:37:31Z

2

You can make use of WebMethods and JQuery here.

Following blog post with an example should give you an idea how you can easily reach the server side code from client side :

http://tugberkugurlu.com/archive/asp-net-web-forms---calling-web-service-page-methods-using-jquery

answered Sep 22, 2011 at 21:37

tugberk

58.7k71 gold badges252 silver badges342 bronze badges

Collectives™ on Stack Overflow

The best way to send data to JavaScript functions from a Microsoft SQL Server Database

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related