X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> How To Do Grid Paging With Subsequent Trips To IIS    
post Jul 18 2013, 05:21 PM

Posts: 194
Joined: 5-September 05

Is there a way for a web application (aspx) page to have a grid based on a DataSet where paging is based on a round trip back to IIS for the next page, rather than have the entire DataSet already full?
We build a DataSet based on a database call to oracle which returns a huge amount of rows in a cursor. The client c# routines then do paging (user clicking next, prev., etc.) based on this DataSet which is too large.
Can someone here recommend a way to reduce the DataSet size to just one page of data at a time? I am hoping there is a better (or automatic) way to do this without having to manually pass the page number in the
database call. Has someone found a convenient way to do this?
Go to the top of the page
post Jul 19 2013, 03:14 PM

UtterAccess Editor
Posts: 17,956
Joined: 4-December 03
From: Northern Virginia, USA

Do you have parameters that you pass to perform your .Fill? If not, then I would suggest that be the first step in accomplishing what you want.
However, with that said, IIRC, you could switch your data access to the Entity Data Model (edmx) {Entity Framework}, and utilize Linq, then use the .Skip and .Take methods. Please note that .Skip and .Take are through Linq, so you can use the methods with DataSet, but the data retrieval the DbContext class of the entity data model is "lazy loading" so you will only retrieve what you request through the Linq command.
Go to the top of the page

Custom Search
RSSSearch   Top   Lo-Fi    16th July 2018 - 03:20 PM