Load on data in telerik grid with pagination

[Margret]

Load data on demand in telerik grid using pagination

Is it possible to load data on demand using pagination as like in ordinary asp grid controls? .It doesnot use any ajax and scrolling things.Initially it will load only 10 records.And if the records is more than 10,it will have paging control and display records based on the page index and page size.Can i do the load data on demand in grid, only based on the paging in grid?.

Thanks in advance
Margret

[Margret]

Hi all,
Any update on this requirement?

[Eyup]

Hello Margret,

In case you want to handle only  a portion of your data items, you can check out this demo:
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/custompaging/defaultcs.aspx

To load and display records with a condition, please refer to the following example:
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/alphabeticpaging/defaultcs.aspx

Hope this helps.

Regards,
Eyup
Telerik

[Margret]

Thanks.I will try it .

[Margret]

Hi All,
By default I have sorted the data with product id by descending in sort expression.And then loaded the data in the grid on demand by custom paging concept.If I have sort the data by other columns header text,It does'nt load properly.Can anybody explain the sorting part with any other examples?
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/custompaging/defaultcs.aspx
I have referred the above link.But for my scnerio,I could not get the correct logic.

Thanks in advance,
Margret

[Margret]

I think I have to set "AllowMulticolumnSorting=true" in master table view.
Regards,
Margret

[Eyup]

Hi Margret,

I am glad that you have managed to overcome the issue and I hope that it will help other developers with similar scenarios.

Regards,
Eyup
Telerik

[Margret]

Hi All
I have used the page index,pagesize value in the( rownumber query ) store procedure for getting dataset .

If I am trying to sort the details by clicking on the grid header columns like Age,Address etc.The sorting is not met my requirement.Please share any examples or steps  for sorting procedure for Load data on demand in grid using paging concepts.If  i am sorting,then change to the first page,it shows no record found. 

 

[Eyup]

Hello Margret,

Can you please verify that you are not using DataBind()? Performing complex grid operations such as Inserting, Deleting, Updating, Hierarchy relations, Grouping, Paging, Sorting, Filtering, etc. require accommodating appropriate database operations.  Therefore, we suggest you to avoid Simple Databinding and strongly recommend the use of more advanced databinding methods, which automatically handle the aforementioned functions:
Declarative DataSource
Advanced Data Binding

Hope this helps.

Regards,
Eyup
Telerik