无刷新下拉实例后台

#region GetDataSet
  public static DataSet GetDataSet(string sql)
  {
   string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["strConnection"];
   SqlDataAdapter sda =new SqlDataAdapter(sql,ConnectionString);
   DataSet ds=new DataSet();
   sda.Fill(ds);
   return ds;
  }
  #endregion

  public static DataSet GetClass1List()
  {
   string sql="select * from qyclass1tb";
   return GetDataSet(sql);
  }
  [AjaxPro.AjaxMethod(AjaxPro.HttpSessionStateRequirement.Read)]
  public  DataSet GetClassList(int sortid)
  {
   string sql="select * from qyclass2tb where sortid="+sortid;
   return GetDataSet(sql);   
  }
  [AjaxPro.AjaxMethod(AjaxPro.HttpSessionStateRequirement.Read)]
  public  DataSet GetCityList(int provinceid)
  {
   //string sql="select * from qyclass2tb where sortid="+sortid;
   //return GetDataSet(sql); 
  
   return Company.ExecuteSQLForDS ("select * from Citytb where proviceid="+provinceid);
   //this.ddlcity.DataTextField ="cityname";
   //this.ddlcity.DataValueField ="cityid";
  }