如何正确过滤数据表（datatable.select）

Dim dt As New DataTable
Dim da As New SqlDataAdapter(s, c)

        c.Open()
        If Not IsNothing(da) Then
            da.Fill(dt)
            dt.Select("GroupingID = 0")
        End If

        GridView1.DataSource = dt
        GridView1.DataBind()
        c.Close()

When I call da.fill I am inserting all records from my query. I was then hoping to filter them to display only those where the GroupingID is equal to 0. When I run the above code. I am presented with all the data, the filter did not work. Please can you tell me how to get this working correctly. Thanks.

当我调用da.fill时,我将从查询中插入所有记录。我当时希望过滤它们只显示GroupingID等于0的那些。当我运行上面的代码时。我收到了所有数据,过滤器没有用。请问您能告诉我如何使其正常工作。谢谢。

1 个解决方案

#1

dt.Select() returns an array of DataRows.

dt.Select()返回一个DataRows数组。

Why don't you use a DataView?

你为什么不使用DataView?

 DataView dv = new DataView(dt);
 dv.RowFilter = "GroupingID = 0";
 GridView1.DataSource = dv;

#1