Re: Paging, Filtering and Sorting
- From: "LDD" <largedoubledouble@xxxxxxxxx>
- Date: Mon, 9 Jan 2006 12:59:29 -0500
thanks for your help folks
The reason I want to use the paging is because of the number of records.
Loading 300k + records can take up some resources.
What I think I'll end up doing is, simply run the modified query each time
against the database, and using the overloaded Fill method for the
dataadapter, only show a chunk at a time in the grid. As the user navigates
through the pages, I'll update the fill method and reflect the changes in
the grid.
I may also set this up with a dataview and compare the performance of the
two approaches.
LDD
"LDD" <largedoubledouble@xxxxxxxxx> wrote in message
news:z8KdnQrUs4i8WyPenZ2dnUVZ_v6dnZ2d@xxxxxxxxxxx
> Hi Folks
>
> I'm trying to determine a way to handle paging, filtering and sorting in a
> datagrid.
> If I choose to filter and sort, I'd like to return a subset. If that
> resultset has more records then the number of rows I'd like to display,
I'd
> like to be able to load pages into the grid.
>
> My question is, do I need to continually hit the db to get the next page
of
> records, or is there another method of doing with the dataset. i.e. load
the
> entire resultset into the dataset and pick up the next block of results as
> neeeded.
>
> thanks folks
>
> LDD
>
>
.
- References:
- Paging, Filtering and Sorting
- From: LDD
- Paging, Filtering and Sorting
- Prev by Date: Re: Bug or By Design...
- Next by Date: Cell validating event problem.
- Previous by thread: Re: Paging, Filtering and Sorting
- Next by thread: Re: Add a line break in label.text
- Index(es):
Relevant Pages
|
