How do I show SQL results on a website via AJAX and jQuery?
Posted on 2010-03-26
I'd like to use my usual SQL stored procs to return a DataSet to a .NET application and manipulate the results on the front end using jQuery's AJAX features.
In plain language terms, I want multiple areas on an ASPX page performing CRUD functions asynchronously.
Okay so a couple of prerequisites:
I'm using C# on the server, not VB.
I don't want to use AJAX controls (specifically UpdatePanel).
I don't care if I use XML or JSON to result the data to jQuery (though I'm more familiar with XML).
I can't write to/create files - everything MUST be done in memory.
I need the data to be returned from public methods in either a web service, C# class or other similar file type that can contain many methods.
An extra bonus would be if I could use my existing business objects, an example of one would be a simple Person class.
FirstName - string
LastName - string
Age - int
Any direction on this would be greatly appreciated!