改变ComboBox选项时,通过SQL查询语句select * from study where type = '" + this.comboBox.SelectValue +"'",将这
个查询结果绑定到DataGrid。或者将数据全部数据查询到DataTable中,用DataView的筛选功能,select * from study;将结果绑定到一个DataTable中,DataView dv = DataTable1.DefaultView;在ComboBox改变时
dv.RowFilter = "type = '" + this.comboBox.SelectValue + "'";将DataView绑定到DataGrid
个查询结果绑定到DataGrid。或者将数据全部数据查询到DataTable中,用DataView的筛选功能,select * from study;将结果绑定到一个DataTable中,DataView dv = DataTable1.DefaultView;在ComboBox改变时
dv.RowFilter = "type = '" + this.comboBox.SelectValue + "'";将DataView绑定到DataGrid
没搞过WinForm,Good Luck!!!
应该是判断选的COMBOTEXT.TEXT然后生成或者显示不同的DATASET.TABLE而已.
选出所有的数据放在dataview里面,然后根据combobox,对dataview进行筛选,然后就更新dataGrid
dsDataSet.Tables["Table1"].DefaultView.RowFilter = "班级ID = " + ID.ToString();