Advice on Paging records

  • Thread starter Thread starter Simone
  • Start date Start date
S

Simone

Anyone does have an advice on paging records on a DataGrid to show max 20
records for page?

I want to fill a Datatable al max for 20 records each time.

My select is simlpe

SELECT * FROM TABLE WHERE .....

I have a SqlCeDataAdapter and a DataTable.
 
There is an override for the Fill method which takes a start index and
maximum number of records, which allows you to do this e.g.

Fill(ds, 0, 20, "MyTable")

Peter
 
Back
Top