SqlDataRecord.GetValues 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 common language runtime (CLR) types, in an array.

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

public virtual int GetValues(
	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 CLR type values of the column are copied into the values array that is passed as a parameter. For columns with null value, Value is returned.

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 is copied into the array, starting at the column value with ordinal 0.

.NET Framework
Available since 2.0
Return to top