jQuery datatables server side processing using asp net web services

Link for all dot net and sql server video tutorial playlists

Link for slides, code samples and text version of the video

Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help.

Here is the request and response cycle
jQuery datatables plugin sends the request to the ASP.NET web service
The ASP.NET web service will then call the stored procedure in the database. Retrieves the data and converts it to JSON format.
The JSON formatted data will then be displayed on the page by the jQuery datatables plugin

[imadabab]

Videos 109, 110, 111 and 112 are excellent. Thanks a lot. Appreciate if you add another video number 114 explaining how to implement customer column search with server side jquery datatable. This is will be perfect.

[ammaral-hamdani]

Thanks a lot for the tutorial... Can you show us the procedure of SQL Server

[SE]

Really thank you, and I tried in page method it's not work, so I advise if some body have asp.net with form authentication to disable it by adding related tag in web config

[wayneatherton]

Hi, do you have any examples using the new version?

[hunaynhafeez]

@Kunvenkat: How the webservice is getting parameters since you haven't sent any explicitly ?

[girishinindia]

Paging is not working... what to do? checked code 100 time but records desply properly but no paging... it shows 0 to 0 of 0 entries (246 entries)... what to do?

[EvanLott]

I am getting an ajax error when testing the web form. The handler is working fine. Any idea what I need to do to fix this?

[derrickwalker]

Great video post! I tried to implement this with a WCF Service that's expecting json formatted data.  However, I'm getting the Bad Request error.  The jQuery Datatables is apparently sending Raw data... Are there settings on the jQuery Datatables that will send json formatted instead of raw data? Thanks!

[jayrehman]

Why is my ajax post url is default.aspx and not the webservice's url I provided in sAjaxSource?

[UmairKhan-hcql]

i want to sent a request to Asp.NET API with Cross Domain using jsonp.
can you guide me on this too

[danishsafari]

hi, sir, I won't pass id from asp.net page1?id=1 to asp.net page2 when asp.net page2 receive this Id how to send directly this id to web server.ASMX

[abhaybabariya]

Hello sir it is doesn't call it's get 500 error in console because of in parameter passing iDisplayLength and other parameter if i have pass those data in static then method call but how to create dynamic ? Please create new video using "serverSide" updated jQuery Datatable ?