DataSet, SqlReader, SqlDataAdapter

Good day All.
I have a qustion about subj.

INPUT DATA:
i have Verry big table for example 1 Tb of data and i need to develope small VIEW TABLE program with simple GRID. And i need just to move up and down across records.

MISSANDERSTANDINGS:) :
if i will use sqldataadapter, i will need 1 Tb of RAM to store all records - not permited.
if i will use SqlReader i will able to move only forward - not permited.

There must be some way to solve this.

Any body can give me Clue :)

Thank in advance!!!
[558 byte] By [Mabbus] at [2007-11-19 20:39:47]