SelectQuery.SelectColumns(Table, String[]) Method

Selects specified columns from the required data table.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v23.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

public void SelectColumns(
    Table table,
    params string[] columnNames
)

VB.NET

Public Sub SelectColumns(
    table As Table,
    ParamArray columnNames As String()
)

Parameters

Name	Type	Description
table	Table	A Table to which the obtained column belongs.
columnNames	String[]	An array of String values, specifying the names of obtained columns.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the SelectColumns(Table, String[]) 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#

how-to-bind-dashboard-to-sql-server-database-file/CS/BindToMsSqlDatabaseFileExample/Form1.cs#L70

selectQuery.AddRelation(products, categories, "CategoryID");
selectQuery.SelectColumns(orders, new string[] { "OrderDate", "ShipCity", "ShipCountry" });
selectQuery.SelectColumns(order_details, new string[] { "UnitPrice", "Quantity" });

VB.NET

how-to-bind-dashboard-to-sql-server-database-file/VB/BindToMsSqlDatabaseFileExample/Form1.vb#L60

selectQuery.AddRelation(products, categories, "CategoryID")
selectQuery.SelectColumns(orders, New String() { "OrderDate", "ShipCity", "ShipCountry" })
selectQuery.SelectColumns(order_details, New String() { "UnitPrice", "Quantity" })