SyntaxFix

[c#] Querying Datatable with where condition

You can do it with Linq, as mamoo showed, but the oldies are good too:

var filteredDataTable = dt.Select(@"EmpId > 2
    AND (EmpName <> 'abc' OR EmpName <> 'xyz')
    AND EmpName like '%il%'" );

Examples related to c#

• How can I convert this one line of ActionScript to C#? • Microsoft Advertising SDK doesn't deliverer ads • How to use a global array in C#? • How to correctly write async method? • C# - insert values from file into two arrays • Uploading into folder in FTP? • Are these methods thread safe? • dotnet ef not found in .NET Core 3 • HTTP Error 500.30 - ANCM In-Process Start Failure • Best way to "push" into C# array

Examples related to linq

• Async await in linq select • How to resolve Value cannot be null. Parameter name: source in linq? • What does Include() do in LINQ? • Selecting multiple columns with linq query and lambda expression • System.Collections.Generic.List does not contain a definition for 'Select' • lambda expression join multiple tables with select and where clause • LINQ select one field from list of DTO objects to array • The model backing the 'ApplicationDbContext' context has changed since the database was created • Check if two lists are equal • Why is this error, 'Sequence contains no elements', happening?

Examples related to datatable

• Can't bind to 'dataSource' since it isn't a known property of 'table' • How to get a specific column value from a DataTable in c# • Change Row background color based on cell value DataTable • How to bind DataTable to Datagrid • Find row in datatable with specific id • Datatable to html Table • How to Edit a row in the datatable • How do I use SELECT GROUP BY in DataTable.Select(Expression)? • How to fill a datatable with List<T> • SqlBulkCopy - The given value of type String from the data source cannot be converted to type money of the specified target column