How to Query A DataGridView Using Linq

Question

I have a DataGridView that I want to query using Linq (C# WinForm). I want to "count" rows where a certain criteria is met. For example,

variable1 = "count rows where ColumnBoxAge > 3 || < 5"

label1.Text = variable1

How to do this in C# WinForm using Linq?

Ali Ersöz · Accepted Answer · 2008-11-21 08:23:31Z

2

I don't know if it could work but you can try this;

dataSet.Tables[0].AsEnumerable().Where(c => c.Field<int>("ageColumn") > 3 ||
     c.Field<int>("ageColumn") < 5).Count();

Edit : Where instead of Select.

answered Nov 21, 2008 at 7:49

Ali Ersöz

16.1k12 gold badges52 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

it's counting all rows in the dgv...not what I want. Shld be "count rows where BoxAge is between 3 and 5"...

MarlonRibunal · Accepted Answer · 2008-11-21 08:21:57Z

0

@yapiskan

dataSet.Tables[0].AsEnumerable().Where(c => c.Field<int>("ageColumn") > 3 &&
     c.Field<int>("ageColumn") < 5).Count();

.Where instead of .Select

Thank you very much! I appreciate your help.

answered Nov 21, 2008 at 8:21

MarlonRibunal

4,1363 gold badges34 silver badges38 bronze badges

Ali Ersöz · Accepted Answer · 2008-11-21 08:23:59Z

0

So your query is wrong! Try to put '&&' instead of '||';

dataSet.Tables[0].AsEnumerable().Where(c => c.Field<int>("ageColumn") > 3 &&
     c.Field<int>("ageColumn") < 5).Count();

Edit : Where instead of Select.

answered Nov 21, 2008 at 8:13

Ali Ersöz

16.1k12 gold badges52 silver badges64 bronze badges