Anyone know how to get certain no of recirds from a dataView?

[Guest]

I am trying ot get a certain no of records from a DataView. I am looking ot
do like a Top 15 in Sql, Is there a easy way to do this or should I loop till
the count?
Appreciate any help.

 

[Karl Seguin]

I think you have to loop.

Karl

 

[MWells]

I use two approaches;

Form the Sql with the "TOP n" constraint, do the query, and make the
resulting DataTable your data source (if you're using databinding).

When I'm doing pagination, I use DataAdapter.Fill (). As I understand it,
Fill isn't really much more efficient than writing a loop, but the code
looks far cleaner.

 

[Guest]

Thank you all, I finally found the PagedDataSource thru which I cna pick the
no of records I want.