using (SqlConnection sqlconn = new SqlConnection(StrConn))
{
sqlconn.Open();
string Sql = "select ID,Name from Department";
SqlCommand Sqlcmd = new SqlCommand(Sql, sqlconn);
SqlDataAdapter Sda = new SqlDataAdapter(Sqlcmd);
DataSet Ds = new DataSet();
Sda.Fill(Ds, "Course");
this.comboBox1.DisplayMember = "Name";
this.comboBox1.ValueMember = "ID";
this.comboBox1.DataSource = Ds.Tables[0].DefaultView;
}
上面的表名写错了Sda.Fill(Ds, "Department");
SqlDataAdapter da = new SqlDataAdapter("select group_id, group_name from mygroup", con);
DataSet ds = new DataSet();
da.Fill(ds, "group");
DataTable dtGroup = ds.Tables["group"];comboBox1.DataSource = dtGroup;
comboBox1.DisplayMember = "group_name";//显示出来的名字
comboBox1.ValueMember = "group_id";//选中的id取值的时候用下面的
private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedValue != null)
this.textBoxMain.Text = comboBox1.SelectedValue.ToString();
}
或者 comboBox1.SelectedItem.ToString();
comboBox1.ValueMember = "group_id";
==>
或者
comboBox1.DisplayMember = "group_name";//显示出来的名字
comboBox1.ValueMember = "group_name";都一样的
上面的表名写错了Sda.Fill(Ds, "Department");
额,,其实我就是想问selectedValue,,,可能是我没说清楚吧,,不过还是谢谢你