DataTable.ImportRow Method (DataRow)


The .NET API Reference documentation has a new home. Visit the .NET API Browser on to see the new experience.

Copies a DataRow into a DataTable, preserving any property settings, as well as original and current values.

Namespace:   System.Data
Assembly:  System.Data (in System.Data.dll)

public void ImportRow(
	DataRow row


Type: System.Data.DataRow

The DataRow to be imported.

Calling NewRow adds a row to the table using the existing table schema, but with default values for the row, and sets the DataRowState to Detached. Calling ImportRow preserves the existing DataRowState along with other values in the row. If the DataRow that is passed as a parameter is in a detached state, it is ignored, and no exception is thrown.

The new row will be added to the end of the data table.

If the new row violates a Constraint it won’t be added to the data table.

You can get the index of the new row with as DataTable.Rows.Find and DataTable.Rows.IndexOf. See DataRowCollection and Rows for more information.

.NET Framework
Available since 1.1
Return to top