ITPub博客

首页 > Linux操作系统 > Linux操作系统 > C# winform combobox 在绑定数据之后插入一项选择项

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

原创 Linux操作系统 作者:iDotNetSpace 时间:2009-02-16 13:54:43 0 删除 编辑
  /**////
 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-01-04

  • 博文量
    2376
  • 访问量
    5355168