IDBSchemaProviderEx.LoadColumns(SqlDataConnection, DBTable[]) Method

Loads columns from the specified tables.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v18.2.dll

Declaration

C#

void LoadColumns(
    SqlDataConnection connection,
    params DBTable[] tables
)

VB.NET

Sub LoadColumns(
    connection As SqlDataConnection,
    ParamArray tables As DBTable()
)

Parameters

Name	Type	Description
connection	SqlDataConnection	An SqlDataConnection object, specifying a connection to a data store.
tables	DBTable[]	An array of DBTable objects, specifying tables that contain the columns to load.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the LoadColumns(SqlDataConnection, DBTable[]) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

data-source-wizard-how-to-display-a-list-of-available-tables-after-data-base-selection-t279129/CS/DSWizardQueryTables/ConfigureQueryPageEx.cs#L44

if (dbTable != null) {
    schemaProvider.LoadColumns(Model.DataConnection, dbTable);
    result = SelectQueryFluentBuilder.AddTable(e.TableName)

VB.NET

data-source-wizard-how-to-display-a-list-of-available-tables-after-data-base-selection-t279129/VB/DSWizardQueryTables/ConfigureQueryPageEx.vb#L47

If dbTable IsNot Nothing Then
    schemaProvider.LoadColumns(Model.DataConnection, dbTable)
    result = SelectQueryFluentBuilder.AddTable(e.TableName).SelectColumns(dbTable.Columns.Select(Function(c) c.Name).ToArray()).Build(e.TableName)