DataRowView
SqlConnection mycon = new SqlConnection(ConfigurationManager.AppSettings["conStr"]);
mycon.Open();
DataSet mydataset = new DataSet();
SqlDataAdapter mydataadapter = new SqlDataAdapter("select * from tb_Admin where id=" + Request["id"],mycon);
mydataadapter.Fill(mydataset, "tb_Admin");
DataRowView rowview = mydataset.Tables["tb_Admin"].DefaultView[0];
this.txtName.Text = Convert.ToString(rowview["UserName"]);
this.txtPwd.Text = Convert.ToString(rowview["PassWord"]);
this.ddlSex.SelectedValue = Convert.ToString(rowview["Sex"]);
this.txtRealName.Text = Convert.ToString(rowview["ReallyName"]);
this.txtBirthday.Text = Convert.ToString(rowview["Birthday"]);
this.txtAddress.Text = Convert.ToString(rowview["Address"]);
this.txtPostCode.Text = Convert.ToString(rowview["PostCode"]);
this.txtQues.Text = Convert.ToString(rowview["Question"]);
this.txtAns.Text = Convert.ToString(rowview["Answer"]);
this.txtEmail.Text = Convert.ToString(rowview["Email"]);
this.txtHphone.Text = Convert.ToString(rowview["HomePhone"]);
this.txtMphone.Text = Convert.ToString(rowview["MobilePhone"]);
this.txtQQ.Text = Convert.ToString(rowview["QQ"]);
this.txtICQ.Text = Convert.ToString(rowview["ICQ"]);
this.TextBox1.Text = Convert.ToString(rowview["RegTime"]);
this.DropDownList1.SelectedValue = Convert.ToString(rowview["SuperAdmin"]);
this.txtIP.Text = Convert.ToString(rowview["IP"]);
mycon.Close();
mycon.Open();
DataSet mydataset = new DataSet();
SqlDataAdapter mydataadapter = new SqlDataAdapter("select * from tb_Admin where id=" + Request["id"],mycon);
mydataadapter.Fill(mydataset, "tb_Admin");
DataRowView rowview = mydataset.Tables["tb_Admin"].DefaultView[0];
this.txtName.Text = Convert.ToString(rowview["UserName"]);
this.txtPwd.Text = Convert.ToString(rowview["PassWord"]);
this.ddlSex.SelectedValue = Convert.ToString(rowview["Sex"]);
this.txtRealName.Text = Convert.ToString(rowview["ReallyName"]);
this.txtBirthday.Text = Convert.ToString(rowview["Birthday"]);
this.txtAddress.Text = Convert.ToString(rowview["Address"]);
this.txtPostCode.Text = Convert.ToString(rowview["PostCode"]);
this.txtQues.Text = Convert.ToString(rowview["Question"]);
this.txtAns.Text = Convert.ToString(rowview["Answer"]);
this.txtEmail.Text = Convert.ToString(rowview["Email"]);
this.txtHphone.Text = Convert.ToString(rowview["HomePhone"]);
this.txtMphone.Text = Convert.ToString(rowview["MobilePhone"]);
this.txtQQ.Text = Convert.ToString(rowview["QQ"]);
this.txtICQ.Text = Convert.ToString(rowview["ICQ"]);
this.TextBox1.Text = Convert.ToString(rowview["RegTime"]);
this.DropDownList1.SelectedValue = Convert.ToString(rowview["SuperAdmin"]);
this.txtIP.Text = Convert.ToString(rowview["IP"]);
mycon.Close();