Handling paging in the UI without using datagrid/dataview

[Guest]

Hi

Please give me some inputs on the following :

Iam planning to use a custom control to list a large number of records from
sql database through ado.net. so in the following code, if i give a select
* query, does the dataset holds the complete records in the memory? or is
there anyway i can set options in the dataset? or the paging logic need to be
done in UI side?

Hari


//Open Connection.
SqlConnection conn = new
SqlConnection("Server=server;uid=login;pwd=pwd;database=northwind");

//Set the DataAdapter's query.
da = new SqlDataAdapter("select * from customers", conn);
ds = new DataSet();

//Fill the DataSet.
da.Fill(ds, "customers");

 

[Val Mazur \(MVP\)]

Hi,

When you call SELECT * FROM .., then yes all the records will be transferred
to the DataSet/dataTable. Next example shows you how to provide paging
without loading all the data

http://support.microsoft.com/default.aspx?scid=kb;en-us;829142

Or you could implement paging in a dataGrid control

http://support.microsoft.com/default.aspx?scid=kb;en-us;318131