下面的就是简单的查询 这是业务逻辑层的代码 /// /// 获得所有省份 /// /// 返回DataSet类型 public DataSet GetProvinceInfo() { String SQL_SelectPro = "select * from ProvinceDict"; return SQLHelper.SqlHelper.ExecuteDataset(Config.DbConnectionStore.TheInstance.GetConnectionStringUser(), CommandType.Text, SQL_SelectPro); } /// /// 根据省份id返回城市信息 /// /// cityID /// 返回DataSet类型 public DataSet GetProvinceInfoByCityID(int ProvinceID) { String SQL_SelectCity = "select * from CityDict where ProvinceID='" + ProvinceID + "'"; return SQLHelper.SqlHelper.ExecuteDataset(Config.DbConnectionStore.TheInstance.GetConnectionStringUser(), CommandType.Text, SQL_SelectCity);（这是DAl里面的方法） } 这是表示层代码（用dropdownlist） /// /// 加载省信息 /// private void JzProvince() { this.ddlprovince.DataSource = new BLL.NewInfo.TerminalOperator().GetProvinceInfo(); this.ddlprovince.DataTextField = "ProvinceName"; this.ddlprovince.DataValueField = "ProvinceID"; this.ddlprovince.DataBind(); } /// /// 根据省初始化市 /// private void InitCityByProvince() { ddlcity.Items.Clear(); String pid = ddlprovince.SelectedValue; DataSet ds = BLL.NewInfo.TerminalOperator.TheInstance.GetProvinceInfoByCityID(Int32.Parse(pid)); if (ds.Tables[0].Rows.Count > 0) { this.ddlcity.DataSource = ds; this.ddlcity.DataTextField = "CityName"; this.ddlcity.DataValueField = "CityID"; this.ddlcity.DataBind(); } }
