Create a datatable from a datatable

[Marc]

Hi

using vbnet
is it possible to create a datatable from another datatable using a select
query
So i have a datatable1 with all data

I need to create from datatable1 a new datatable2 select on datatable1

each datatable need to fill a datagridview

manny thanks in advance
Marc

[Michel Posseth [MCP]]

You could easy acomplish this with a dataview object

"Marc" <So******@coco.comschreef in bericht
news:uv**************@TK2MSFTNGP05.phx.gbl...

Hi

using vbnet
is it possible to create a datatable from another datatable using a select
query
So i have a datatable1 with all data

I need to create from datatable1 a new datatable2 select on datatable1

each datatable need to fill a datagridview

manny thanks in advance
Marc

[Marc]

need to do possible update in the datagridview (datatable2)!!

"Michel Posseth [MCP]" <MS**@posseth.comschreef in bericht
news:ee**************@TK2MSFTNGP03.phx.gbl...

You could easy acomplish this with a dataview object

"Marc" <So******@coco.comschreef in bericht
news:uv**************@TK2MSFTNGP05.phx.gbl...

>Hi

using vbnet
is it possible to create a datatable from another datatable using a
select query
So i have a datatable1 with all data

I need to create from datatable1 a new datatable2 select on datatable1

each datatable need to fill a datagridview

manny thanks in advance
Marc

[=?Utf-8?B?S2VycnkgTW9vcm1hbg==?=]

Marc,

Get the rows you need in a dataview and then use the dataview's ToTable
method to create a new datatable from the rows in the dataview.

Kerry Moorman
"Marc" wrote:

need to do possible update in the datagridview (datatable2)!!

"Michel Posseth [MCP]" <MS**@posseth.comschreef in bericht
news:ee**************@TK2MSFTNGP03.phx.gbl...

You could easy acomplish this with a dataview object

"Marc" <So******@coco.comschreef in bericht
news:uv**************@TK2MSFTNGP05.phx.gbl...

Hi

using vbnet
is it possible to create a datatable from another datatable using a
select query
So i have a datatable1 with all data

I need to create from datatable1 a new datatable2 select on datatable1

each datatable need to fill a datagridview

manny thanks in advance
Marc

[Cor Ligthert[MVP]]

Marc,

Not with the select, that creates an array of datarows, however why would
you, you have two other possibilities.

the datatable.Clone (but probably you want a selection and then)

Use the dataview.ToTable(with a lot of overloaded possibilities to (in
versions after 2003) exactly select what you need)

Cor

using vbnet
is it possible to create a datatable from another datatable using a select
query
So i have a datatable1 with all data

I need to create from datatable1 a new datatable2 select on datatable1

each datatable need to fill a datagridview

manny thanks in advance
Marc

[Cor Ligthert[MVP]]

Marc,

"Marc" <So******@coco.comschreef in bericht
news:O7**************@TK2MSFTNGP04.phx.gbl...

need to do possible update in the datagridview (datatable2)!!

And?

"Michel Posseth [MCP]"

>You could easy acomplish this with a dataview object

Cor

[Marc]

Thanks for the possible solutions in yours replies,

Marc..


"Cor Ligthert[MVP]" <no************@planet.nlschreef in bericht
news:92**********************************@microsof t.com...

Marc,

Not with the select, that creates an array of datarows, however why would
you, you have two other possibilities.

the datatable.Clone (but probably you want a selection and then)

Use the dataview.ToTable(with a lot of overloaded possibilities to (in
versions after 2003) exactly select what you need)

Cor

>using vbnet
is it possible to create a datatable from another datatable using a
select query
So i have a datatable1 with all data

I need to create from datatable1 a new datatable2 select on datatable1

each datatable need to fill a datagridview

manny thanks in advance
Marc