将一个数据表的列添加到另一个 [英] Adding a Column of one datatable to another

问题描述

嘿，所有这些都需要一个lil帮助排序这个表的循环，似乎没有应用一个工作示例到模型，无论如何在这里它。

Hey all need a lil help sorting a loop for this table out, cant seem to apply a working example to the model, anyway here it goes.

我有2个数据表，每个具有不同的数据和不同的值，唯一的值是日期。第一个表有我想要的一切，除了单列的值（从另一个表）所以我需要将此列合并到第一个表，而不是所有其他数据。

I have 2 datatables, each with different data and different values, the only value in common is the date. The first table has everything I want in it except a single column of values (from the other table) So I need to merge this column onto the first table, not all the other data with it.

所以理想情况下，我会喜欢这样的东西：

So ideally I'd like something that looks like this:

DataTable tbl1; //Assume both are populated
DataTable tbl2;

tbl1.Columns.Add("newcolumnofdata") //Add a new column to the first table

foreach (DataRow dr in tbl.Rows["newcolumnofdata"]) //Go through each row of this new column
{
    tbl1.Rows.Add(tbl2.Rows["sourceofdata"]); //Add data into each row from tbl2's column.
    tbl1.Columns["date"] = tbl2.Columns["date"]; //The date field being the same in both sources
} 

如果有人可以帮助不喜欢它，就像我说我只需要一列，我不需要有其他的数据。干杯。

If anyone can help out wud appreciate it, like I say I just need the one column, I don't need to have the whole of the other datatable. Cheers.

推荐答案

如果第二个表已经有所有的行，但只有一列缺少
它应该是足够的做这样的事情

if the second table already has all rows, but just one column is missing it should be enough to do something like this

DataTable tbl1;
DataTable tbl2;

tbl1.Columns.Add("newCol");

for(int i=0; i<tbl.Rows.Count;i++)
{
   tbl1.Rows[i]["newcol"] = tbl2.Rows[i]["newCol"];
   tbl1.Rows[i]["date"] = tbl2.Rows[i]["date"];
}

这篇关于将一个数据表的列添加到另一个的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！