DataRowView

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();

转载于:https://www.cnblogs.com/xuchuansong/archive/2011/08/24/2152237.html