VB.NET - How to write query for dataset - Asked By Ajay on 06-Jun-13 08:21 AM

I just want to write a query to fetch some data from dataset only. For eg: I have already 100 rows in dataset but i need to fetch 40 rows of it from dataset itself. I don't want to disturb the database again.

LINQ is your best bet:

http://blogs.msdn.com/b/adonet/archive/2007/01/26/querying-datasets-introduction-to-linq-to-dataset.aspx

You can also use a dataview and set the dataview's RowFilter property.

could u give me an example
regards 
ajay