苦恼啊!dataview竟然无法过滤数据!
我想过滤出 "ID= '1 ' "的数据并显示在datagridview中(版本VS2005),竟然把我所有的数据都显示出来!真是苦恼,大家帮帮忙吧!代码如下:
过程一
'生成数据
mSQL = "SELECT * FROM T_Goods " ' ORDER BY ID "
mCmd = New OleDbDataAdapter(mSQL, DataPath)
'填充数据集
mCmd.Fill(GoodsSet, "Goods ")
过程二
Dim dv As DataView = New DataView
dv.Table = GoodsSet.Tables( "Goods ")
dv.AllowDelete = True
dv.AllowEdit = True
dv.AllowNew = True
dv.Sort = "ID "
dv.RowFilter = "ID = '1 ' "
dv.RowStateFilter = DataViewRowState.ModifiedCurrent
DataGridView1.DataSource = dv.Table
[解决办法]
DataGridView1.DataSource = dv.Table
改为
DataGridView1.DataSource = dv
[解决办法]
DataGridView1.DataSource = dv.Table
改为
DataGridView1.DataSource = dv
