datagridview 中combobox 的displaymember和 valuemember 不一致就报错
黄开泰 2021-02-18 10:55:15 小弟刚开始学习C# winforms ,跟着培训老师视频做winform的练习出现了一个问题,
一旦datagridview 中combobox 的displaymember和 value member没有一致,就报错
这是出现问题的 语句
string majorSql = " select distinct tblmajor.majorname,tblmajor.majorID from TestClass" +
" left join tblmajor on TestClass.majorid = tblmajor.majorid";
DataTable majorDt = Sqlhelper.Sqlhelper.ExecuteDataTable(majorSql);
DataGridViewComboBoxColumn cbomajorname = DGVStu.Columns["majorname"] as DataGridViewComboBoxColumn;
cbomajorname.DisplayMember = "majorname";
cbomajorname.ValueMember = "majorid";
cbomajorname.DataSource = majorDt;
这是没出现问题的语句
string majorSql = " select distinct tblmajor.majorname,tblmajor.majorID from TestClass" +
" left join tblmajor on TestClass.majorid = tblmajor.majorid";
DataTable majorDt = Sqlhelper.Sqlhelper.ExecuteDataTable(majorSql);
DataGridViewComboBoxColumn cbomajorname = DGVStu.Columns["majorname"] as DataGridViewComboBoxColumn;
cbomajorname.DisplayMember = "majorname";
cbomajorname.ValueMember = "majorname";
cbomajorname.DataSource = majorDt;