Is this possible?

[Guest]

Hi,
I am populating a dataset from a webservice. One one page of my app I need
to get only the first 5 rows from the dataset to pupulate a datagrid and on
another page I then will display all the rows from that dataset in a grid. Is
it possible to select a specific amount of rows from the dataset? Please
don't tell me to use the TOP in a select statement. Remember I am calling a
webservice.

Thanks

I am posting this also in the ado.net section

 

[Steve C. Orr [MVP, MCSD]]

Once you have the DataSet you can filter out any rows you want using a
DataView.

If you want the web service to only send 5 rows, then the web service must
support such custom functionality.

 

[Jeffrey Palermo [MCP]]

I agree with Steve in using a DataView. I was also add that caching the
DataSet would be a good idea since you are using it on multiple pages.

--
Best regards,
Jeffrey Palermo
Blog: http://dotnetjunkies.com/weblog/jpalermo