Filtering Dataset
-
Good Morning, i have a problem! i'd like to filter a dataset but return one dataset object and no one datarow object. ex: DataRow[] dRow = dslocation.Tables[0].Select("text <> 'Any'"); i dont want it. Please help me! :-D Thanks a lot!
-
Good Morning, i have a problem! i'd like to filter a dataset but return one dataset object and no one datarow object. ex: DataRow[] dRow = dslocation.Tables[0].Select("text <> 'Any'"); i dont want it. Please help me! :-D Thanks a lot!
-
You need to use a DataView. So something like: DataView dv = dslocation.Tables[0].DefaultView; dv.RowFilter = "Text <> 'Any'" The rows of the DataView will exclude any row has a column text that matches 'Any'. Hope that helps. Ben
Thanks a lot, but i'd like to put this filters rows in dataset again, only filters rows. :^) thanks again!