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

  /**
 2        /// 填充comboboxB超医师 geovindu@163.com 涂聚文
 3        ///2009-02-16
 4        ///
 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        }

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12639172/viewspace-553426/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12639172/viewspace-553426/