Question

关于登陆语句的!ASP.NET2.0+SQL Server2005

string conn = "server=.;database=shiyan;uid=sa;pwd=123456";
SqlConnection cn = new SqlConnection(conn);
cn.Open();
string strsql = "select * from [user] where username='" +Username .Text + "' and userpad'" + password.Text + "'";
SqlCommand cmd = new SqlCommand(strsql, cn);
SqlDataReader dr = cmd.ExecuteReader();//总说123456附近有语法错误！也不知道哪错了！
我很急要,谢谢!大家!

Answer 1

userpad'" + password.Text + "'";
这里少个=
userpad='" + password.Text + "'";
给我分啊