大哥~我要截个助
本帖最后由 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 + "'";