CODEWITHSUNDEEP
asp.netvb.netlinqdatatabledataset
Naveen
Naveen

Reputation: 53

Filtering Dataset based on similar column values

I have a Data in Dataset with 5 columns (ID, col1, col2, col3, col4). I have to filter rows and separate them from main Dataset based on the similar column values. ID column is unique. I have to check the data for the column values in col1, col2, col3 and col4. For example I have 10 records, 5 of them have same column values, 3 of them have same column values other than previous 5 and 2 rows with complete different values. I should now have 4 different datatables with 5, 3, 1 and 1 rows respectively. Theses datatables can be dynamic depending on the data.

Please suggest me the best possible solution.

Upvotes: 0

Views: 725

Answers (1)

Chetan Sanghani
Chetan Sanghani

Reputation: 2111

   Dim myDataView As DataView = New DataView('Your Dataset')           
   myDataView.RowFilter = 'Your Serch Values '

try this

Upvotes: 0

Related Questions