110,537
社区成员
发帖
与我相关
我的任务
分享
public DataTable Merge(DataTable table1, DataTable table2)
{
DataTable table = new DataTable();
DataRow row = table.NewRow();
row[0] = "编号";
row[1] = "名称1";
row[2] = "名称2";
row[3] = "计算";
table.Rows.Add(row);
for (int i = 0; i < table1.Rows.Count; i++)
{
for (int j = 0; j < table2.Rows.Count; j++)
{
if (table1.Rows[i][0].ToString() == table2.Rows[j][0].ToString())
{
DataRow newRow = table.NewRow();
newRow[0] = table1.Rows[i][0].ToString();
newRow[1] = table1.Rows[i][1].ToString();
newRow[2] = table2.Rows[j][1].ToString();
newRow[3] = Convert.ToInt32(table1.Rows[i][1].ToString()) / Convert.ToInt32(table1.Rows[j][1].ToString());
table.Rows.Add(newRow);
}
}
}
return table;
}
没测过!