FillSchema Method (DbDataTable)

In This Topic

Syntax
Remarks
Example
See Also

Configures the schema to match that in the data source.

Syntax

Visual Basic
C#

public void FillSchema()

'Declaration
 
Public Sub FillSchema()

Remarks

Use this method when you need to retrieve structure of a table only, not the data.

The FillSchema method retrieves the schema from the data source using the SelectCommand. The connection object associated with the SelectCommand must be valid, but it does not need to 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.

A FillSchema operation adds columns to the Columns collection of the DbDataTable, and configures DataColumn properties if they exist at the data source. FillSchema also configures the Constraints property.

FillSchema does not return any rows. Use the Fill, FillPage, or Open methods to add rows to a DbDataTable.

For more detailed information, refer to topic System.Data.Common.DataAdapter.FillSchema.

Example

The following example demonstrates how to use the FillSchema property.

csharp

static void UseDataTable(DbDataTable myDataTable, DbConnection myConnection) {

  myDataTable.Connection = myConnection;
  myDataTable.SelectCommand = myConnection.CreateCommand();
  myDataTable.SelectCommand.CommandText = "SELECT * FROM Test.Dept";

  myDataTable.FillSchema();
}

Visual Basic

Private Shared Sub UseDataTable(ByVal myDataTable As DbDataTable, ByVal myConnection As DbConnection)
  myDataTable.Connection = myConnection
  myDataTable.SelectCommand = myConnection.CreateCommand
  myDataTable.SelectCommand.CommandText = "SELECT * FROM Test.Dept"
  myDataTable.FillSchema()
End Sub

Reference

DbDataTable Class
DbDataTable Members
Fill Method
Open Method

Send Feedback