菜鸟求教 :dataset的筛选问题

Question

请问dataset怎么进行筛选?
小弟试了方法,怎么不灵呢?
代码如下:        SqlDataAdapter1.Fill(DataSet41, "mattable")
        Dim dt As DataTable
        dt = DataSet41.Tables(0)        dt.DefaultView.RowFilter = "matid='01'"        Dim tr As DataRow
        Dim i As Int32
        i = 0
        DataGrid1.DataSource = dt.DefaultView
        DataGrid1.DataBind()

Answer 1

SqlDataAdapter1.Fill(DataSet41, "mattable")
Dim dt As DataTable
dt = DataSet41.Tables(0)Dim prodView as New DataView()
prodView= DataView(dt,"matid='" & "01" & "'","matid",DataViewRowState.CurrentRows)DataGrid1.DataSource = dt.DefaultView
DataGrid1.DataBind()

Answer 2

DataGrid1.DataSource = prodView 
DataGrid1.DataBind()

Answer 3

Dim dv As New DataView()
dv.Table = ds.Tables["mattable"]
dv.RowFilter = "matid='01'"
DataGrid1.DataSource = dv

Answer 4

SqlDataAdapter1.Fill(DataSet41, "mattable")
Dim dv As DataView
dv = new DataView(DataSet41.Tables("mattable"))
dv.RowFilter = "matid = '01'"DataGrid1.DataSource = dv
DataGrid1.DataBind()

Answer 5

SqlDataAdapter1.Fill(DataSet41, "mattable")
        Dim dt As new DataView
        dt = DataSet41.Tables(0).DefaultView        dt.RowFilter = "matid='01'"        Dim tr As DataRow
        Dim i As Int32
        i = 0
        DataGrid1.DataSource = dt.DefaultView
        DataGrid1.DataBind()