C# 使用 where 条件查询数据表

Querying Datatable with where condition

提问by Anuya

I have a datatable with two columns,

我有一个包含两列的数据表，

Column 1 = "EmpID"
Column 2 = "EmpName"

I want to query the datatable, against the column EmpIDand Empname.

我想针对列EmpID和 Empname.

For example, I want to get the values where

例如，我想获取其中的值

(EmpName != 'abc' or EmpName != 'xyz') and (EmpID = 5)

采纳答案by mamoo

Something like this...

像这样的东西...

var res = from row in myDTable.AsEnumerable()
where row.Field<int>("EmpID") == 5 &&
(row.Field<string>("EmpName") != "abc" ||
row.Field<string>("EmpName") != "xyz")
select row;

See also LINQ query on a DataTable

另请参阅 DataTable 上的 LINQ 查询

回答by Tigran

something like this ? :

像这样的东西？：

DataTable dt = ...
DataView dv = new DataView(dt);
dv.RowFilter = "(EmpName != 'abc' or EmpName != 'xyz') and (EmpID = 5)"

Is it what you are searching for?

这是您要寻找的吗？

回答by Gert Arnold

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

你可以用 Linq 来做，就像 mamoo 展示的那样，但老歌也很好：

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