SelectColumnCollection Class

In This Topic

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

Syntax

Visual Basic
C#

'Declaration
 
Public NotInheritable Class SelectColumnCollection 
   Inherits System.Collections.CollectionBase
   Implements System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.IList

public sealed class SelectColumnCollection : System.Collections.CollectionBase, System.Collections.ICollection, System.Collections.IEnumerable, System.Collections.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 DB2SelectStatement 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

csharp

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

Inheritance Hierarchy

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

Reference

SelectColumnCollection Members
Devart.Common Namespace

Send Feedback