c＃中的组合框问题 [英] comboboxproblem in c#

问题描述

使用数据表绑定组合框，现在我想在组合框中插入select

这里是我的代码：选择即将到来，该怎么办...

Hi,

am binding combobox with datatable , and now i want to insert "select " in starting in combobox
here is my code: select is coming at last ,how to do ...

<pre lang="c#">String query = "select machine_id from device";
                MySqlCommand command = new MySqlCommand(query,con);
                con.Open();
                MySqlDataAdapter da = new MySqlDataAdapter(query, con);
                DataTable dt = new DataTable();
                 da.Fill(dt);
                comboBox1.DataSource =dt;
                //comboBox1.Text = "select";
                comboBox1.DisplayMember = "machine_id";
                comboBox1.ValueMember = "machine_id";

                DataRow dr = dt.NewRow();
                dr["machine_id"] = -1;// Some ID
                dr["machine_id"] = "Select";
                dt.Rows.Add(dr);
                comboBox1.SelectedIndex = -1;

推荐答案

你好，

尝试这个



---查询获取数据并加载DataTable

----

Hello ,
try this one

---query to fetch data and load in DataTable
----

<br />
   da.Fill(dt);<br />
   DataRow dr=dt.NewRow();<br />
   dr["machine_id"]="Select";<br />
   dt.Rows.Insert(dr,0);<br />
<br />
   comboBox1.DataSource =dt;<br />
   comboBox1.DisplayMember = "machine_id";<br />
   comboBox1.ValueMember ="machine_id";<br />
   combobox1.SelectedIndex=0;<br />
<br />

谢谢

thanks

这篇关于c＃中的组合框问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！