SelectColumnCollection Class

Represents a collection of columns and expressions in a SelectStatement object.

For a list of all members of this type, see SelectColumnCollection members.

Inheritance Hierarchy

System.Object
System.Collections.CollectionBase
Devart.Common.SelectColumnCollection

Syntax

[Visual Basic]
Public NotInheritable Class SelectColumnCollection 
   Inherits CollectionBase
   Implements ICollection, IEnumerable, IList

[C#]
public sealed class SelectColumnCollection : CollectionBase, ICollection, IEnumerable, IList

Remarks

Use SelectColumnCollection class to manage columns used in a query. To access the collection use the SelectStatement.Columns, SelectStatement.GroupBy and SelectStatement.OrderBy properties.

Example

In the following sample we retrieve a collection of SelectColumns from an OracleSelectStatement object and print them. For example, if statement represents the command:

SELECT test.dept.dname Department, test.dept.loc Location
    FROM test.dept

the output of the sample would be the following:

test.dept.dname Department
test.dept.loc Location

[C#]

SelectColumnCollection collection = statement.Columns; 
 
foreach (SelectColumn column in collection)          
    Console.WriteLine(column.ToString());

[Visual Basic]

Dim collection As SelectColumnCollection = statement.Columns
 For Each column In collection
     Console.WriteLine(column.ToString())
 Next

See Also

Language