'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]
Last Modified On:
No, open a new Support Case