SelectColumnCollection Class
Represents a collection of columns and expressions in a
SelectStatement object.
In the following sample we retrieve a collection of SelectColumns from an SqlSelectStatement 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
SelectColumnCollection collection = statement.Columns;
foreach (SelectColumn column in collection)
Console.WriteLine(column.ToString());
Dim collection As SelectColumnCollection = statement.Columns
For Each column In collection
Console.WriteLine(column.ToString())
Next
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2