DataTable Problems

[Tamer_Ahmed]

hi every one i have a problem let me explain what happend

let's say i have DataTable contain Products from productID number 1 to 20

and this Table called DT1

and DT2 from 15 To 40

and DT3 from 30 To 70

i want to get this data from the 3 Tables and put it in one table called DT4

put i don't want to put the same product twice

ofcourse this is not my case but this was example for what i need to do hope anybody can help

[Diesel]

I know of two ways...

 

Attach the tables to seperate datasets and merge the datasets.

Here's an (crappy) article about that

http://www.dotnetbips.com/displayarticle.aspx?id=94

 

Or just load all of the rows from the tables into the first table or a new table using ImportRow member function.

Little example:

 

    
 For i As Integer = 0 To dt.Rows.Count()
           dt2.ImportRow(dt.Rows(i))
       Next

[Robby]

Do all three tables have the same schema, are they coming from the same database store?

[Tamer_Ahmed]

yeah robby the have the same schema