'Declaration Public ReadOnly Property OrderBy As SelectColumnCollection
public SelectColumnCollection OrderBy {get;}
'Declaration Public ReadOnly Property OrderBy As SelectColumnCollection
public SelectColumnCollection OrderBy {get;}
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)