System.Data.Common Namespace   DbDataAdapter Class

Loads a DataTable to the specified DataSet and configures the schema of the table to match that in the data source based on the specified SchemaType.

[ VB ]
Overrides Overloads Public Function FillSchema ( _
   ByVal dataSet As DataSet, _
   ByVal schemaType As SchemaType _
) As DataTable ( )

[ C# ]
public override DataTable [ ] FillSchema (
   DataSet dataSet,
   SchemaType schemaType
);

[ C++ ]
public: DataTable* FillSchema (
   DataSet* dataSet,
   SchemaType schemaType
 ) [ ];

[ JScript ]
public override function FillSchema (
   dataSet : DataSet,
   schemaType : SchemaType
) : DataTable [ ];

dataSet

The DataSet to be filled with the schema from the data source.

schemaType

One of the SchemaType values.

A reference to a collection of DataTable objects that were added to the DataSet.

This version of the FillSchema method adds a DataTable to a given DataSet object, and configures the table structure or schema to match that in the data source based on the given SchemaType.

When using FillSchema, the associated connection object need not be open. If the connection is closed before FillSchema is called, it is opened to retrieve data, then closed. If the connection is open before FillSchema is called, it remains open.

FillSchema also configures the PrimaryKey and Constraints properties of the specified table, if they exist at the data source.

FillSchema does not return any rows. To add rows to the DataTable, use the Fill method instead.

For more information, see Using the FillSchema Method.

The following example shows using FillSchema to retrieve the schema information of a DataSet using this constructor.

void FillSchemaDemo ( ( ) {
   // . . . code to initialize DataAdapter and DataSet here . . .

   DataTable [ ] myTableArray = myDataAdapter.FillSchema (
      myDataSet, SchemaType.Mapped );
}

Public Sub FillSchemaDemo ( ( )
   ' . . . code to initialize DataAdapter and DataSet here . . .

   Dim myTableArray As DataTable ( ) = myDataAdapter.FillSchema ( _
      myDataSet, SchemaType.Mapped )
End Sub

DbDataAdapter Members   Fill   DbDataAdapter.FillSchema Overload List