public partial class _Default : System.Web.UI.Page
{ protected void Button1_Click(object sender, EventArgs e)
{
if (txtid.Text =="")
{
Response.Write("<script language='javascript'>alert('请输入用户名!!');</script>");
txtid.Focus();
return;
}
if (txtpwd.Text == "")
{
Response.Write("<script language='javascript'>alert('请输入密码!!');</script>");
txtpwd.Focus();
return;
}
try
{
string sqlstr="select count(*) from Login where Userid = '"+txtid.Text+"'and Password = '"+txtpwd.Text+"'";
int count = DBHelper.GetScalar(sqlstr);
if(count==1)
{
Response.Redirect("Default2.aspx"); }
else
{
Response.Write("<script>('登录失败!!!')</script>"); }
}
catch (SqlException ex)
{
Response.Write("<script>('登录失败!!!')</script>"); }
finally
{
DBHelper.Connection.Close();
} }
是不是int count = DBHelper.GetScalar(sqlstr);
这段的问题啊???求高手指点
{ protected void Button1_Click(object sender, EventArgs e)
{
if (txtid.Text =="")
{
Response.Write("<script language='javascript'>alert('请输入用户名!!');</script>");
txtid.Focus();
return;
}
if (txtpwd.Text == "")
{
Response.Write("<script language='javascript'>alert('请输入密码!!');</script>");
txtpwd.Focus();
return;
}
try
{
string sqlstr="select count(*) from Login where Userid = '"+txtid.Text+"'and Password = '"+txtpwd.Text+"'";
int count = DBHelper.GetScalar(sqlstr);
if(count==1)
{
Response.Redirect("Default2.aspx"); }
else
{
Response.Write("<script>('登录失败!!!')</script>"); }
}
catch (SqlException ex)
{
Response.Write("<script>('登录失败!!!')</script>"); }
finally
{
DBHelper.Connection.Close();
} }
是不是int count = DBHelper.GetScalar(sqlstr);
这段的问题啊???求高手指点
Password = '"+txtpwd.Text+"'"; 这里很明显引号打错了