SqlDataRecord Constructor (SqlMetaData[])


Inititializes a new SqlDataRecord instance with the schema based on the array of SqlMetaData objects passed as an argument.

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

public SqlDataRecord(
	params SqlMetaData[] metaData


Type: Microsoft.SqlServer.Server.SqlMetaData[]

An array of SqlMetaData objects that describe each column in the SqlDataRecord.

Exception Condition

The metaData is null.

The following example shows how to create a new SqlDataRecord object from two SqlMetaData objects, which indicate the column name and data type.

// Variables.
SqlMetaData column1Info;
SqlMetaData column2Info;
SqlDataRecord record;

// Create the column metadata.
column1Info = new SqlMetaData("Column1", SqlDbType.NVarChar, 12);
column2Info = new SqlMetaData("Column2", SqlDbType.Int);

// Create a new record with the column metadata.      
record = new SqlDataRecord(new SqlMetaData[] { column1Info, 
                                                  column2Info });

.NET Framework
Available since 2.0
Return to top