Changing data source

SxChoc

Hi,

I wonder if someone could help me out please. I've been constructing a datatable for about three weeks (this is my first time using it so it was a steep learning curve!!).

In order to make development easier everything is being handled on the client side and the data is being pulled from a locally held static text file. My clients have now signed off the design and the functionality so I now need to switch the datasource from this static text file to pulling data SQL data through an asp.net solution. Could anybody advise me on the easiest method for achieving this please. All of the filtering, sorting, etc. can still be processed on the client I just need to pull in the data.

Thanks in advance,
Craig

thargenediad

perhaps something like this person's SQL Server-based (albeit non-working) example: http://datatables.net/forums/discussion/15553/getting-error-json-data-from-server-could-not-be-parsed.-this-is-caused-by-json-formatting-error.