SqlDataRecord(SqlMetaData[]) SqlDataRecord(SqlMetaData[]) SqlDataRecord(SqlMetaData[]) SqlDataRecord(SqlMetaData[]) Constructor

Definition

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

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