A Quick Way to Copy DataRow

最新推荐文章于 2021-09-09 09:58:08 发布

陈亚平

最新推荐文章于 2021-09-09 09:58:08 发布

阅读量1.1k

点赞数

分类专栏： 2. VS .NET

本文链接：https://blog.csdn.net/cyp403/article/details/1112163

版权

2. VS .NET 专栏收录该内容

55 篇文章 1 订阅

订阅专栏

A Quick Way to Copy DataRow

Instead of copying DataRow column by column, the following code copies data in one line from the source to the destination row:


DataTable dtDest = new DataTable();
dtDest = dsActivity.Tables[0].Clone();
foreach(DataRow dr in dsSrc.Tables[0].Rows)
{
 DataRow newRow = dtDest .NewRow();
 newRow.ItemArray = dr.ItemArray;
 dtDest.Rows.Add(newRow);
}

Note: The ImportRow method does the same thing, except that the RowState of source is preserved in the destination, whereas NewRow sets RowState to Added.