关于asp.net中两个DropDownList之间数据库调用传递选项

最新推荐文章于 2019-04-18 13:55:34 发布

liuningshiwoa

最新推荐文章于 2019-04-18 13:55:34 发布

阅读量525

点赞数

CC 4.0 BY-SA版权

分类专栏：无文章标签： asp.net 数据库 security string null object

本文链接：https://blog.youkuaiyun.com/liuningshiwoa/article/details/6791391

无专栏收录该内容

0 篇文章

订阅专栏

本文详细介绍了如何通过数据库查询获取部门信息，并根据所选部门加载职位列表。代码中使用了SQL连接、参数化查询和数据读取流程，实现了部门与职位的动态加载。

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

private void fillProvince()
    {
        string strCnn = "data source=.;initial catalog=liaotian;integrated security=true";
        SqlConnection sqlCnn = new SqlConnection(strCnn);
        SqlCommand sqlCmm = new SqlCommand();
        sqlCmm.Connection = sqlCnn;
        sqlCmm.CommandText = "SELECT * FROM bumen1";
        SqlDataReader reader = null;
        try
        {
            sqlCnn.Open();
            reader = sqlCmm.ExecuteReader();
            ListItem li;
            while (reader.Read())
            {
                li = new ListItem(reader["部门"].ToString(), reader["id"].ToString());
                this.DropDownList1.Items.Add(li);
            }
        }
        catch
        {
            this.Response.Write("数据库错误");
        }
        finally
        {
            reader.Close();
            sqlCnn.Close();
        }
    }

    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string strCnn = "data source=.;initial catalog=liaotian;integrated security=true";
        SqlConnection sqlCnn = new SqlConnection(strCnn);
        SqlCommand sqlCmm = new SqlCommand();
        sqlCmm.Connection = sqlCnn;
        sqlCmm.CommandText = "SELECT id,职位 FROM zhiwei WHERE pid=@id";
        SqlParameter param = new SqlParameter("@id", System.Data.SqlDbType.Int);
        param.Value = this.DropDownList1.SelectedValue;
        sqlCmm.Parameters.Add(param);
        SqlDataReader reader = null;
        try
        {
            sqlCnn.Open();
            reader = sqlCmm.ExecuteReader();
            this.DropDownList2.DataSource = reader;
            this.DropDownList2.DataTextField = "职位";
            this.DropDownList2.DataValueField = "id";
            this.DropDownList2.Items.Clear();
            this.DropDownList2.Items.Add(new ListItem("--请选择职位--", "0"));
            this.DropDownList2.DataBind();
        }
        catch { throw; }
        finally
        {
            reader.Close();
            sqlCnn.Close();
        }

记住加主键