开发者

Difference between rows.add and importRow

When adding a row to a datatable in vb.net, what is the difference between rows.add and importRow?

Dim dt As DataTable
Dim dr As DataRow

'Add row this way...
dt.rows.add(dr)

'or this way开发者_Go百科.
dt.importRow(dr)


both do same functionality adding row to datatable but the main difference is

    DataTable dt1=new DataTable();
    DataRow dr1=dt1.NewRow();
    DataTable dt2=new DataTable();
    dt2.Rows.Add(dr1); // will give you error already dr1 belongs to another datatable in that                              //case you can do like this
    dt2.ImportRow(dr1); // safe
    dt1.Rows.Add(dr1); // safe as dr1 Row belongs to DataTable1 so no exception raise

hope that will give you an idea..


The suggested answer is incorrect. The MSDN article below shows that dt2.ImportRow(dr1) will NOT import dr1. This is because it is in a detached state. Also dt2 has not schema.

http://msdn.microsoft.com/en-us/library/system.data.datatable.importrow.aspx

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜