大哥~我要截个助
本帖最后由 mszhdqlee 于 2012-12-11 14:11:22 编辑 出现 列名 password错误 请问为啥呀，新手问题
行 34: cmd.CommandText = "select * from admin where password='" + this.password.Text + "'";
行 35: //cmd.Connection = conn;
行 36: string pwd = Convert.ToString(cmd.ExecuteScalar());
行 37: if (this.password.Text == pwd)
行 38: {
protected void addlogin_Click(object sender, EventArgs e)
{
if (username.Text != "" && password.Text !="") {
SqlConnection conn = new SqlConnection();
conn.ConnectionString=ConfigurationManager.ConnectionStrings["con"].ToString();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from admin where username='"+this.username.Text+"'");
cmd.Connection = conn;
int count = Convert.ToInt32(cmd.ExecuteScalar());
if (count > 0)
{
cmd.CommandText = "select * from admin where password='" + this.password.Text + "'";
cmd.Connection = conn;
string pwd = Convert.ToString(cmd.ExecuteScalar());
if (this.password.Text == pwd)
{
Response.Redirect("default.aspx");
}
else {
this.message.Text = "密码不正确";
}
}
else {
Response.Write("请填写用户名和密码");
}
conn.Close();
}
}
[解决办法]
[admin] [password]
关键字 用中括号括起来
cmd.CommandText = "select * from [admin] where [password]='" + this.password.Text + "'";
