Caching database problem

[SAM]

Hi,
I tried to browse a table which have 2 million of records.

it's too slow to browse -it directly so i tried to use caching
methods.

(Implementing Virtual Mode with Just-In-Time Data Loading in the
Windows Forms DataGridView Control
http://msdn.microsoft.com/en-us/library/ms171624.aspx)

I implement this sample. i change only the connection to my table.

the problem is repeat the same 16 records because the pagenumber it
set to 16.

if i try to change the page number to 32 or 64... it be come too slow.
if i compare my datagridview with my table im not getting a same
value.

i need help if some one knows better ways to do this it will be
great.
thanks in advance.

 

[Cor Ligthert[MVP]]

Sam,

Most people do this using parts of the database by using SQL and the where
clause, loading a datatable from 2 millions of records in memory will almost
by everyone active in this newgroup as idiotic.

Cor