How to query Sql Server data from JavaScript

Question

For the following scenario:

A JavaScript client application sends a JSON query to a webservice. Simplified query example:

{
    table: "orders",
    filter: {
        date: "2011-01-25"
    }
}

The webservice compiles the request into a SQL query and executes it on SQL Server. The webservice returns the result of the query in JSON format.

I need the simplest way (technology stack) to implement the webservice. It should run under Windows Server and IIS 6 and work with SQL Server 2005. I prefer a dynamic language so that the changes in the data definition should not be kept in sync manually.

Robert Koritnik · Accepted Answer · 2011-01-26 13:39:45Z

1

Check out these two:

It will be easier for you to use jQuery on the client side, because it's able to parse JSON for you. And if you do a search on Google aboout either of them you will find enough resources to get you started.

You will have some more configuration to do on your outdated IIS6 machine, but I suppose it should work just as well. I can't guarantee but check the web. And if at all possible upgrade to IIS7. It's about time you do...

edited Jan 26, 2011 at 13:39

answered Jan 26, 2011 at 13:24

Robert Koritnik

105k57 gold badges286 silver badges415 bronze badges

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

3 Comments

Ivan Over a year ago

JSON is a subset of javascript, so there is no need to parse JSON in javascript. Bu jQuery still rocks ;)

Robert Koritnik Over a year ago

@Ivan: JSON strings aren't objects just yet. You have to convert them.

Ivan Over a year ago

Well as he uses it just for AJAX it is safe enough jsut to use eval. However I still fully agree with you. jQuery is much easier to use for send and receive data.

Collectives™ on Stack Overflow

How to query Sql Server data from JavaScript

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related