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