DataTable - Filtering

Question

Hi

Im having a small issue with filtering a DataTable. I have tried various options, all not quite returning the result needed. I need to return a filtered list as a DataSource to a DataGrid based on a Column(Group) value(SIZE)

I did this
_PT 'This is the datatable

Dim DR as DataRow() = _PT.Select("Group = 'SIZE'")

MyGrid.DataSource = DR

When i do this, i get the correct amount of rows but no data.

If i add the table as the DataSource

MyGrid.DataSource = _PT

i get all of the results and i can see the data.

What am i doing wrong? How am i able to filter the table itself without a DataRow() to see the filtered results in the Grid?

Thanks

Answer 1

straight after the post i managed to figure it out....

 Dim DV As New DataView(_PT) With {.RowFilter = "Group = '" & _Filter & "'"}

Thanks