Cloning datarow in .net

[afidelino]

I have a dataset with order and orderdetail tables and i want to make a copy of an order table row and for that I will be trying to clone a DataRow (see below) but I have a syntax error referring to the implicit conversion from object to datarow. I don't see a clone or copy method on the DataRow.

[X-Ray]

It depends if it is for the same datatable or that you want to put it in an other datatable. Just add a new row to the order table, then add new rows to the orderdetails, then fill columns with the appropriate values from the original data rows.

Dim drNew As DataRow

'Add Row 0 with Manufactred Product details

dt = dtOrderDetails.Clone

drNew = dtOrderDetails.Rows(0)

dt.ImportRow(drNew)

Be aware that with strongly typed datasets the merge is an important method, while it is in my idea with non typed ones mostly ignored.

[tomstonsils]

To deepcopy a datarow you need the schema which is in the datatable. Therefore I think that the most simple methods are to use or the importrow or the loaddatarow from that. Just add a new row to the order table, then add new rows to the orderdetails, then fill columns with the appropriate values from the original data rows.

[Pauline]

DataTable Clone Method

Clones the structure of a DataTable, including all DataTable schemas and constraints. See comment *1 in the example code. It is not evident how we can clone a row that has, for example, some unique columns.

C1.Data.C1DataRow newRow = c1DataSet1.TableViews["Orders"].AddNew();
newRow["Field1"] = oldRow["Field1"];