filtering dataset and saving the resultant in another table.
-
hi i have a dataset which consists of one tables. i need to filter this data set and store it in another table. how can i do this?
A dataset allows you to set a filter. Then I'm not sure if there's a quicker way than just to iterate over the records and store them.
Christian Graus Driven to the arms of OSX by Vista.
-
A dataset allows you to set a filter. Then I'm not sure if there's a quicker way than just to iterate over the records and store them.
Christian Graus Driven to the arms of OSX by Vista.
Hi .. There is a quicker way ... use the Select Method of the DataTable
ds.Tables[0].Select(filterExpression);
... read this MSDN article regarding the Select method ... it will help you ... http://msdn.microsoft.com/en-us/library/det4aw50.aspx[^] Hope this helps ...
Sincerely Samer Abu Rabie Note: Please remember to rate this post to help others whom reading it.
-
hi i have a dataset which consists of one tables. i need to filter this data set and store it in another table. how can i do this?
Use a dataview to do the filtering and you can copy the filtered dataview to a new table (dvData.CopyTable I think)
Never underestimate the power of human stupidity RAH