[RESOLVED] access a DataTable which created at runtime

[iRoN_RoCK]

Hello guys,
I created a Datatable at runtime, added data to it succesfully but now i cant access it. For example, I can't filter by nationality

Public DtPlayers As New DataTable("PlayerNames")

Private Sub frmMain_Load(...)
 Do Until cnt=playerCount
   ...
   DtPlayers.Rows.Add(New Object() {cnt, PlID, PlName, vbNullString, _
   PlAge, PlNationality,  PlHeight, PlWeight, PlPosition})
   cnt=cnt+1
 Loop
end sub   

Private Sub TestGrid_ColumnHeaderMouseClick(...)
        Dim myQuery = From Player In DtPlayers _
                    Where _(what should i add here?)_ = "Turkey" _
                    Select Player
    End Sub

Thanks in advance,
iRoN_RoCK

[techgnome]

That's because it's not a typed datatable.... so LINQ has no way of knowing what fields are in the datatable. But... that just means you don't get the nicety of intellisense... It's still possible to extract field values....

I think this is what you are looking for:

 Where DtPlayers.Item("stuff your nationality field name here").ToString = "Turkey" _

-tg

[iRoN_RoCK]

That's because it's not a typed datatable.... so LINQ has no way of knowing what fields are in the datatable. But... that just means you don't get the nicety of intellisense... It's still possible to extract field values....

I think this is what you are looking for:

 Where DtPlayers.Item("Nationality").ToString = "Turkey" _

-tg

'Item' is not a member of 'System.Data.DataTable' it said

[techgnome]

Try Player instead of DtPlayers .... sorry... I'm used to typed Datatables, so I'm not used to this.... if that still doesn't work... try this:

Where (function(s) s.Item("stuff your nationality field name here").ToString = "Turkey") _

-tg

[iRoN_RoCK]

Try Player instead of DtPlayers .... sorry... I'm used to typed Datatables, so I'm not used to this.... if that still doesn't work... try this:

Where (function(s) s.Item("stuff your nationality field name here").ToString = "Turkey") _

-tg

this one was ok but it just cleared all rows from datagridview. what did i do wrong?

        Dim myQuery = From Player In DtPlayers _
                    Where Player.Item("Nationality").ToString = "Turkey" _
                    Select Player
        TestGridView.DataSource = myQuery

[iRoN_RoCK]

This one works. Thanks for your posts anyway

        Dim dv = New DataView(DbPlayers)
        dv.RowFilter = "Nationality = 'Turkey'"
        TestGridView.DataSource = dv