SqlDataRecord(SqlMetaData[]) Constructor

Reference

Definition

Namespace:: Microsoft.SqlServer.Server

Assembly:: System.Data.SqlClient.dll

Assembly:: System.Data.dll

Package:: System.Data.SqlClient v4.8.5

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 SqlDataRecord(... cli::array <Microsoft::SqlServer::Server::SqlMetaData ^> ^ metaData);

public SqlDataRecord (params Microsoft.SqlServer.Server.SqlMetaData[] metaData);

new Microsoft.SqlServer.Server.SqlDataRecord : Microsoft.SqlServer.Server.SqlMetaData[] -> Microsoft.SqlServer.Server.SqlDataRecord

Public Sub New (ParamArray metaData As SqlMetaData())

Parameters

metaData: SqlMetaData[]

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

Exceptions

ArgumentNullException

The metaData is null.

Examples

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 });

' Variables.
Dim column1Info As SqlMetaData 
Dim column2Info As SqlMetaData
Dim record As SqlDataRecord

' 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 })

Applies to

Share via