How to count specific values in a column of datagridview column

Question

In a DataGridView I need to count how many duplicate values a column has.

This is my Datagridview:

For example, I'd like to count how many "X" I have in my "RisFin" column, and put the result in a textbox.

Using linq queries you can simply do many things with your grid. and the key point is casting the Rows collection to an IEnumerable<DataGridViewRow> using Cast<DataGridViewRow>(), then you can perform any query in it, using linq. — Reza Aghaei
– Reza Aghaei, Commented Oct 13, 2015 at 22:54
@Marci Let me know if you have any question about the answer or if you find it helpful, you can kindly click the check mark near the answer to make it accepted. This way it will be more useful for other users too. — Reza Aghaei
– Reza Aghaei, Commented Oct 14, 2015 at 18:59

Reza Aghaei · Accepted Answer · 2019-02-06 15:24:12Z

4

You can count what you need this way:

var count= this.dataGridView1.Rows.Cast<DataGridViewRow>()
               .Count(row => row.Cells["RisFin"].Value == "X");

this.textBox1.Text = count.ToString();

Using linq queries you can simply do many things with your grid. and the key point is casting the Rows collection to an IEnumerable<DataGridViewRow> using Cast<DataGridViewRow>(), then you can perform any query on it, using linq.

edited Feb 6, 2019 at 15:24

answered Oct 13, 2015 at 22:44

Reza Aghaei

126k18 gold badges241 silver badges448 bronze badges

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

1 Comment

Reza Aghaei Over a year ago

Don't forget to add using System.Linq;

wingerse · Accepted Answer · 2015-10-13 22:45:11Z

0

Well, you could just iterate through the rows and increment your counting variable if row.Cells[0] is "X". Here's a LINQ solution.

int xCount = dataGridView.Rows
                .Cast<DataGridViewRow>()
                .Select(row => row.Cells["RisFin"].Value.ToString())
                .Count(s => s == "X");

answered Oct 13, 2015 at 22:45

wingerse

3,8371 gold badge33 silver badges67 bronze badges

Collectives™ on Stack Overflow

How to count specific values in a column of datagridview column

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related