Use DataView to return the first n rows

[Stephen Miller]

Can you use a DataView to return only the first say 10 rows of a
dataset? If so, how?

Thanks,

 

[Miha Markic [MVP C#]]

Hi Stephen,

No, you can't. You could if each row would carry a row number (by setting
RowFilter property).

 

[Oleg Ogurok]

You most likely need to perform this logic in the code that uses your
DataView.
For example, databound controls such as DataGrid implement their own paging.

Otherwise, use DataView.CopyTo() to copy items into an array, then copy just
the rigth number of records into another array, e.g. ArrayList.

-Oleg.

 

[Marina]

If you need to page your data , try the PagedDataSource class.