Hi,
My problem is this, I have a search screen which creates a query that
performs a search on a large database. The results of this search could, if
the user requires, return many many rows (20,000).....
In other languages, when faced with this problem, you can run a query and
link it to a datasource and link the datasource to a table. You can then set
an option called packetrecords to 20. If your grid has 40 rows, then as it
populates it will cause the query to return another batch of rows from the
cursor to populate the grid . As you scroll down the grid rows are fetched
each time "on demand" until the cursor is fully returned. This means that
the entire 20,000 rows aren't retrieved from the dataset and reduces traffic
and speeds up the grid..
I cannot seem to achieve the same effect to populate a grid (at least that
easily anyway) without having to create a virtual grid and write a lot of
code.
I know using a datareader and performing a read() doesn;t return a whole
cursor at once as I have tested it using the sql profiler - so I was hoping
that someone knows the magic property i need to set to populate a gridview
this way....
regards to all
Dave.