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.
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
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With