Question

怎样将textbox中输入的值传递到select语句中

Answer 1

cmd.CommandText = "SELECT UserName, Password, Status FROM Users WHERE UserName = '+this.UserName .Text +' ";

改成

string strSql = "SELECT UserName, Password, Status FROM Users WHERE UserName = '"+this.UserName .Text +"' ";
cmd.CommandText = strSql;