V5软件

V5软件!http://www.v5soft.com
  博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

合并两个DataTable

Posted on 2009-12-16 16:46  zhanghw82  阅读(345)  评论(0)    收藏  举报

第一种:

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 dt1 = null, table = new DataTable();           
 DataRow dr;            
table.Columns.Add("Link");
table.Columns.Add("Title");
table.Columns.Add("CutTitleStart");
table.Columns.Add("CutTitleEnd");
table.Columns.Add("CutContentStart");
table.Columns.Add("CutContentEnd");dt1 = [获取]
for (int i = 0; i < dt1.Rows.Count; i++)
{
dr = table.NewRow();
dr["Link"] = dt1.Rows[i]["Link"].ToString();
dr["Title"] = dt1.Rows[i]["Title"].ToString();
dr["CutTitleStart"] = dt1.Rows[i]["CutTitleStart"].ToString();
dr["CutTitleEnd"] = dt1.Rows[i]["CutTitleEnd"].ToString();
dr["CutContentStart"] =dt1.Rows[i]["CutContentStart"].ToString();
dr["CutContentEnd"] = dt1.Rows[i]["CutContentEnd"].ToString();
table.Rows.Add(dr);
}