Summary
Keywords
Full Transcript
Link for all dot net and sql server video tutorial playlists https://www.youtube.com/user/kudvenkat/playlists?sort=dd&view=1 Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2015/08/jquery-datatables-server-side.html 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. https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1 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. Step 2 : Copy and paste the following HTML and jQuery code on the webform. Notice that we have set bServerSide option to true. This will tell the jQuery datatables plugin to use server-side processing. We also have set sAjaxSource to EmployeeDataHandler.ashx. This option tells the jQuery datatables plugin about the external source from where the data needs to be loaded. <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <script src="jquery-1.11.2.js"></script> <link rel="stylesheet" type="text/css" href="//cdn.datatables.net/1.10.7/css/jquery.dataTables.min.css" /> <script src="//cdn.datatables.net/1.10.7/js/jquery.dataTables.min.js"> </script> <script type="text/javascript"> $(document).ready(function () { $('#datatable').DataTable({ columns: [ { 'data': 'Id' }, { 'data': 'FirstName' }, { 'data': 'LastName' }, { 'data': 'Gender' }, { 'data': 'JobTitle' } ], bServerSide: true, sAjaxSource: 'EmployeeDataHandler.ashx' }); }); </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> In our next video, we will discuss implementing server-side processing for jQuery datatables plugin using asp.net web service.
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
