'Declaration Public ReadOnly Property OrderBy As SelectColumnCollection
public SelectColumnCollection OrderBy {get;}
'Declaration Public ReadOnly Property OrderBy As SelectColumnCollection
public SelectColumnCollection OrderBy {get;}
SQLiteSelectStatement stmt = new SQLiteSelectStatement(); 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 SQLiteCommand command = new SQLiteCommand(stmt.ToString());
Dim stmt As New SQLiteSelectStatement 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 SQLiteCommand(stmt.ToString)