Copy specific Column data from one datatable to another

Question

I want to copy column data Split and D_ID from table1 to table2 table1 C#1 C#2 C#3 -- --- --- -- --- Split D_ID table2 C#-- C#-- output C#-- C#-- Split D_ID

Vulpes · Answer

To copy the columns themselves without any data you can do: DataColumn dc1 = table1.Columns[Split]; DataColumn dc2 = table1.Columns[D_ID]; table2.Columns.Add(dc1.ColumnName dc1.DataType); table2.Columns.Add(dc2.ColumnName dc2.DataType); Assuming there's a one to one correspondence between the rows in table1 and table2. you can then copy the data with: for(int i = 0; i { table2.Rows[i][Split] = table1.Rows[i][Split]; table2.Rows[i][D_ID] = table1.Rows[i][D_ID]; }

sudipta sanyal · Answer

*Assume both tables have same row protected void Page_Load(object sender EventArgs e) { DataTable table = GetTable1(); DataTable table2 = GetTable2(); DataTable table3 = mergeTable(table table2); } private DataTable mergeTable(DataTable table DataTable table2) { table2.Columns.Add(Split typeof(int)); table2.Columns.Add(D_id typeof(int)); int split_column_index = table2.Columns[Split].Ordinal; int D_id_column_index = table2.Columns[D_id].Ordinal; for (int i = 0; i { for (int j = 0; j { if (table.Columns[j].ToString() == Split) { table2.Rows[i][split_column_index] = table.Rows[i][j].ToString(); } if (table.Columns[j].ToString() == D_id) { table2.Rows[i][D_id_column_index] = table.Rows[i][j].ToString(); } } } return table2; } private DataTable GetTable1() { DataTable table = new DataTable(); table.Columns.Add(C#1 typeof(int)); table.Columns.Add(C#2 typeof(int)); table.Columns.Add(C#3 typeof(int)); table.Columns.Add(C#4 typeof(int)); table.Columns.Add(C#5 typeof(int)); table.Columns.Add(Split typeof(int)); table.Columns.Add(D_id typeof(int)); table.Rows.Add(1 2 3 4 5 6 7); table.Rows.Add(2 3 4 5 6 7 8); table.Rows.Add(3 4 5 6 7 8 9); return table; } private DataTable GetTable2() { DataTable table = new DataTable(); table.Columns.Add(C#1 typeof(int)); table.Columns.Add(C#2 typeof(int)); table.Rows.Add(1 2); table.Rows.Add(2 3); table.Rows.Add(3 4); return table; }

Jignesh Trivedi · Answer

hi try it might help to you create table #table1 ( c#1 int C#2 int Split int D_ID int ) create table #table2 ( c#1 int C#2 int ) Insert into #table1 values(121112) Insert into #table1 values(221112) Insert into #table2 values(12) Insert into #table2 values(22) Alter table #table2 Add Split int Alter table #table2 Add D_ID int update #table2 set Split = t.SplitD_ID = t.D_ID from #table1 t where #table2.c#1 = t.c#1 and #table2.C#2 = t.c#2 select * from #table2

Jignesh Trivedi · Answer

hi what is relationship between these tables? you want to perform operation from SQL or C# code?

Farhan Shariff · Answer

Hii Guys :) Thank you for all the replies .... I will try all the methods

Saikiran Gst · Answer

hi Farhan shariff try this it is usefull for you Insert into table1( SplitD_ID ) select SplitD_ID from table2 ;