Question

用asp.net做用户登录界面,如何使用从login.aspx中得到的username和密码在login.aspx.cs中与数据库比较?

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) )
这是代码片断,求指点,

Answer 1

<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");
}
搞定收工！！！你的分值太少！！！回答你这个问题不值得....

Answer 2

if ((reader["user_name"].ToString()) == name & (reader["password"].ToString() == pass) )
and运算 &&，&是二进制的与运算