Ajax简单示例之改变下拉框动态生成表格

1.建立一个aspx页面，html代码
http://ww***.org/1999/xhtml">http://ww***.org/1999/xhtml" >

   
   


   

    property#region property
    private string ProvinceID
    {
        get
        {
            if (Request["ProvinceID"] != null && Request["ProvinceID"].ToString() != "")
            {
                return Request["ProvinceID"];
            }
            else
            {
                return "";
            }
        }
    }
    #endregion

    GetDataSet#region GetDataSet
    private DataSet GetDataSet(string sql)
    {
        string co***ring=System.Configuration.Co***gurationSettings.AppSettings["ConnectionString"];
        SqlDataAdapter    sda =new SqlDataAdapter(sql,constring);
        DataSet ds=new DataSet();
        sda.Fill(ds);
        return ds;
    }
    #endregion

    GetCityByProvinceID#region GetCityByProvinceID
    private void GetCityByProvinceID(string ProvinceID)
    {
        string connStr = Co***gurationSettings.AppSettings["ConnectionString"];
        SqlConnection conn = new SqlConnection(connStr);
        string sql = "select * from city where father='" + ProvinceID + "'";
        SqlCommand cmd = new SqlCommand(sql, conn);
        co***Open();
        SqlDataReader dr = cm***xecuteReader();

        string s = @"

    ListProvince#region ListProvince
    private void ListProvince()
    {
        string sql = "select * from province";
        DataSet ds = GetDataSet(sql);
        Dr***ownList1.DataSource = ds;
        Dr***ownList1.DataTextField = "province";
        Dr***ownList1.DataValueField = "provinceID";
        Dr***ownList1.DataBind();
    }
    #endregion