一个ASP.net登录页面的代码
protected void btnLogin_Click(object sender, EventArgs e)
{
string UID = tbusername.ToString();
string PWD = tbpassword.ToString();
for (int i = 0; i < LimitSelect.Items.Count; i++)
{
if (LimitSelect.Items[i].Selected)
{
Label1.Text = LimitSelect.Items[i].Value;
}
}
string Power = Label1.Text;
string sqlstr = "SELECT username, pwd, Limits FROM UserInfo WHERE (username = '" + UID + "') AND (pwd = '" + PWD + "') AND (Limits = '" + Power + "')"; SqlConnection conn = new SqlConnection(@"Data Source=123-PC\SQLEXPRESS;Initial Catalog=LibraryMS;Integrated Security=True");
SqlCommand cmd = new SqlCommand(sqlstr,conn); if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
SqlDataAdapter sqlcmd = new SqlDataAdapter(sqlstr,conn); if (reader.Read())
{
Session["username"] = UID;
Session["pwd"] = PWD;
Session["Limits"] = Power;
switch (Power)
{
case "0":
Response.Redirect("SysAdmin.aspx");
break;
case "1":
Response.Redirect("Manager.aspx");
break;
case "2":
Response.Redirect("Users.aspx");
break;
default:
Response.Redirect("Customers.aspx");
break;
}
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
string UID = tbusername.ToString();
string PWD = tbpassword.ToString();
for (int i = 0; i < LimitSelect.Items.Count; i++)
{
if (LimitSelect.Items[i].Selected)
{
Label1.Text = LimitSelect.Items[i].Value;
}
}
string Power = Label1.Text;
string sqlstr = "SELECT username, pwd, Limits FROM UserInfo WHERE (username = '" + UID + "') AND (pwd = '" + PWD + "') AND (Limits = '" + Power + "')"; SqlConnection conn = new SqlConnection(@"Data Source=123-PC\SQLEXPRESS;Initial Catalog=LibraryMS;Integrated Security=True");
SqlCommand cmd = new SqlCommand(sqlstr,conn); if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataReader reader = cmd.ExecuteReader();
SqlDataAdapter sqlcmd = new SqlDataAdapter(sqlstr,conn); if (reader.Read())
{
Session["username"] = UID;
Session["pwd"] = PWD;
Session["Limits"] = Power;
switch (Power)
{
case "0":
Response.Redirect("SysAdmin.aspx");
break;
case "1":
Response.Redirect("Manager.aspx");
break;
case "2":
Response.Redirect("Users.aspx");
break;
default:
Response.Redirect("Customers.aspx");
break;
}
}
}
解决方案 »
- 关于母版页
- MVC View中有2个submit,Action中怎么区分。
- 公司要招senior deeloper,ASP网站开发方面的,觉得自己水平不错的可以来看看,最好工作7年以上,待遇还是很不错的
- treeview的问题
- ASPNET如何制作水晶报表
- 哎,越用越迷茫,前台后台分开,都不知道该怎么开发asp.net了.
- 请教关于布署网站的几个问题!!!!
- 如何作到网页里的内容不能被复制和保存,也不能打印
- 表情开发
- **************************请问关于CACHE的问题*********************************
- 有没有网站采集方面C#用的成熟框架啊?(我对html不太熟)
- 这段代码怎样解释---ParameterDirection
我断点查看了一下
reader()里面
Depth = 0
FieldCount = 3
HasRows = false
IsClosed = false
RecordsAffected = -1
VisibleFieldCount = 3
--------
就说明没数据你断点看看 sqlstr ,然后在SQL中执行下
这是断点显示的
string PWD = tbpassword.ToString();
然后我吧tb空间的值都写上了啊,不会没值的
string PWD = tbpassword.Text;
string UID = tbusername.Text;
string PWD = tbpassword.Text;