if (!IsPostBack)
{
//创建数据库连接,根据线路编号读取线路信息 SqlConnection conn = new SqlConnection("server=CHENXI;uid=sa;pwd=sa;database=travel");
conn.Open();
SqlCommand cmd = new SqlCommand("select * from area", conn);
SqlDataAdapter ad = new SqlDataAdapter();
ad.SelectCommand = cmd;
DataSet ds = new DataSet();
ad.Fill(ds);
dropscene.DataSource = ds;
dropscene.DataTextField = "areaname";
dropscene.DataValueField = "areaid";
dropscene.DataBind(); SqlCommand cmd1 = new SqlCommand("select sname,areaname,scene.areaid,splace,show from scene,area where scene.areaid=area.areaid and sid='" + Request["sid"] + "'", conn);
SqlDataAdapter ad1 = new SqlDataAdapter();
ad1.SelectCommand = cmd1;
DataSet ds1 = new DataSet();
ad1.Fill(ds1);
DataRowView rowview = ds1.Tables[0].DefaultView[0];
sname.Text = rowview["sname"].ToString();
dropscene.SelectedItem.Text = rowview["areaname"].ToString();
dropscene.SelectedItem.Value = rowview["areaid"].ToString();
splace.Text = rowview["splace"].ToString();
show.Text = rowview["show"].ToString();
{
//创建数据库连接,根据线路编号读取线路信息 SqlConnection conn = new SqlConnection("server=CHENXI;uid=sa;pwd=sa;database=travel");
conn.Open();
SqlCommand cmd = new SqlCommand("select * from area", conn);
SqlDataAdapter ad = new SqlDataAdapter();
ad.SelectCommand = cmd;
DataSet ds = new DataSet();
ad.Fill(ds);
dropscene.DataSource = ds;
dropscene.DataTextField = "areaname";
dropscene.DataValueField = "areaid";
dropscene.DataBind(); SqlCommand cmd1 = new SqlCommand("select sname,areaname,scene.areaid,splace,show from scene,area where scene.areaid=area.areaid and sid='" + Request["sid"] + "'", conn);
SqlDataAdapter ad1 = new SqlDataAdapter();
ad1.SelectCommand = cmd1;
DataSet ds1 = new DataSet();
ad1.Fill(ds1);
DataRowView rowview = ds1.Tables[0].DefaultView[0];
sname.Text = rowview["sname"].ToString();
dropscene.SelectedItem.Text = rowview["areaname"].ToString();
dropscene.SelectedItem.Value = rowview["areaid"].ToString();
splace.Text = rowview["splace"].ToString();
show.Text = rowview["show"].ToString();
==去掉这行。
dropscene.SelectedItem.Value = rowview["areaid"].ToString();========>
dropscene.SelectedValue = Request["sid"] ;
可以的话我想交个朋友。。^_^ 376612260(最流行的QQ)