SqlConnection conn = clsConn.CreateConnection();
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from 学生信息 where 所属班级=" + id, conn);
DataTable dt = new DataTable();
sda.Fill(dt);
this.cBox成员.DataSource = dt;
this.cBox成员.ValueMember = "编号";
this.cBox成员.DisplayMember = "姓名";
conn.Close();通过上面代码绑定数据到combobox里,如何依次读取列表的值?
this.cBox系部.Items[i].ToString()不可以。
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter("select * from 学生信息 where 所属班级=" + id, conn);
DataTable dt = new DataTable();
sda.Fill(dt);
this.cBox成员.DataSource = dt;
this.cBox成员.ValueMember = "编号";
this.cBox成员.DisplayMember = "姓名";
conn.Close();通过上面代码绑定数据到combobox里,如何依次读取列表的值?
this.cBox系部.Items[i].ToString()不可以。
...................................................
你要的东西在:
dt.Rows[i]["编号"].ToString();
foreach(System.Data.DataRowView dr in this.comboBox1.Items)
MessageBox.Show(dr["id"].ToString());
MessageBox.Show(dr[this.comboBox1.DisplayMember].ToString()+"="+dr[this.comboBox1.ValueMember].ToString());
MessageBox.Show( comboBox1.GetItemText( comboBox1.Items[i] ) );