苦恼啊dataview竟然无法过滤数据!解决办法

苦恼啊!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