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

来源:互联网 发布:电影视听语言分析 知乎 编辑:程序博客网 时间:2024/04/29 06:27

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

Posted on 2011-04-27 10:03 小锋神 阅读(652) 评论(0) 编辑 收藏
?
/**//// <summary>
 /// 填充comboboxB超医师 geovindu@163.com 涂聚文
 ///2009-02-16
 /// </summary>
 privatevoid setDBPyhNameComboBox()
 {
 
     this.combPhy.DataSource =null;
 
     DBConnectioin dbc =new DBConnectioin();
     SqlConnection conn =new SqlConnection(DBConnectioin.conStr);
     conn.Open();
     //DbHelperSQL.setComboList(combPhy, "select PhyID,PhyName  from Physician", "Physician", "PhyName", "PhyID");
     stringsSQL = "select PhyID,PhyName  from Physician";
     stringsTable = "Physician";
 
 
     DataSet dsCourtesy =new DataSet();
     SqlDataAdapter daCourtesy =new SqlDataAdapter();
     DbHelperSQL.setCommand(dsCourtesy, daCourtesy, sSQL, sTable);
     daCourtesy.Fill(dsCourtesy);
     combPhy.DataSource = dsCourtesy.Tables[0].DefaultView;              
     DataRow dr = dsCourtesy.Tables[0].NewRow();
     combPhy.DisplayMember ="PhyName";
     combPhy.ValueMember ="PhyID";            
     dr["PhyName"] ="全部";  
     dr["PhyID"] = -1;  
     dsCourtesy.Tables[0].Rows.InsertAt(dr, 0);
     //combPhy.Text = "全部";
 
 
 }
原创粉丝点击