Contains list of columns used in the ORDER BY clause of the current
SelectStatement object.
Property Value
A
SelectColumnCollection that represents list of columns used in the ORDER BY clause.
The following example demonstrates how to use the
OrderBy property.
|
|---|
DB2SelectStatement stmt = new DB2SelectStatement();
SelectColumn empName = new SelectColumn("ENAME");
stmt.Columns.Add(empName);
stmt.Tables.Add(new SelectTable("emp"));
stmt.OrderBy.Add(empName);
//select ENAME from emp order by ENAME
DB2Command command = new DB2Command(stmt.ToString()); |
|
|---|
Dim stmt As New DB2SelectStatement
Dim empName As New SelectColumn("ENAME")
stmt.Columns.Add(empName)
stmt.Tables.Add(New SelectTable("emp"))
stmt.OrderBy.Add(empName)
'select ENAME from emp order by ENAME
Dim command5 As New DB2Command(stmt.ToString) |
