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.
PgSqlSelectStatement stmt = new PgSqlSelectStatement();
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
PgSqlCommand command = new PgSqlCommand(stmt.ToString());
Dim stmt As New PgSqlSelectStatement
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 PgSqlCommand(stmt.ToString)