string strconn = ConfigurationManager.AppSettings["constr"];
SqlConnection myconn = new SqlConnection(strconn);
myconn.Open();
SqlDataAdapter adapter=new SqlDataAdapter ("select * from LoginUser where UserID="+Request ["UserID"],conn );
DataSet myds = new DataSet();
adapter.Fill(myds, "LoginUser");
DataRowView drv = myds.Tables["LoginUser"].DefaultView[0];
TextBox2.Text = drv["UserName"].ToString();
TextBox3.Text = drv["password"].ToString();
Label1.Visible = true;
Label1.Text = "您当前要修改的表中的第[" + Request.QueryString["UserID"] + "]条记录";
SqlConnection myconn = new SqlConnection(strconn);
myconn.Open();
SqlDataAdapter adapter=new SqlDataAdapter ("select * from LoginUser where UserID="+Request ["UserID"],conn );
DataSet myds = new DataSet();
adapter.Fill(myds, "LoginUser");
DataRowView drv = myds.Tables["LoginUser"].DefaultView[0];
TextBox2.Text = drv["UserName"].ToString();
TextBox3.Text = drv["password"].ToString();
Label1.Visible = true;
Label1.Text = "您当前要修改的表中的第[" + Request.QueryString["UserID"] + "]条记录";
SqlConnection myconn = new SqlConnection(strconn);
myconn.Open();
SqlDataAdapter adapter=new SqlDataAdapter ("select * from LoginUser where UserID="+Request ["UserID"],conn );
DataSet myds = new DataSet();
adapter.Fill(myds, "LoginUser");//myds是一个结果集,myds.Tables["LoginUser"]是一张表,一张表里面有N条记录
DataRowView drv = myds.Tables["LoginUser"].DefaultView[0];//取LoginUser这张表中的视图(虚拟表,数据跟Table一样,DefaultView[0]是取第一条记录,DefaultView[1]是取第二条记录,以此类推)
TextBox2.Text = drv["UserName"].ToString();
TextBox3.Text = drv["password"].ToString();
Label1.Visible = true;
Label1.Text = "您当前要修改的表中的第[" + Request.QueryString["UserID"] + "]条记录";