insert row into a datatable from other datatable at some particular position

[S Aijaz]

i have table 1 and table 2, both have same schema. i want to insert rows from tabel2 into table1 at some particular position say position 3. how can i do it. with import row it inserts row at the end of the table so it cant help me.

[Hum Dum]

You have to create a third table. And insert in it as you want

[S Aijaz]

how is it possible can u please write some lines of code if possible. i tell you what i want is i want ROW1 from table 1, ROW2 from table 2, ROW3 from table 1 etc. i tried to use insert at and the issue it throw is row belongs to other table.

[Hum Dum]

Select rows you want from table1 insert it into 3rd table. Same for table2. Then you have table3 with rows you want. If you want them in ordered way then you must have unique key on which you can sort table.

[Dave Kreskowiak]

You cannot copy DataRow objects from one DataTable to another unless they have the EXACT same schema. Your better option would be to create a new DataRow in the target table and copy the values you want from the source table.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak

[S Aijaz]

i did it with creating row instance for both the tables (table1 and Table 2) and then set Table1Row.ItemArray = Table2Row.ItemArray; and then added the row to table one at desired location. it worked fine....... thanx for your replies it was of grt help