读取部分xml
来源:互联网 发布:大数据营销与创新答案 编辑:程序博客网 时间:2024/06/06 13:00
自己解决了.不过不知道有没有更好的方法. protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ProvinceFill(); CityFill(); CountyFill(); } } /// /// 用数组存储绑定DataView数据源返回所选字段唯一值 /// /// DataView视图 /// 数组参数 /// 筛选字段 /// 返回column_name唯一值 private ArrayList GetDistinctData(ref DataView dv, ref ArrayList al, string column_name) { bool existed = false; foreach (DataRowView dr in dv) { existed = false; for (int i = 0; i < al.Count; i++) { if (dr[column_name].ToString() == al[i].ToString()) { existed = true; } } if (existed == false) { al.Add(dr[column_name]); } } return al; } /// ///绑定省市数据到控件 /// protected void ProvinceFill() { //清空省市选项 ddlProvince.Items.Clear(); DataSet ds = new DataSet( "Cities "); ds.Clear(); ds.ReadXml(Server.MapPath( "..//App_Data//Citys.xml ")); DataTable dt = ds.Tables[0]; DataView pdv = new DataView(dt); ArrayList pal = new ArrayList(); GetDistinctData(ref pdv, ref pal, "Province "); ddlProvince.DataSource = pal; ddlProvince.DataBind(); } /// /// 绑定所选省市下的城市或地区到控件 /// protected void CityFill() {//清空城市地区选项 ddlCity.Items.Clear(); DataSet ds = new DataSet( "Cities "); ds.Clear(); ds.ReadXml(Server.MapPath( "..//App_Data//Citys.xml ")); DataTable dt = ds.Tables[0]; DataView cdv = new DataView(dt); cdv.RowFilter = "Province= ' " + ddlProvince.SelectedItem.Text + " ' "; ArrayList cal = new ArrayList(); GetDistinctData(ref cdv, ref cal, "City "); ddlCity.DataSource = cal; ddlCity.DataBind(); } /// /// 绑定数据到所选城市或地区管辖下的县市到控件 /// protected void CountyFill() { //清空市县选项 ddlCounty.Items.Clear(); DataSet ds = new DataSet( "Cities "); ds.Clear(); ds.ReadXml(Server.MapPath( "..//App_Data//Citys.xml ")); DataTable dt = ds.Tables[0]; DataView ctdv = new DataView(dt); ctdv.RowFilter = "Province= ' " + ddlProvince.SelectedItem.Text + " ' and City= ' " + ddlCity.SelectedItem.Text + " ' "; ArrayList ctal = new ArrayList(); GetDistinctData(ref ctdv, ref ctal, "County "); ddlCounty.DataSource = ctal; ddlCounty.DataBind(); } protected void ddlProvince_SelectedIndexChanged(object sender, EventArgs e) { CityFill(); CountyFill(); } protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e) { CountyFill(); }
- 读取部分xml
- 读取部分xml
- flash中 读取XML的问题[xml部分]
- flash中读取XML问题[FLASH AS 部分]
- C#读取XML时自动过滤掉注释部分
- XML部分
- 读取XML
- 读取XML
- Xml 读取
- XML读取
- XML读取
- 读取XML
- 读取Xml
- XML读取
- 读取XML
- xml读取
- 读取xml
- 读取XML
- 读取部分xml
- sizeof操作注意事项
- Three linkage menu for Province, City, County
- .net软件工程师面试题(参考答案)
- 面试题2:求子数组的最大和
- 读取部分xml
- Spinner的创建、删除项、添加项
- 如何成为Android高手
- C/C++内存问题检查利器—Purify (二)
- 控件位置的获取
- 【My Ora Life】设置环境变量&Linux指令
- 没有建立索引导致Lock wait timeout exceeded
- 自己动手写缓存系统 - tmcache
- 输出指定字符的下一行