PAGING , FILTER AND SEARCHING HOW TO DEAL WITH LARGE AMOUNT OF DATA IN TABLE USE OF DATA TABLE- PART 3

January 14, 2020

PAGING , FILTER AND SEARCHING HOW TO DEAL WITH LARGE AMOUNT OF DATA IN TABLE USE OF DATA TABLE- PART 3

Ajax Request

HOW TO DEAL WITH LARGE AMOUNT OF DATA IN TABLE USE OF DATA TABLE - PART 3

This is the Third part of our series which consist of introduction of ajax

ajax is techniques use for communication between client and server on large scale.

here is the complete Tutorial links

1 . HOW TO DEAL WITH LARGE AMOUNT OF DATA IN TABLE USE OF DATA TABLE

Introduction of datatable Jqery

2. First part is about how to use data table in our web page and some functionality of data table

Datatable part 1

3. Second part is about paging , filter and searching in data table

DATATABLE PART 2

4. Third part contain how we get data from server on each event like paging , filter and searching

DATATABLE PART 3

5.Fourth part is additional contains some code example of .net example in which i use this all for run this Complete stuff in our MVC .net application with C# and DATATABLE in which i load student list in table from server .

DATATABLE PART 4-coming soon

--------------------------------------------------------------------------------------------------------------------------

AJAX ( Asynchronous JavaScript and XML)

At this time you have seen many developers uses SPA( Single page Application ) for creating new websites.

In single page application page is not reloaded on every click . only the some part of page is updated . Not complete page is reloaded.

This magic is done by ajax request

Ajax, or Asynchronous JavaScript and XML, is an approach to Web application development that uses client-side scripting to exchange data with the Web server.

As a result, Web pages are dynamically updated without a full page refresh interrupting the interaction flow.

This is the post About datatables so lets come to the point , how datatable uses ajax for getting data from server on each and every request .

Every time when be click on any button in datatable environment a ajax request is generated

It gets the required data from server and the DOM updated

In this complete process a single ajax request is generated by browser and get data from server and then update model .

here i create a video for you to understand about ajax

How ajax is used in data table

There are some parameters defined by datatable like page count , record count , which page is currently showing , we will discuss all parameter in this post later .

All these paramaters are attached in every ajax request as formdata and we can add some more data as we required .

This parameter are used on server side to get data from datatable and then filtered data is send as a json response and then by datatable the grid data is automatically updated.

Diffrent Parameters send by datatable

draw: no of times data comes from server.

start: no of record from which data is start to display.

length: no of records to be displayed.

Simple ajax call for example

$.ajax({
url:"waytocode/submitform",
data:{},
method:"POST"
success:function(response){
alert("success");
},
error:function(error){
alert (error);
}

})

this is simple example for ajax request $ is the acronym for Jquery

this post is only for introduction of ajax and how to use it in datatable for data transfer from server to client without page refresh .

In the next post i am going to create a complete .Net MVC Solution and then we create a complete Grid with functionality .

In meanwhile if i get the the time i will try to make you tube videos on this complete series for all my reader .
I am trying to create a local community on which we discuss our problems and get them solve .

--------------------------------------------------------------------------------------------------------------------------