Autocad.net/c#.net QQ Group: 193522571 Adding a DataTable collection B to DataTable a merges merge for two or more DataTable with a single-row data-less primary key

1     /// <summary>2     ///Adding a DataTable collection B to DataTable a merges with two or more DataTable that has no primary key for only one single row of data3     /// </summary>4     /// <param name= "Arrorigeon" >A</param>5     /// <param name= "arradded" >B</param>6     /// <returns>the merged DataTable</returns>7      Public StaticSysdatatable Union ( ThisSysdatatable Tborigeon,paramssysdatatable[] tbadded)8     {9Sysdatatable Arrs =Newsysdatatable ();Ten       //Adding a primary key to the Tborigeon table OneTBORIGEON.COLUMNS.ADD ("ID",typeof(int)); Atborigeon.rows[0]["ID"] =1; -Tborigeon.primarykey =Newsystem.data.datacolumn[]{tborigeon.columns["ID"]}; -Arrs =Tborigeon; the       foreach(Sysdatatable DTinchtbadded) -       { -         if(dt. Columns.count >0) -         { +           //Adding a primary key to the DT table -Dt. Columns.Add ("ID",typeof(int)); +Dt. rows[0]["ID"] =1; ADt. PrimaryKey =NewSystem.data.datacolumn[] {dt. columns["ID"] }; at           //Merging Tables -Arrs. Merge (DT,false); -         } -       } -       //set Primary key to empty -Arrs. PrimaryKey =NULL; in       //Delete a temporary primary key -Arrs. Columns.remove ("ID"); to       returnArrs; +}

View Code

Autocad.net/c#.net QQ Group: 193522571 Adding a DataTable collection B to DataTable a merges the merge merge for two or more DataTable with a single-row data-less primary key