GetSchemaTable Method (Sql)

Returns a DataTable containing column metadata for the supplied SQL statement/table name

Declaration Syntax

C#	Visual Basic

public DataTable GetSchemaTable(
	string Sql
)

Public Function GetSchemaTable ( _
	Sql As String _
) As DataTable

Parameters

Sql (String): SQL statement or table name

Return Value

A DataTable

Examples

CopyC#

DbNetData Data = new DbNetData( ConfigurationSettings.AppSettings[ "nwind" ] );
Data.Open();
DataTable SchemaInfo = Data.GetSchemaTable("customers");
foreach ( DataRow R in     SchemaInfo.Rows )
    if (R["ColumnName"].ToString() == "CustomID" )
        if ( (bool)R["IsKey"]  )
            CustomerID.ReadOnly = true;

Assembly: DbNetLink.DbNetSuiteVS (Module: DbNetLink.DbNetSuiteVS) Version: 0.9.3317.16858 (0.9.0.0)