两个 DataTable 的合并

最新推荐文章于 2024-08-20 14:24:59 发布

零-点

最新推荐文章于 2024-08-20 14:24:59 发布

阅读量688

点赞数

分类专栏： .NET 文章标签： object table string

本文链接：https://blog.csdn.net/zhang399401/article/details/6857711

版权

.NET 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

两个结构一样的DataTable合并

DataTable DataTable1 = new DataTable();    
DataTable DataTable2 = new DataTable();    
DataTable newDataTable = DataTable1.Clone();    
  
object[] obj = new object[newDataTable.Columns.Count];    
for (int i = 0; i < DataTable1.Rows.Count; i++)    
{    
    DataTable1.Rows[i].ItemArray.CopyTo(obj,0);    
    newDataTable.Rows.Add(obj);    
}    
for (int i = 0; i < DataTable2.Rows.Count; i++)    
{    
    DataTable2.Rows[i].ItemArray.CopyTo(obj,0);    
    newDataTable.Rows.Add(obj);    
}

 //或者   
DataTable DataTable1 = new DataTable();    
DataTable DataTable2 = new DataTable();    
  
object[] obj = new object[DataTable1 .Columns.Count];    
for (int i = 0; i < DataTable2.Rows.Count; i++)    
{    
    DataTable2.Rows[i].ItemArray.CopyTo(obj,0);    
    DataTable1.Rows.Add(obj);    
}  
DataTable DataTable1 = new DataTable(); 
DataTable DataTable2 = new DataTable(); 
DataTable newDataTable = DataTable1.Clone(); 
object[] obj = new object[newDataTable.Columns.Count]; 
for (int i = 0; i < DataTable1.Rows.Count; i++) 
{ 
    DataTable1.Rows[i].ItemArray.CopyTo(obj,0); 
    newDataTable.Rows.Add(obj); 
} 
for (int i = 0; i < DataTable2.Rows.Count; i++) 
{ 
    DataTable2.Rows[i].ItemArray.CopyTo(obj,0); 
    newDataTable.Rows.Add(obj); 
}

//或者 
DataTable DataTable1 = new DataTable(); 
DataTable DataTable2 = new DataTable(); 
object[] obj = new object[DataTable1 .Columns.Count]; 
for (int i = 0; i < DataTable2.Rows.Count; i++) 
{ 
    DataTable2.Rows[i].ItemArray.CopyTo(obj,0); 
    DataTable1.Rows.Add(obj); 
}

两个结构不同的DataTable合并

/// <summary>    
/// 将两个列不同的DataTable合并成一个新的DataTable    
/// </summary>    
/// <param name="dt1">Table表1</param>    
/// <param name="dt2">Table表2</param>    
/// <param name="DTName">合并后新的表名</param>    
/// <returns>Table表3</returns>

private DataTable UniteDataTable( DataTable dt1 ,DataTable dt2 ,string DTName)    
{     
   DataTable dt3 = dt1.Clone();    
   for( int i = 0 ;i < dt2.Columns.Count ;i ++ )    
   {    
       dt3.Columns.Add( dt2.Columns[i].ColumnName ) ;    
   }    
   object[] obj = new object[dt3.Columns.Count];    
     
   for (int i = 0; i < dt1.Rows.Count; i++)    
   {    
      dt1.Rows[i].ItemArray.CopyTo(obj,0);    
      dt3.Rows.Add(obj);    
   }    
        
   if( dt1.Rows.Count >= dt2.Rows.Count )    
   {    
      for( int i = 0 ;i < dt2.Rows.Count ;i++ )    
      {    
         for( int j = 0 ;j < dt2.Columns.Count ;j ++ )    
         {    
             dt3.Rows[i][j+dt1.Columns.Count] = dt2.Rows[i][j].ToString() ;    
         }    
      }    
   }    
   else    
   {    
      DataRow dr3 ;    
      for( int i = 0 ;i < dt2.Rows.Count - dt1.Rows.Count ;i ++ )    
      {    
         dr3 = dt3.NewRow() ;    
         dt3.Rows.Add( dr3 ) ;    
      }    
      for( int i = 0 ;i < dt2.Rows.Count ;i++ )    
      {    
         for( int j = 0 ;j < dt2.Columns.Count ;j ++ )    
         {    
             dt3.Rows[i][j+dt1.Columns.Count] = dt2.Rows[i][j].ToString() ;    
         }    
      }    
   }    
   dt3.TableName = DTName ;    
   return dt3 ;    
}