SqlDataRecord.GetSqlValues Method (Object[])


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

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