我编写的登录按钮代码如下:
protected void login_Click(object sender, EventArgs e)
{
string name = zygs_user.Text;
string pass = zygs_pwd.Text;
try
{
OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Server.MapPath("App_Data/zyq_user.mdb"));
objConn.Open();
string str = "select * from [zygs_user] where [user_ID] =" + name + " and [user_pass] =" + pass + "";
OleDbCommand Comm = new OleDbCommand(str, objConn);
OleDbDataReader rd = Comm.ExecuteReader();
if (rd.Read())
{
string shuyu = rd["user_shuyu"].ToString();
Session["shuyu"] = shuyu;
Session["yonghu"] = name;
Response.Redirect("~/login.aspx");
}
else
{
zygs_user.Text = "";
zygs_pwd.Text = "";
Response.Write("<script>alert(无法登录!)</script>");
err.Text = "用户不存在!";
}
rd.Close();
objConn.Close();
}
catch (Exception ex)
{
err.Text = (ex.Message);
}
}
输入正确的用户和密码后,点击登录按钮,无法跳转到login.aspx页面,err.text老是“至少一个参数没有被指定值。”
请大虾帮忙看看!!
protected void login_Click(object sender, EventArgs e)
{
string name = zygs_user.Text;
string pass = zygs_pwd.Text;
try
{
OleDbConnection objConn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" + Server.MapPath("App_Data/zyq_user.mdb"));
objConn.Open();
string str = "select * from [zygs_user] where [user_ID] =" + name + " and [user_pass] =" + pass + "";
OleDbCommand Comm = new OleDbCommand(str, objConn);
OleDbDataReader rd = Comm.ExecuteReader();
if (rd.Read())
{
string shuyu = rd["user_shuyu"].ToString();
Session["shuyu"] = shuyu;
Session["yonghu"] = name;
Response.Redirect("~/login.aspx");
}
else
{
zygs_user.Text = "";
zygs_pwd.Text = "";
Response.Write("<script>alert(无法登录!)</script>");
err.Text = "用户不存在!";
}
rd.Close();
objConn.Close();
}
catch (Exception ex)
{
err.Text = (ex.Message);
}
}
输入正确的用户和密码后,点击登录按钮,无法跳转到login.aspx页面,err.text老是“至少一个参数没有被指定值。”
请大虾帮忙看看!!
解决方案 »
- rdlc报表导出Excel文件的默认名字能不能在程序中设置?
- Datetime 转换失败【非常邪门】
- 如何使用excel模板实现打印预览的功能
- 抓狂中。。怎样绘制动画线条、或实现类似效果??
- 通过FTP方式下载数据时显示进度条的问题
- 哪何把pictureBox1中的一部分图片拷贝到pictureBox2中去?
- ========请大侠助小弟一把,把这段VB模块里的代码改写成C#放在类文件中,用在winform中。谢谢!!=======
- c#局域网考试系统c/s结构
- 再度求救一下
- SQL语句日期过滤问题。急!急!
- char,varchar,nvarchar的区别?
- sdgsdfgsdfgsdfgdfsg
OleDbDataReader rd = Comm.ExecuteReader();
这句有问题!!
请教该怎么办?!
OleDbDataReader rd = Comm.ExecuteReader();
这句没有问题呀!怎么系统就提示出错呢???
string str = "select * from [zygs_user] where [user_ID] =" + name + " and [user_pass] =" + pass + "";
这句SQL字符串出问题了,修改正确后:
string str = "select * from [zygs_user] where [user_ID] =‘" + name + "’ and [user_pass] =‘" + pass + "’";
就可以了~!!