jQuery datatables server side processing example asp net

preview_player
Показать описание
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.

In this video we will discuss implementing server-side processing for jQuery datatables plugin. This is continuation to Parts 108 and 109. Please watch Parts 108 and 109 from jQuery tutorial before proceeding.

Here is the request and response cycle
jQuery datatables plugin sends the request to the ASP.NET generic handler on the web server.
The ASP.NET generic handler 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

Step 1 : Add a WebForm to your Demo project.

<!DOCTYPE html>
<head runat="server">
<title></title>
<link rel="stylesheet" type="text/css"
</script>
<script type="text/javascript">
$(document).ready(function () {
$('#datatable').DataTable({
columns: [
{ 'data': 'Id' },
{ 'data': 'FirstName' },
{ 'data': 'LastName' },
{ 'data': 'Gender' },
{ 'data': 'JobTitle' }
],
bServerSide: true,
});
});
</script>
</head>
<body style="font-family: Arial">
<form id="form1" runat="server">
<div style="width: 900px; border: 1px solid black; padding: 3px">
<table id="datatable">
<thead>
<tr>
<th>Id</th>
<th>First Name</th>
<th>Last Name</th>
<th>Gender</th>
<th>Job Title</th>
</tr>
</thead>
<tfoot>
<tr>
<th>Id</th>
<th>First Name</th>
<th>Last Name</th>
<th>Gender</th>
<th>Job Title</th>
</tr>
</tfoot>
</table>
</div>
</form>
</body>
</html>

Рекомендации по теме
Комментарии
Автор

cannot imagine freshers life without this tutorials

sagarvgholap
Автор

You're a great person venkat and the best programming channel in the internt

jkmalify
Автор

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.

imadabab
Автор

Thank you very much for this detail tutorial. Forever obliged.

ImranAliIMNUMBERONE
Автор

Thank you for your effort, it has been a copious expression, well done.

tahirfeyzioglu
Автор

Thanku Sir ..what if I am using external .json file and want pagination

tinytutor
Автор

Thank you very much for all the videos. Really helpful. I have few queries. Hope to get reply. i want to create multilevel nested datagrid in asp.net using jquery datatable plugin. Datagrid should be dynamic and should created during run time. Is this possible?

akshayvartak
Автор

Great Video. Could you please make a video for server-side processing for jQuery datatables plugin using PHP and MSSQL with ajax? Thanks in advance.

ashoksen
Автор

Nice Tutorial, but i have a question how can i pass another parameter to the stored procedure, i.e UserID parameter using asp.net generic handlers?

dalmaryusufabdi
Автор

Great video! Could you please us how Jquery Datatable Row details works. Thank you so much.

Rocky
Автор

worked very good but how can i apply part 107 here
thank u

yazanpg
Автор

Thank you very much... you are the best!!!

francosaavedra
Автор

paging doesn't work for me here. No records are shown on second page. I can only see if I change page size.

yamikadesai
Автор

How to set custom search and sort for this table with dynamic data... plz reply

hellonavin
Автор

Can you show or explain how many times your ashx is being called on page load. I have a simple example with 13 cols, and i get 13 individual ashx calls. is this right?

wayneatherton
Автор

Nice work, but.... where is the C# code

silversurfer
Автор

can anyone plz tel me how to pass extra parameters for stored procedure to datahandler?

shivrajpairaiturkar
Автор

can someone provide me its stored procedure ?

kaleempk
Автор

im getting error DataTables warning: table id=datatable - Ajax error.

rahatakhter
Автор

How can this be done through WebAPI 2..anybody?

atpvideo