GetSqlValues Method
Collapse the table of content
Expand the table of content

SqlDataRecord.GetSqlValues Method (Object[])


Returns the values for all the columns in the record, expressed as SQL Server types, in an array.

Namespace:   Microsoft.SqlServer.Server
Assembly:  System.Data (in System.Data.dll)

public virtual int GetSqlValues(
	object[] values


Type: System.Object[]

The array into which to copy the values column values.

Return Value

Type: System.Int32

An Int32 that indicates the number of columns copied.

Exception Condition

values is null.


There is a type mismatch.

The SQL Server type values of the column are copied into the values array that is passed as a parameter. For null values, a Sql type instance is returned where the IsNull property is true.

The length of the values array does not need to match the number of columns in the record. If the array length is greater than the number of columns, all of the column values are copied into the array; if it is less, only the array length number of column values are copied into the array, starting at the column value with ordinal 0.

.NET Framework
Available since 2.0
Return to top
© 2015 Microsoft