DataRowExtensions.SetField(Of T) Method (DataRow, String, T)


Sets a new value for the specified column in the DataRow. The SetField(Of T) method also supports nullable types.

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

Public Shared Sub SetField(Of T) (
	row As DataRow,
	columnName As String,
	value As T


Type: System.Data.DataRow

The input DataRow, which acts as the this instance for the extension method.

Type: System.String

The name of the column to set the value of.

Type: T

The new row value for the specified column, of type T.

Type Parameters


A generic parameter that specifies the value type of the column.

Exception Condition

The column specified by columnName cannot be found.


Occurs when attempting to set a value on a deleted row.


The value type of the underlying column could not be cast to the type specified by the generic parameter, T.

If value is null, the SetField(Of T) method converts the null value to Value in the underlying DataColumn.

The SetField(Of T) method does not perform any type conversions. This does not mean, however, that a type conversion will not occur. The SetField(Of T) method exposes the ADO.NET 2.0 behavior of the DataRow class. A type conversion could be performed by the DataRow object and the converted value would then be saved to the row.

Exceptions can be passed up through the SetField(Of T) method from the underlying DataRow object.

.NET Framework
Available since 3.5
Return to top