实现方法:
1、生成datatable,并为combox绑定数据源:
comboBox1.DataSource = dt1;
comboBox1.DisplayMember = "用户编码";
comboBox1.ValueMember = "ID";
this.comboBox1.SelectedIndex = -1;
2、在combox的SelectedIndexChanged事件中添加如下方法:
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
int iCurrentIndex = this.comboBox1.SelectedIndex;
if (iCurrentIndex < 0) return;
DataRow dr = dt1.Rows[iCurrentIndex];
iID = Int32.Parse(dr["ID"].ToString());
}
SqlDataAdapter da = new SqlDataAdapter("select * from Customers", "Data Source=.;Initial Catalog=Northwind;Integrated Security=True");
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = ds.Tables[0];
comboBox1.DataSource = dt;
comboBox1.DisplayMember = "city"; //要显示的字段名
//如果是Web程序的话,加上comboBox1.DataBind();