downdroplist获得省市的代码_dropdown省和listbox市代码-优快云博客

本文链接：https://blog.youkuaiyun.com/afeibacker/article/details/6493577

本文介绍了一种基于ASP.NET的省市联动下拉框实现方式，通过从数据库中获取省市数据，并在用户选择省份时动态更新城市选项。该方法利用DataSet进行数据存储，并通过DropDownList控件展示选项。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

public void Getprovince()
    {
        ddl1.Items.Add("请选择");
        ddl3.Items.Add("请选择");
        DataSet ds = new DataSetDA().selectData("select * from S_Province");
        for (int i = 0; i < ds.Tables[0].Rows.Count;i++ )
        {
            ddl1.Items.Add(new ListItem( ds.Tables[0].Rows[i]["ProvinceName"].ToString(), ds.Tables[0].Rows[i]["ProvinceID"].ToString()));
            ddl3.Items.Add(new ListItem(ds.Tables[0].Rows[i]["ProvinceName"].ToString(), ds.Tables[0].Rows[i]["ProvinceID"].ToString()));

}

    }

    protected void ddl1_SelectedIndexChanged(object sender, EventArgs e)
    {
        ddl2.Items.Clear();
        if(ddl1.SelectedValue!="请选择")
        {
            int pid = Convert.ToInt32(ddl1.SelectedValue.ToString());
            DataSet ds = new DataSetDA().selectData("select * from S_City where ProvinceID='"+pid+"'");
            for (int i = 0; i < ds.Tables[0].Rows.Count;i++ )
            {
                ddl2.Items.Add(new ListItem(ds.Tables[0].Rows[i]["CityName"].ToString(),ds.Tables[0].Rows[i]["CityID"].ToString()));
            }

        }
        else
        {
            ddl2.Items.Add("");
        }

    }
    protected void ddl2_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void ddl3_SelectedIndexChanged(object sender, EventArgs e)
    {
        ddl4.Items.Clear();
        if (ddl3.SelectedValue != "请选择")
        {
            int pid = Convert.ToInt32(ddl3.SelectedValue.ToString());
            DataSet ds = new DataSetDA().selectData("select * from S_City where ProvinceID='" + pid + "'");
            for (int i = 0; i <ds.Tables[0].Rows.Count; i++)
            {
                ddl4.Items.Add(new ListItem(ds.Tables[0].Rows[i]["CityName"].ToString(), ds.Tables[0].Rows[i]["CityID"].ToString()));
            }

        }
        else
        {
            ddl4.Items.Add("");
        }
    }