Fastest way to clone a dataset with filter

[Danny Ni]

Hi,

I would like to know the fastest way to clone a dataset with filter inVB.Net
or C#. Say I have a dataset that has one datatable having several data rows.
I want to clone the structure to another dataset but with selection of
datarows.


Please Help!

 

[Chris Botha]

Hope this is the fastest:

Dim theTable as DataTable = theDataSet.Tables(0)
Dim secondTable As DataTable = theTable.Clone()
theTable.DefaultView.RowFilter = "SomeColumn=123" ' If integer
Dim oneRowView As DataRowView
For Each oneRowView In theTable.DefaultView
secondTable.ImportRow(oneRowView.Row)
Next
Dim newDataSet as DataSet = new DataSet
newDataSet.Tables.Add(secondTable)

 

[Onin Tayson]

Hi,

This might be one of the fastest (and shortest code) method to do that.

newDs.Merge(origDs.Tables[0].Select("filterExpression"));

the newDs will be your clone DS that contains the filtered DataRows.

HTH,