DbDataAdapter.FillSchema Method

asp.net.ph

System.Data.Common Namespace DbDataAdapter Class

Loads a DataTable to a DataSet and configures the schema to match that in the data source.

1. 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 ] Overloads Overrides Public Function FillSchema ( DataSet, SchemaType ) As DataTable ( )

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

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

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

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

[ VB ] Overloads Public Function FillSchema ( DataTable, SchemaType ) As DataTable

[ C# ] public DataTable FillSchema ( DataTable, SchemaType );

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

[ JScript ] public function FillSchema ( DataTable, SchemaType ) : DataTable;

3. Loads a DataTable to the specified DataSet and configures the schema of the table based on the specified SchemaType and the given source table.

[ VB ] Overloads Public Function FillSchema ( DataSet, SchemaType, String ) As DataTable ( )

[ C# ] public DataTable [ ] FillSchema ( DataSet, SchemaType, string );

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

[ JScript ] public function FillSchema ( DataSet, SchemaType, String ) : DataTable [ ];

NOTE: This example uses one of the overloaded versions of FillSchema. For other examples that may be available, see the individual overload topics.

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

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

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

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

C#

VB

DbDataAdapter Members

Saturday, January 11, 2025

DbDataAdapter.FillSchema Method

Overload List

Example

See Also