2

i want show to data result based on top result in ASPxGridView, is there any property which handle that case?

Wildan Muhlis
  • 1,553
  • 2
  • 22
  • 43

1 Answers1

0

there are multiple ways of solving this, server side, UI side, hybrid...

Server side means you have a stored procedure on the SQL Server which contains a TOP x in the select.

UI side means you specify paging and a pageSize of X in the Grid and even if this would work is not so good because in any case the SQL Server will return all records to the web server over the network.

many different ways to implement hybrid solutions like using bindToLinq methods or other ORM approaches which would generate the TOP X for you depending on the settings and usage of the grid.

this as introduction, please show us how you are fetching the data and binding the grid to the result set.

Davide Piras
  • 43,984
  • 10
  • 98
  • 147
  • Thanks for your response Dave, i use XPO Data Source to bind data result, – Wildan Muhlis Sep 21 '12 at 10:29
  • good, XPO should support server side paging and sorting, grouping and filtering by design, you should probably only set the PageSize in the grid and you are done! – Davide Piras Sep 21 '12 at 12:22
  • no, i mean if we have 10 data i'll just show five data, i want to make PageSize = 1 and Pagination button just show 5 button. Is it clear enough? – Wildan Muhlis Sep 22 '12 at 10:22