关于DropDownList省市二级联动的实现

 

实现DropDownList省市二级联动

本机运行环境：vwd2005 express 、sql server2005

首先，建表

id	level	provinceID	place
	0	1
	0	2
	3	1

id是自增长字段，level是地名级别，0为省名，1为直辖市，2为自治区，3为地级市，provinceID是省名编号。
然后，创建存储过程GetProvince,GetProvinceID,GetCity。
接着，建一个xsd文件，添加GetProvince、GetProvinceID、GetCity方法。
最后，在cs文件中添加代码如下：

using AreaTableAdapters;

public partial class _Default : System.Web.UI.Page

{

   GetProvinceTableAdapter getprovince=new GetProvinceTableAdapter();  

    public string strProvince

        {

            get

            {

                return ddlprovince.SelectedItem.Text;

            }

            set

            {

                ddlprovince.SelectedItem.Value = value;

            }

        }

    protected void Page_Load(object sender, EventArgs e)

    {

        GetProvince();

        ddlcity.Items.Insert(0, "-请选择城市-");      

    }

   

    protected void GetProvince()

    {

        if (!IsPostBack)

        {

            ddlprovince.DataSource = getprovince.GetProvince();

            ddlprovince.DataTextField = "place";

            ddlprovince.DataValueField = "place";

            ddlprovince.DataBind();

            ddlprovince.Items.Insert(0, "-请选择省份-");

        }

    }

    protected int GetProvinceID()

    {

        strProvince = ddlprovince.SelectedItem.Text;

        return(int)getprovince.GetProvinceID(strProvince);

       

    }

    protected void ddlprovince_SelectedIndexChanged(object sender, EventArgs e)

    {

       

            ddlcity.DataSource = getprovince.GetCity(GetProvinceID());

            ddlcity.DataTextField = "place";

            ddlcity.DataValueField = "place";

            ddlcity.DataBind();

     

}

}