Filtering data from a DataTable using LINQ is a powerful way to extract rows based on complex conditions.
Here’s a quick guide with syntax and examples:
(From row In yourDataTable.AsEnumerable()
Where row(“ColumnName”).ToString = “YourValue”
Select row).CopyToDataTable()
Examples
1.Filter rows where Status = “Approved”
(From row In dtInput.AsEnumerable()
Where row(“Status”).ToString = “Approved”
Select row).CopyToDataTable()
2.Filter by multiple conditions
(From row In dtInput.AsEnumerable()
Where row(“Status”).ToString = “Approved” AndAlso
CInt(row(“Amount”)) > 1000
Select row).CopyToDataTable()
3.Case-insensitive match
(From row In dtInput.AsEnumerable()
Where row(“Name”).ToString.ToLower = “john”
Select row).CopyToDataTable()
4.Contains (partial match)
(From row In dtInput.AsEnumerable()
Where row(“Email”).ToString.Contains(“@gmail.com”)
Select row).CopyToDataTable()