UC知道asp.net登录问题
来源：百度知道 编辑：UC知道 时间：2024/05/08 18:56:56
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("server=127.0.0.1;database=ShopDB;uid=sa;pwd=");
try
{
conn.Open();
}
catch (SqlException sqle)
{
MessageBox.Show(sqle.ToString());
}
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand("select * from users where username = " + TextBox1.Text + " and pwd =" + TextBox2.Text + "", conn);
SqlDataAdapter ada = new SqlDataAdapter(cmd);
ada.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
Response.Redirect("GoodList.aspx");
}
}
当我输入用户名：cjp 密码：cjpyll时，报列cjp，cjpyll无效的错误，可它们根本就不是列啊，我刚学asp.net，哪位大侠帮帮忙，谢谢了！
{
SqlConnection conn = new SqlConnection("server=127.0.0.1;database=ShopDB;uid=sa;pwd=");
try
{
conn.Open();
}
catch (SqlException sqle)
{
MessageBox.Show(sqle.ToString());
}
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand("select * from users where username = " + TextBox1.Text + " and pwd =" + TextBox2.Text + "", conn);
SqlDataAdapter ada = new SqlDataAdapter(cmd);
ada.Fill(ds);
if (ds.Tables[0].Rows.Count > 0)
{
Response.Redirect("GoodList.aspx");
}
}
当我输入用户名：cjp 密码：cjpyll时，报列cjp，cjpyll无效的错误，可它们根本就不是列啊，我刚学asp.net，哪位大侠帮帮忙，谢谢了！
SqlCommand cmd = new SqlCommand("select * from users where username = '" + TextBox1.Text + "' and pwd ='" + TextBox2.Text + "'", conn);
username 在数据库中应该是varchar或nvarchar这是字符型，在用Sql查询时字符应该加上单引号'' 。还有你返回登陆信息用SqlDataAdapter太影响性能了吧，如果只是报告登陆成功建议把SqlDataAdapter相关语句改成
int i = Convert.ToInt32(cmd.ExecutScalar());
//如果i > 0就是登陆成功了