C# winform combobox 在绑定数据之后插入一项选择项

最新推荐文章于 2025-06-17 15:42:35 发布

转载最新推荐文章于 2025-06-17 15:42:35 发布 · 290 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/geovindu/archive/2009/02/16/1391300.html

博客主要展示了C# WinForm中相关代码实现。一是在combobox绑定数据后插入一项选择项，通过数据库连接、数据集填充等操作完成；二是涉及产品目录列表的绑定，包括获取列表、递归绑定子项等，实现下拉列表的多级展示。

/**//// <summary>
2

/// 填充comboboxB超医师 geovindu@163.com 涂聚文
3

///2009-02-16
4

/// </summary>
5

private void setDBPyhNameComboBox()
6

{
7

this.combPhy.DataSource = null;
9

DBConnectioin dbc = new DBConnectioin();
11

SqlConnection conn = new SqlConnection(DBConnectioin.conStr);
12

conn.Open();
13

//DbHelperSQL.setComboList(combPhy, "select PhyID,PhyName from Physician", "Physician", "PhyName", "PhyID");
14

string sSQL = "select PhyID,PhyName from Physician";
15

string sTable = "Physician";
16

DataSet dsCourtesy = new DataSet();
19

SqlDataAdapter daCourtesy = new SqlDataAdapter();
20

DbHelperSQL.setCommand(dsCourtesy, daCourtesy, sSQL, sTable);
21

daCourtesy.Fill(dsCourtesy);
22

combPhy.DataSource = dsCourtesy.Tables[0].DefaultView;
23

DataRow dr = dsCourtesy.Tables[0].NewRow();
24

combPhy.DisplayMember = "PhyName";
25

combPhy.ValueMember = "PhyID";
26

dr["PhyName"] = "全部";
27

dr["PhyID"] = -1;
28

dsCourtesy.Tables[0].Rows.InsertAt(dr, 0);
29

//combPhy.Text = "全部";
30

}

 ProductCatalogListBLL productCatalogListBLL = new ProductCatalogListBLL();
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                BindClass();
            }
        }
        /// <summary>
        /// 
        /// </summary>
        void BindClass()
        {
            List<ProductCatalogListInfo> list = productCatalogListBLL.get_List();
            foreach (ProductCatalogListInfo model in list)
            {
                ListItem li = new ListItem();
                li.Text = "╋" + model.ProductCatalogName;
                li.Value = model.ProductCatalogId.ToString();
                DropDownList1.Items.Add(li);
                BindChild(model.ProductCatalogId.ToString(), "├──");
            }
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="ParentID"></param>
        /// <param name="separator"></param>
        void BindChild(string ParentID, string separator)
        {
            List<ProductCatalogListInfo> list = productCatalogListBLL.get_List(ParentID);
            foreach (ProductCatalogListInfo model in list)
            {
                ListItem li = new ListItem();
                li.Text = separator + model.ProductCatalogName;
                li.Value = model.ProductCatalogId.ToString();
                DropDownList1.Items.Add(li);
                string separator_ = separator + "───";
                BindChild(model.ProductCatalogId.ToString(), separator_);
            }
        }

 /// <summary>
        /// 
        /// </summary>
        /// <returns></returns>
        public List<ProductCatalogListInfo> get_List()
        {
            List<ProductCatalogListInfo> List = new List<ProductCatalogListInfo>();
            DataTable dt = DBHelper.getDataSet("select * from ProductCatalogList where ProductCatalogParent=0 order by ProductCatalogId desc").Tables[0];
            foreach (DataRow dr in dt.Rows)
            {
                ProductCatalogListInfo model = new ProductCatalogListInfo();
                model.ProductCatalogId = Convert.ToInt32(dr["ProductCatalogId"]);
                model.ProductCatalogName = dr["ProductCatalogName"].ToString();
                model.ProductCatalogParent = Convert.ToInt32(dr["ProductCatalogParent"]);
                List.Add(model);
            }
            return List;
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="ParentID"></param>
        /// <returns></returns>
        public List<ProductCatalogListInfo> get_List(string ParentID)
        {
            List<ProductCatalogListInfo> List = new List<ProductCatalogListInfo>();
            DataTable dt = DBHelper.getDataSet("select * from ProductCatalogList where ProductCatalogParent=" + ParentID + " order by ProductCatalogId desc").Tables[0];
            foreach (DataRow dr in dt.Rows)
            {
                ProductCatalogListInfo model = new ProductCatalogListInfo();
                model.ProductCatalogId = Convert.ToInt32(dr["ProductCatalogId"]);
                model.ProductCatalogName = dr["ProductCatalogName"].ToString();
                model.ProductCatalogParent = Convert.ToInt32(dr["ProductCatalogParent"]);
                List.Add(model);
            }
            return List;
        }

转载于:https://www.cnblogs.com/geovindu/archive/2009/02/16/1391300.html