ASP.NET登录验证与数据展示-CSDN博客

本文介绍了一个使用ASP.NET实现的简单登录验证系统及如何从数据库读取并展示学生信息的方法。文中详细展示了如何利用SqlConnection连接数据库，通过SqlCommand执行SQL语句进行用户身份验证，并使用SqlDataReader读取数据。此外，还介绍了如何利用Session存储已登录用户信息，并在后续页面中展示该用户的详细资料。

string id = Request.QueryString["name"]; 
string website = Request.QueryString["website"];

SqlConnection conn; SqlCommand cmd; SqlDataReader rd; conn = new SqlConnection("Data Source=JF508-015;Initial Catalog=NetSchool;Integrated Security=True"); conn.Open(); string sqlStr = @"SELECT * FROM [NetSchool].[dbo].[STUDENT] where USERNAME =" + "'" + name + "'" + "and PASSWORD =" + "'" + pass + "'"; cmd = new SqlCommand(sqlStr, conn); rd = cmd.ExecuteReader();

if (rd.HasRows) {
                rd.Read();
                Session["userName"] = rd["USERID"];
                Response.Redirect("myhome.aspx");
            }
            else
            {
                Label1.Text = "请重新输入用户名和密码";
            }

            rd.Close();
            conn.Close();

            if (Session["userName"] == null)
            {
                Response.Redirect("login.aspx");
            }
            else
            {
                Label1.Text = Session["userName"].ToString();
                Label2.Text = System.DateTime.Now.ToString();
            }

SqlConnection conn;
                SqlCommand cmd;
                SqlDataReader rd;

                string name = Session["userName"].ToString();

                conn = new SqlConnection("Data Source=JF508-015;Initial Catalog=NetSchool;Integrated Security=True");
                conn.Open();
                string sqlStr = @"SELECT *
                                FROM [NetSchool].[dbo].[STUDENT]
                                where USERID =" + name;
                cmd = new SqlCommand(sqlStr, conn);
                rd = cmd.ExecuteReader();
                if (rd.HasRows)
                {
                    Response.Write("<table>");
                    Response.Write("<tr><td>编号</td><td>姓名</td><td>密码</td><td>性别</td><td>出生日期</td><td>注册时间</td><td>专业</td><td>备注</td></tr>");
                    while (rd.Read())
                    {
                        Response.Write("<tr> <td>" + rd["USERID"] + "</td>" + "<td>" + rd["USERNAME"] + "</td>" + "<td>" + rd["PASSWORD"] + "</td>" + "<td>" + rd["SEX"] + "</td>" + "<td>" + rd["BIRTHDAY"] + "</td>" + "<td>" + rd["REGTIME"] + "</td>" + "<td>" + rd["SPECIALTY"] + "</td>" + "<td>" + rd["REMARK"] + "</td>" + "</tr>");                    
                    }
                    Response.Write("</table>");
                }
                else
                {
                    Label1.Text = "请重新输入用户名和密码";
                }

                rd.Close();
                conn.Close();

SqlConnection conn;
SqlCommand cmd;
SqlDataReader rd;
string name = Session["userName"].ToString();
conn = new SqlConnection("Data Source=JF508-015;Initial Catalog=NetSchool;Integrated Security=True");
conn.Open();
string sqlStr = @"SELECT *
FROM [NetSchool].[dbo].[STUDENT]
where USERID =" + name;
cmd = new SqlCommand(sqlStr, conn);
rd = cmd.ExecuteReader();
if (rd.HasRows)
{
	Response.Write("<table>");
	Response.Write("<tr><td>编号</td><td>姓名</td><td>密码</td><td>性别</td><td>出生日期</td><td>注册时间</td><td>专业</td><td>备注</td></tr>");
	while (rd.Read())
	{
		Response.Write("<tr> <td>" + rd["USERID"] + "</td>" + "<td>" + rd["USERNAME"] + "</td>" + "<td>" + rd["PASSWORD"] + "</td>" + "<td>" + rd["SEX"] + "</td>" + "<td>" + rd["BIRTHDAY"] + "</td>" + "<td>" + rd["REGTIME"] + "</td>" + "<td>" + rd["SPECIALTY"] + "</td>" + "<td>" + rd["REMARK"] + "</td>" + "</tr>");                    
	}
    Response.Write("</table>");
}
else
{
	Label1.Text = "请重新输入用户名和密码";
}
rd.Close();
conn.Close();

string id = Request.QueryString["name"]; 
string website = Request.QueryString["website"];