和_while (rd.read())-CSDN博客

本文链接：https://blog.csdn.net/Anson14_/article/details/78346718
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"];