Querying Datatable with where condition

Question

I have a datatable with two columns,

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

I want to query the datatable, against the column EmpID and Empname.

For example, I want to get the values where

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

@QQping, i couldnt do it. No idea. Just started to query in datatable — Anuya
– Anuya, Commented Mar 30, 2012 at 7:21

Community · Accepted Answer · 2017-05-23 12:34:44Z

43

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;

3 Comments

Anuya Over a year ago

missied out, how can i get the count of number of rows returned. Thanks

Anuya Over a year ago

sorry, i couldnt. I get this error when i convert res.count to Int...{"Specified cast is not valid."}{system.SystemException {System.InvalidCastException}

Brent Over a year ago

VB ex: Dim result = From row In myDataTable.AsEnumerable() Where row.Field(Of Integer)("myColumn1") > 0 And row.Field(Of Integer)("myColumn2") > 0 Select row

Michael Petrotta · Accepted Answer · 2013-04-14 19:49:58Z

22

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%'" );

edited Apr 14, 2013 at 19:49

Michael Petrotta

61.1k27 gold badges153 silver badges181 bronze badges

answered Mar 30, 2012 at 13:59

Gert Arnold

110k36 gold badges217 silver badges318 bronze badges

2 Comments

anar khalilov Over a year ago

Pardon my curiosity but what is 'EmpId > 2' for?

Gert Arnold Over a year ago

@AnarKhalilov It's just a few examples of the syntax. The 'like' wasn't asked for either.

Tigran · Accepted Answer · 2012-03-30 09:36:37Z

17

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?

edited Mar 30, 2012 at 9:36

answered Mar 30, 2012 at 7:21

Tigran

62.2k8 gold badges90 silver badges124 bronze badges

Collectives™ on Stack Overflow

Querying Datatable with where condition

3 Answers 3

3 Comments

2 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

Comments

Linked

Related