SqlSelectStatement stmt = new SqlSelectStatement(); stmt.Columns.Add(new SelectColumn("ENAME")); stmt.Tables.Add(new SelectTable("emp")); stmt.Where = "1000 < SAL AND SAL < 1500 OR JOB = 'SALESMAN'"; SqlCommand command = new SqlCommand(stmt.ToString());
Dim stmt As New SqlSelectStatement stmt.Columns.Add(New SelectColumn("ENAME")) stmt.Tables.Add(New SelectTable("emp")) stmt.Where = "1000 < SAL AND SAL < 1500 OR JOB = 'SALESMAN'" Dim command As New SqlCommand(stmt.ToString)