C# winform combobox 在绑定数据之后插入一项选择项
1 /// <summary>
2 /// 填充comboboxB超医师 geovindu@163.com 涂聚文
3 ///2009-02-16
4 /// </summary>
5 private void setDBPyhNameComboBox()
6 {
7
8 this.combPhy.DataSource = null;
9
10 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
17
18 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
31
32 }
2 /// 填充comboboxB超医师 geovindu@163.com 涂聚文
3 ///2009-02-16
4 /// </summary>
5 private void setDBPyhNameComboBox()
6 {
7
8 this.combPhy.DataSource = null;
9
10 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
17
18 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
31
32 }
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; }
哲学管理(学)人生, 文学艺术生活, 自动(计算机学)物理(学)工作, 生物(学)化学逆境, 历史(学)测绘(学)时间, 经济(学)数学金钱(理财), 心理(学)医学情绪, 诗词美容情感, 美学建筑(学)家园, 解构建构(分析)整合学习, 智商情商(IQ、EQ)运筹(学)生存.---Geovin Du(涂聚文)