protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
SqlConnection conn = DB.conn();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from sheng", conn);
SqlDataReader sdr = cmd.ExecuteReader();
sheng.DataSource = sdr;
sheng.DataTextField = "sheng";
sheng.DataValueField = "sid";
sheng.DataBind();
sdr.Close(); SqlCommand cmd1 = new SqlCommand("select * from shi where sid=" + sheng.SelectedValue, conn);
SqlDataReader sdr1 = cmd1.ExecuteReader();
shi.DataSource = sdr1;
shi.DataTextField = "shi";
shi.DataValueField = "shiid";
shi.DataBind();
sdr1.Close();
conn.Close(); }
}
没有实现连动,sheng(省)变了shi(市)还是以前的省的市
sheng的AutoPostBack=true
{
if (!Page.IsPostBack)
{
SqlConnection conn = DB.conn();
conn.Open();
SqlCommand cmd = new SqlCommand("select * from sheng", conn);
SqlDataReader sdr = cmd.ExecuteReader();
sheng.DataSource = sdr;
sheng.DataTextField = "sheng";
sheng.DataValueField = "sid";
sheng.DataBind();
sdr.Close(); SqlCommand cmd1 = new SqlCommand("select * from shi where sid=" + sheng.SelectedValue, conn);
SqlDataReader sdr1 = cmd1.ExecuteReader();
shi.DataSource = sdr1;
shi.DataTextField = "shi";
shi.DataValueField = "shiid";
shi.DataBind();
sdr1.Close();
conn.Close(); }
}
没有实现连动,sheng(省)变了shi(市)还是以前的省的市
sheng的AutoPostBack=true
http://blog.csdn.net/insus/archive/2007/11/11/1878690.aspx