Querying In Memory DataTable in VB.Net

 

'Data Table
  Dim dt As New DataTable
  'Data row array
  Dim rows() As System.Data.DataRow
  Dim row As DataRow

  'Build Data Table in Memory
  dt.Columns.Add("Employee_ID", GetType(System.Int32))
  dt.Columns.Add("Employee_Name", GetType(System.String))

  'Add Rows
  dt.Rows.Add(New Object() {100, "ABCDE"})
  dt.Rows.Add(New Object() {101, "ABCDF"})
  dt.Rows.Add(New Object() {102, "ABCDD"})

  'Filter Expression
  rows = dt.Select("[Employee_ID] = 100")

  'Display Filtered Rows
  For Each row In rows
      MsgBox(row("Employee_Name"))
  Next

  'Filter Expression 2
  rows = dt.Select("[Employee_ID] >= 100 and [Employee_ID]