Re: Paging in Windiws Datagrid. by Ulrich
Ulrich
Wed Sep 10 12:20:04 CDT 2003
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
"Mahesh D. Rane" <mahesh.rane@lntinfotech.com> schrieb im Newsbeitrag news:539501c3768a$b036ed60$a401280a@phx.gbl...
> 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.