dataset and dataview

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I set a dataview to equal a table in a dataset, then filter that dataview,
how can I reflect this back into my dataset?

TIA,
Amber
 
Hi amber,

I take it that you are using a DataView to filter a DataTable, using the
RowFilter property, and want to have all of the rows that are excluded by
the filter to be removed from the underlying DataTable?

There is no intrinsic framework approach so you'll have to loop through each
row of the DataTable and use [DataTable].Rows.Remove(...) on each row that
contains data that is outside of your filter.

Another options is to fill the DataSet again by modifying your data access
'where' clause to provide the same semantics as the row filter.

- Dave Sexton
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cycling through a dataview and adding text 1
Current row in a datagrid/dataview 1
Thread Safety, dataset and dataview, ASP.NET 1
Problem creating "n" DataViews 2
Sorting dataset Columns 4
Sorting a dataset 8
How can I write RowFilter in this situation 2
Datasets, Dataviews and Webpages. 2

Back
Top