private void frm_ClassManage_Load(object sender, EventArgs e)
{
dataGridView.AutoGenerateColumns = false;
cmb_gradeCdt.DataSource = BussinessFacade.Customers.cus.GetTable("Tbl_Department", null);
cmb_gradeCdt.DisplayMember = "Dpm_Name";
cmb_gradeCdt.ValueMember = "Dpm_ID"; } private void cmb_gradeCdt_SelectedValueChanged(object sender, EventArgs e)
{
string condition = " and Dpm_ID = " + cmb_gradeCdt.SelectedValue;
cmb_classCdt.DataSource = BussinessFacade.Customers.cus.GetTable("Tbl_Class", condition);
cmb_classCdt.DisplayMember = "Class_Name";
cmb_classCdt.ValueMember = "Class_ID"; } 如上代码cmb_gradeCdt和cmb_classCdt 分别是两个combobox
cmb_classCdt根据cmb_gradeCdt的值的改变而改变datasource
但在运行时抛出了“无法绑定由多个部分组成的标识符 "System.Data.DataRowView"。”异常 但是我把它们都放在LOAD事件里又能正常显示
private void frm_ClassManage_Load(object sender, EventArgs e)
{
dataGridView.AutoGenerateColumns = false;
cmb_gradeCdt.DataSource = BussinessFacade.Customers.cus.GetTable("Tbl_Department", null);
cmb_gradeCdt.DisplayMember = "Dpm_Name";
cmb_gradeCdt.ValueMember = "Dpm_ID"; string condition = " and Dpm_ID = " + cmb_gradeCdt.SelectedValue;
cmb_classCdt.DataSource = BussinessFacade.Customers.cus.GetTable("Tbl_Class", condition);
cmb_classCdt.DisplayMember = "Class_Name";
cmb_classCdt.ValueMember = "Class_ID";
} 我想应该不是SQL语句问题 , 是什么问题呢?
{
dataGridView.AutoGenerateColumns = false;
cmb_gradeCdt.DataSource = BussinessFacade.Customers.cus.GetTable("Tbl_Department", null);
cmb_gradeCdt.DisplayMember = "Dpm_Name";
cmb_gradeCdt.ValueMember = "Dpm_ID"; } private void cmb_gradeCdt_SelectedValueChanged(object sender, EventArgs e)
{
string condition = " and Dpm_ID = " + cmb_gradeCdt.SelectedValue;
cmb_classCdt.DataSource = BussinessFacade.Customers.cus.GetTable("Tbl_Class", condition);
cmb_classCdt.DisplayMember = "Class_Name";
cmb_classCdt.ValueMember = "Class_ID"; } 如上代码cmb_gradeCdt和cmb_classCdt 分别是两个combobox
cmb_classCdt根据cmb_gradeCdt的值的改变而改变datasource
但在运行时抛出了“无法绑定由多个部分组成的标识符 "System.Data.DataRowView"。”异常 但是我把它们都放在LOAD事件里又能正常显示
private void frm_ClassManage_Load(object sender, EventArgs e)
{
dataGridView.AutoGenerateColumns = false;
cmb_gradeCdt.DataSource = BussinessFacade.Customers.cus.GetTable("Tbl_Department", null);
cmb_gradeCdt.DisplayMember = "Dpm_Name";
cmb_gradeCdt.ValueMember = "Dpm_ID"; string condition = " and Dpm_ID = " + cmb_gradeCdt.SelectedValue;
cmb_classCdt.DataSource = BussinessFacade.Customers.cus.GetTable("Tbl_Class", condition);
cmb_classCdt.DisplayMember = "Class_Name";
cmb_classCdt.ValueMember = "Class_ID";
} 我想应该不是SQL语句问题 , 是什么问题呢?
this.comboBox1.DataSource = ds.Tables[0];
this.comboBox1.DisplayMember = "name";
this.comboBox1.ValueMember = "id";
检查BussinessFacade.Customers.cus.GetTable看看