苦恼啊!dataview竟然无法过滤数据!
在途中 2007-01-16 11:51:28 我想过滤出"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