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/，如需轉載，請註明出處，否則將追究法律責任。