选取DropDownList的值,总是第一个值?
DDL1 的项是省份;DDL2的项是城市。现在选择DDL1不同的省份,DDL2显示相应的城市。但每次选择后,刷新页面后所DDL1显示的都是第一个值,不会改变的?
private void Page_Load(object sender, System.EventArgs e)
{
if(!this.IsPostBack )
{ OleDbConnection conn=DB.conn(); string sql="select sheng from city group by sheng";
OleDbDataAdapter da=new OleDbDataAdapter();
OleDbCommand cmd=new OleDbCommand(sql,conn);
conn.Open();
da.SelectCommand =cmd;
DataSet ds=new DataSet();
da.Fill (ds);
this.ddlSheng.DataSource=ds.Tables[0];
this.ddlSheng.DataMember = ds.Tables[0].Columns[0].ToString();
this.ddlSheng.DataValueField = ds.Tables[0].Columns[0].ToString();
this.ddlSheng.DataBind();
ds.Clear();
conn.Close();
}
private void Button1_Click(object sender, System.EventArgs e)
{
this.ddlCity.Items.Clear();
OleDbConnection conn=DB.conn(); //列出DDL1相应的城市
string sheng=this.ddlSheng.SelectedValue ;
this.Label1.Text =""+sheng+"";
string sql="select city from city where sheng='"+sheng+"'";
OleDbDataAdapter da=new OleDbDataAdapter();
OleDbCommand cmd=new OleDbCommand(sql,conn);
conn.Open();
da.SelectCommand =cmd;
DataSet ds=new DataSet();
da.Fill(ds);
this.ddlCity.DataSource=ds.Tables[0];
this.ddlCity.DataMember = ds.Tables[0].Columns[0].ToString();
this.ddlCity.DataValueField = ds.Tables[0].Columns[0].ToString();
this.ddlCity.DataBind();
ds.Clear();
conn.Close();
}
}