UC知道asp.net中一个关于数据集的问题
来源：百度知道 编辑：UC知道 时间：2024/06/07 04:02:21
我做了一个登录窗口，登录代码是这样写的，即使我帐号和密码都正确，结果显示的也是密码不对！不知道为什么？难道是toString()这个函数在作怪吗？
protected void Button1_Click(object sender, EventArgs e)
{
try
{
con.Open();
SqlDataAdapter dt = new SqlDataAdapter("select password from passuser where username='" + TextBox1.Text + "' ";
, con);
dt.Fill(ds, "passuser");
if (TextBox2.Text == ds.Tables[0].Rows[0].ItemArray[0].ToString())
{ Response.write("密码正确！！！"); }
else
{ Response.write("密码错误！！！"); }
}
catch (SqlException ex)
{Response.write(ex.message);}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
con.Open();
SqlDataAdapter dt = new SqlDataAdapter("select password from passuser where username='" + TextBox1.Text + "' ";
, con);
dt.Fill(ds, "passuser");
if (TextBox2.Text == ds.Tables[0].Rows[0].ItemArray[0].ToString())
{ Response.write("密码正确！！！"); }
else
{ Response.write("密码错误！！！"); }
}
catch (SqlException ex)
{Response.write(ex.message);}
}
改成这样试下：
SqlDataAdapter dt = new SqlDataAdapter("select password from passuser where username='" + TextBox1.Text.ToString().Trim() + "' ";
if (TextBox2.Text.ToString().Trim()== ds.Tables["passuser"].Rows[0][[0].ToString().Trim())
把if (TextBox2.Text == ds.Tables[0].Rows[0].ItemArray[0].ToString())
改为if (TextBox2.Text == ds.Tables["passuser"].Rows[0].ItemArray[0].ToString())
试试看