Visual C#通用模塊開發：后臺管理員模塊[1]

          // 所以使用where 1=1 這樣的語句，避免因無查詢條件而帶來的錯誤
          objCommand.CommandText =" SELECT USERS.USERNAME, USERS.NICKNAME,USERS.USEREMAIL, USERROLE.ROLENAME " +" FROM USERS " + " LEFT JOIN USERROLE ON USERS.USERROLE = USERROLE.ROLELEVEL " +" WHERE 1=1 ";
           if (tbxUserName.Text != "")
               objCommand.CommandText += " AND USERS.USERNAME LIKE @USERNAME";
           if (tbxNickName.Text != "")

文章來源于領測軟件測試網 http://www.kjueaiud.com/