protected void Page_Load(object sender, EventArgs e)
{
TextBox2.Text = null; TextBox3.Text = null; TextBox4.Text = null; TextBox5.Text = null; TextBox6.Text = null; TextBox7.Text = null; TextBox8.Text = null;
if (DropDownList1.SelectedValue == "修改" && TextBox9.Text != null)
{
string s1 = TextBox9.Text;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "data source =PC-20140302SAYK;database=职工档案;user id =aaa;password =12345 ";
conn.Open();
TextBox2.Text = s1;
string sql1 = "select 姓名 from 职工信息 where 工号='" + s1 + "'";
string sql2 = "select 性别 from 职工信息 where 工号='" + s1 + "'";
string sql3 = "select 年龄 from 职工信息 where 工号='" + s1 + "'";
string sql4 = "select 部门 from 职工信息 where 工号='" + s1 + "'";
string sql5 = "select 职位 from 职工信息 where 工号='" + s1 + "'";
string sql6 = "select 家庭住址 from 职工信息 where 工号='" + s1 + "'";
string sql7 = "select 联系方式 from 职工信息 where 工号='" + s1 + "'";
SqlCommand sqlCmd1 = new SqlCommand(sql1, conn);
SqlCommand sqlCmd2 = new SqlCommand(sql2, conn);
SqlCommand sqlCmd3 = new SqlCommand(sql3, conn);
SqlCommand sqlCmd4 = new SqlCommand(sql4, conn);
SqlCommand sqlCmd5 = new SqlCommand(sql5, conn);
SqlCommand sqlCmd6 = new SqlCommand(sql6, conn);
SqlCommand sqlCmd7 = new SqlCommand(sql7, conn);
SqlDataReader sdr1 = sqlCmd1.ExecuteReader(); TextBox1.Text = sdr1.Read().ToString().Trim(); sdr1.Close();
SqlDataReader sdr2 = sqlCmd1.ExecuteReader(); TextBox3.Text = sdr2.Read().ToString().Trim(); sdr2.Close();
SqlDataReader sdr3 = sqlCmd1.ExecuteReader(); TextBox4.Text = sdr3.Read().ToString().Trim(); sdr3.Close();
SqlDataReader sdr4 = sqlCmd1.ExecuteReader(); TextBox5.Text = sdr4.Read().ToString().Trim(); sdr4.Close();
SqlDataReader sdr5 = sqlCmd1.ExecuteReader(); TextBox6.Text = sdr5.Read().ToString().Trim(); sdr5.Close();
SqlDataReader sdr6 = sqlCmd1.ExecuteReader(); TextBox7.Text = sdr6.Read().ToString().Trim(); sdr6.Close();
SqlDataReader sdr7 = sqlCmd1.ExecuteReader(); TextBox8.Text = sdr7.Read().ToString().Trim(); sdr7.Close();
conn.Close();
conn.Dispose();
}
}

数据库?