无法绑定由多个部分组成的标识符 "System.Data.DataRowView"。
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语句问题 , 是什么问题呢?