省级联动

最新推荐文章于 2021-12-25 15:32:00 发布

原创最新推荐文章于 2021-12-25 15:32:00 发布 · 2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#dataset #security #object #string #server

本博客展示了如何使用C#连接数据库并执行SQL查询来获取省份和城市数据，通过数据适配器填充数据列表，实现用户友好的交互。

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

protected void Page_Load(object sender, EventArgs e)
    { 

 if (!IsPostBack)
        {
            

               string str = "server=.;database=exam;Integrated security=true";
                DataSet ds=new DataSet ();
               using (SqlConnection sqlCnn = new SqlConnection(str))
              {
                    using (SqlCommand sqlCmm = new SqlCommand())
                   {
                       sqlCmm.Connection = sqlCnn;
                       sqlCmm.CommandText = "select name,pid from province";
                       SqlDataAdapter da = new SqlDataAdapter(sqlCmm);
                       da.Fill(ds);
                  }
                this.DropDownList1.DataSource = ds.Tables[0];
                this.DropDownList1.DataTextField = "name";
                this.DropDownList1.DataValueField = "pid";

                this.DataBind();

                this.DropDownList1.Items.Insert(0, "--请选择省份--");
                this.DropDownList2.Items.Insert(0, "--请选择城市--");
            }
      }

}

 

 protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string str = "server=.;database=exam;Integrated security=true";
        DataSet ds = new DataSet();
        using (SqlConnection sqlcnn = new SqlConnection(str))
        {
            SqlCommand sqlcmm = sqlcnn.CreateCommand();
            sqlcmm.CommandText ="select cname,pid from city where pid =" + DropDownList1.SelectedValue;
            SqlDataAdapter sda = new SqlDataAdapter(sqlcmm);
            sda.Fill(ds);
        }
        this.DropDownList2.DataSource = ds.Tables[0];
        this.DropDownList2.DataTextField = "cname";
        this.DropDownList2.DataValueField = "pid";
        this.DataBind();
    }