两个结构相同的DataTbale 合并

 

两条select语句为：

   string sql1="SELECT c_c_Position , c_c_PosDes FROM SeekItem";
   string sql2="SELECT c_c_Position , c_c_PosDes FROM w_CpyClientSeekItemTable";

查询结果保存在olerd1和olerd2中

DataTable table1=new DataTable();
DataTable table2=new DataTable();
DataTable table3=new DataTable();
table3.Columns.Add("c_c_Position");
table3.Columns.Add("c_c_PosDes");
table1=olerd1.Table;
table2=olerd2.Table;
DataRow[] row1=table1.Select();
DataRow[] row2=table2.Select();
int i=0;
int j=0;
for(;i<row2.Length;i++)
...{
    for(;j<row2.Length;)
    ...{
        table3.ImportRow(row2[j]);
        table3.ImportRow(row1[i]);
        j++;
        break;
    }            
}
for(i=row2.Length;i<row1.Length;i++)
...{
    table3.ImportRow(row1[i]);
}

 

合并后的t为able3