用asp.net做用户登录界面,如何使用从login.aspx中得到的username和密码在login.aspx.cs中与数据库比较?
login.aspx1:<inputclass="loginInput"value=""type="text"size="30"id="login_user"><span...
login.aspx
1:<input class="loginInput" value="" type="text" size="30" id="login_user" ><span class="helpInfor">用户名:admin</span>
2:<input class="loginInput" type="password" size="30"><span class="helpInfor">密码:为空</span>//这句中是否缺少了value?
login.aspx.cs
string name = txtname.Value; string pass = txtpass.Value;
if ((reader["user_name"].ToString()) == name & (reader["password"].ToString() == pass) )
这是代码片断,求指点, 展开
1:<input class="loginInput" value="" type="text" size="30" id="login_user" ><span class="helpInfor">用户名:admin</span>
2:<input class="loginInput" type="password" size="30"><span class="helpInfor">密码:为空</span>//这句中是否缺少了value?
login.aspx.cs
string name = txtname.Value; string pass = txtpass.Value;
if ((reader["user_name"].ToString()) == name & (reader["password"].ToString() == pass) )
这是代码片断,求指点, 展开
展开全部
<form id="form1" name="form2" method="post" action="" runat="server"> <strong dir="ltr">User name</strong><asp:TextBox ID="login_user" name="login_user" runat="server"></asp:TextBox> <br />
<strong dir="ltr">Password</strong><asp:TextBox ID="password" name="password" runat="server"></asp:TextBox>
<asp:Button ID="login" name="login" runat="server" Text="login" onclick="login_Click" />
<p><strong>游客?</strong>
<a href="createuser.aspx"><strong>马上注册!</strong></a>
</p> </form>
以上是表单修改;
下面在login.aspx.cs中与数据库比较:你定义的数据库假设为UserMss
string username = login_user.Text.ToString().Trim();
string passwords = password.Text.ToString().Trim();
string connStr = "server=(local);database=UserMss;user id=GBS;password=1234;";
conn = new SqlConnection(connStr);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand sqlcom = new SqlCommand("select * from users where name='" + username+ "'and psw='" + passwords + "'", Conn); SqlDataReader reader = sqlcom.ExecuteReader();
if (reader.Read())//查找存在,则页面跳转并把当前登录账户信息存入Session
{
this.Session["UserName"] = this.user_name.Text;
this.Session["password"] = this.password.Text;
Response.Redirect("blog.aspx");
}
搞定收工!!!你的分值太少!!!回答你这个问题不值得....
<strong dir="ltr">Password</strong><asp:TextBox ID="password" name="password" runat="server"></asp:TextBox>
<asp:Button ID="login" name="login" runat="server" Text="login" onclick="login_Click" />
<p><strong>游客?</strong>
<a href="createuser.aspx"><strong>马上注册!</strong></a>
</p> </form>
以上是表单修改;
下面在login.aspx.cs中与数据库比较:你定义的数据库假设为UserMss
string username = login_user.Text.ToString().Trim();
string passwords = password.Text.ToString().Trim();
string connStr = "server=(local);database=UserMss;user id=GBS;password=1234;";
conn = new SqlConnection(connStr);
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlCommand sqlcom = new SqlCommand("select * from users where name='" + username+ "'and psw='" + passwords + "'", Conn); SqlDataReader reader = sqlcom.ExecuteReader();
if (reader.Read())//查找存在,则页面跳转并把当前登录账户信息存入Session
{
this.Session["UserName"] = this.user_name.Text;
this.Session["password"] = this.password.Text;
Response.Redirect("blog.aspx");
}
搞定收工!!!你的分值太少!!!回答你这个问题不值得....
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询