当前位置:编程学习 > C#/ASP.NET >>

省市区三级如何设置初始值

#region 实现省市区三级
    //数据绑定
    private void BindPro()
    {
        using (SqlConnection con = new SqlConnection("server=.;database=lskj;uid=sa;pwd=sa"))
        {
            con.Open();

            //初始化省

            SqlCommand cmdPro = new SqlCommand("select ProvinceID,ProvinceName from S_Province", con);
            SqlDataReader drPro = cmdPro.ExecuteReader();
            this.ddlProvince.DataSource = drPro;
            this.ddlProvince.DataTextField = "ProvinceName";
            this.ddlProvince.DataValueField = "ProvinceID";
            this.ddlProvince.DataBind();
            drPro.Close();

            //初始化市

            SqlCommand cmdCity = new SqlCommand("select CityID,CityName from S_City where ProvinceID = " + this.ddlProvince.SelectedValue + "", con);
            SqlDataReader drCity = cmdCity.ExecuteReader();
            this.ddlCity.DataSource = drCity;
            this.ddlCity.DataTextField = "CityName";
            this.ddlCity.DataValueField = "CityID";
            this.ddlCity.DataBind();
            drCity.Close();
            //初始化县

            SqlCommand cmdDist = new SqlCommand("select DistrictID,DistrictName from S_District where DistrictID = " + this.ddlCity.SelectedValue + "", con);
            SqlDataReader drDist = cmdDist.ExecuteReader();
            this.ddlDist.DataSource = drDist;
            this.ddlDist.DataTextField = "DistrictName";
            this.ddlDist.DataValueField = "DistrictID";
            this.ddlDist.DataBind();
            drDist.Close();
        }
    }

    protected void ddlProvince_SelectedIndexChanged(object sender, EventArgs e) //DropDownList选中(省改变)产生的事件
    {
        string ProvinceID = this.ddlProvince.SelectedValue;
        using (SqlConnection con = new SqlConnection("server=.;database=lskj;uid=sa;pwd=sa;"))
        {
            con.Open();
            SqlCommand cmdCity = new SqlCommand("select CityID,CityName from S_City where ProvinceID=" + ProvinceID + "", con);
            SqlDataReader drCity = cmdCity.ExecuteReader();
            this.ddlCity.DataSource = drCity;
            this.ddlCity.DataTextField = "CityName";
            this.ddlCity.DataValueField = "CityID";
            this.ddlCity.DataBind();
            this.ddlCity.Items.Insert(0,"-请选择-");
            this.ddlCity.Items[0].Value = "0";
            drCity.Close();
            con.Close();
            ddlCityBind();
        }

    }
    protected void ddlCity_SelectedIndexChanged(object sender, EventArgs e)
    {
        ddlCityBind();
    }

    private void ddlCityBind()
    {
        string CityID = this.ddlCity.SelectedValue;
        using (SqlConnection con = new SqlConnection("server=.;database=lskj;uid=sa;pwd=sa;"))
        {
            con.Open();
            SqlCommand cmdDist = new SqlCommand("select DistrictID,DistrictName from S_District where CityID =" + CityID + "", con);
            SqlDataReader drDist = cmdDist.ExecuteReader();
            this.ddlDist.DataSource = drDist;
            this.ddlDist.DataTextField = "DistrictName";
            this.ddlDist.DataValueField = "DistrictID";
            this.ddlDist.DataBind();
            this.ddlDist.Items.Insert(0, "-请选择-");
            this.ddlDist.Items[0].Value = "0";
            drDist.Close();
        }
    }
    #endregion

请问如何在页面的省市区里都显示“-请选择-” --------------------编程问答-------------------- 兄弟也可以用这个办法试试看
 ListItem a = new ListItem("==请选择==", "0");
 drp_user_Distribution.Items.Add(a);
drp_user_Distribution.SelectedIndex = 0;
 if (ds != null && ds.Tables[0].Rows.Count != 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        ListItem item = new ListItem(ds.Tables[0].Rows[i]["username"].ToString(), ds.Tables[0].Rows[i]["Id"].ToString());
                        drp_user_Distribution.Items.Add(item);
                        drp_usersearch.Items.Add(item);
                        drp_user_Release.Items.Add(item);
                    }
                }
补充:.NET技术 ,  C#
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,