Can you insert a row into TableA fromTableB in the same DATASET? 1

[mb22]

if i have 2 exact SAME tables in a dataset say ... TableA and TableB.

how can I do this?

"INSERT into TableA SELECT * from TableB where Cust_ID=10"

the tables have too many columns for me to add a New row .. and the populate each column for the new row.

sample code will help .. thanks VB.Net

 

[chrissie1]

depends on how many rows you have to copy but put this in a loop and put a dataview on the tableB

datset1.Tables("tableA").Rows.Add(datset1.Tables("TableB").Rows(0))

Christiaan Baes
Belgium

What a wonderfull world - Louis armstrong