#region Datatable数据合并
private void XLXG(DataGridView dgv3)
{
try
{
DataTable logs = bl.XGU_xl();//表1 -红色选择部分
DataTable log = bl.XGU_S();//表2 -橙色选择部分
for (int i = logs.Rows.Count - 1; i >= 0; i--)
{
DataRow[] sRow = log.Select("[RouteID]=" + logs.Rows[i]["RouteID"]);
for (int j = sRow.Length - 1; j >= 0; j--)
{
DataRow ro = logs.NewRow();
ro.ItemArray = (object[])sRow[j].ItemArray.Clone();
ro[0] = " (" + ro[0] + ")";
ro[3] = "0";
logs.Rows.InsertAt(ro, i + 1);
}
}
dgv3.DataSource = logs;
DataGdv.Columns[0].FillWeight = 20;
DataGdv.Columns[2].FillWeight = 50;
DataGdv.Columns[3].FillWeight = 30;
DataGdv.Columns[4].FillWeight = 20;
dgv3.Columns[1].Visible = false;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
#endregion!
c# 合并两个DataTable数据到DataGridView
最新推荐文章于 2022-04-13 15:12:24 发布