[RESOLVED] DataTable Filter To Another DataTable

[mickey_pt]

Hello

Need some help, i have a datatable with some data, i need to select some of the data, and put that data in a new datatable.

What's the best way to do this?

[demausdauth]

Dim newTable as DataTable()
Dim dv as new dataview(OldTable)
dv.RowFilter = "Column1 = 'Here' AND Column2 > 2"
newTable = dv.ToTable("NewTableName") 'Also has params for distinct