How to convert a DataView with RowFilter to a new DataTable?

[Andreas Klemt]

Hello,
I have this:

Dim dv As New DataView(GetUsersAsDataTable())
dv.RowFilter = "brithday >= 1970"

Dim dt As New DataTable
dt = **how to bring my rowfiltered DataView to a new DataTable** ?

When I do
dt = dv.Table
I get my original DataTable so that is unfortunatly not the solution.

Thanks for any help in advance!!
Andreas

 

[Miha Markic]

Hi Andreas,

I don't think that there is a built-in way.
Do it manually in a loop, perhaps.

 

[General Protection Fault]

Hello,
I have this:

Dim dv As New DataView(GetUsersAsDataTable())
dv.RowFilter = "brithday >= 1970"

Dim dt As New DataTable
dt = **how to bring my rowfiltered DataView to a new DataTable** ?

When I do
dt = dv.Table
I get my original DataTable so that is unfortunatly not the solution.

Why do you need it back to a DataTable? You can bind to the DataView
just as easily.

 

[babarmirza]

use DataTable dt = dv.toTable()

that shall solve your problem