Copy specific Column data from one datatable to another

Farhan Shariff

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
Accepted 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.Count; i++)
{
table2.Rows[i]["Split"] = table1.Rows[i]["Split"];
table2.Rows[i]["D_ID"] = table1.Rows[i]["D_ID"];
}
Farhan Shariff12y ago
Hii Guys :)

Thank you for all the replies .... I will try all the methods
Jignesh Trivedi12y ago
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(1,2,11,12)
Insert into #table1 values(2,2,11,12)
Insert into #table2 values(1,2)
Insert into #table2 values(2,2)
Alter table #table2 Add Split int
Alter table #table2 Add D_ID int
update #table2
set Split = t.Split,D_ID = t.D_ID
from #table1 t where #table2.c#1 = t.c#1 and #table2.C#2 = t.c#2
select * from #table2

Saikiran Gst12y ago

hi 
  Farhan shariff
                
         try this it is usefull for you        

Insert into table1(Split,D_ID)  select Split,D_ID from table2;

Jignesh Trivedi12y ago
hi,

what is relationship between these tables?
you want to perform operation from SQL or C# code?
sudipta sanyal12y ago
*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 < table.Rows.Count; i++)
{
for (int j = 0; j < table.Columns.Count; 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;
}