Paging in Windiws Datagrid.

[Mahesh D. Rane]

Hi,
i am having one datagrid, i am fetching more than 25k
records in that datagrid.
At present i am displaying all the records in one grid.
so the datagrid takes hell lot of time to fetch record
from database and displaying it.
Whether paging is allowed in Windows C# forms ? Or any
other way to implement paging ?

Thanking in Advance.

Regards,
Mahesh D. Rane
LnTInfotech, Powai
Mumbai.

 

[Ulrich Sprick]

Hi Mahesh,

I have been thinking about this, too. Currently, there are 2 approaches:
1. provide a filter property the user can use to limit the result set size,
2. limit the number of rows that are fetched in the select statement (select....fetch first 100 rows only or something like that),
and implement a paging logic such as web search engines do. Somewhat unusual for a windows application, I think
3. Execute the DataAdapter.Fill( DataTable ) in a background thread.

Ok, that are 3 methods. Currently, I've only done the first.

HTH, Ulrich