Advice on Paging records

[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.

 

[Peter Foot [MVP]]

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