Loading

How can I take some datas from dataset

repkin05

I want to take some data from dataset but at the same time I dont want to change dataset's content. For example I take a table to the dataset which holds who have got how many cars and I want to get the datas which have more than 5 car from dataset. How can I send sql command to dataset.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

send2manivannan22y ago
Hi A.Wegierski , You can achive this with following 2 Ways, 1. Filter the Rows using DataView string qury = "NoOfCars > 5" DataView dv= new DataView(); dv.Table = dataTab; dv.RowFilter = qury; 2. Select the Rows using DataTable.Select() which returns the Row Array, string qury = "NoOfCars > 5" DataRow[] result= dataTab.Select(qury); -Manivannan
Andrzej Wegierski22y ago
yourTable.Select(...) method. See help