How to count the amount of data in a specific coloumn using from a combo box in C# windows form

Question

1.00/5 (1 vote)

See more:

Good day everyone. I am working on a windows form loan application, I have a column which consist of a combobox, and the combobox has three items or value(Approved,denied,pending). i want to be able to count the amount of each of the items. for example i have 10 records(customers) and three of the customers has been approved,3 denied and 4 pending using the combobox please how can i count how many customers are pending,denied,approved in the datagridview.

What I have tried:

Good day everyone. I am working on a windows form loan application, I have a column which consist of a combobox, and the combobox has three items or value(Approved,denied,pending). i want to be able to count the amount of each of the items. for example i have 10 records(customers) and three of the customers has been approved,3 denied and 4 pending using the combobox please how can i count how many customers are pending,denied,approved in the datagridview.

Posted 24-May-19 15:53pm

akinwunmi

Updated 24-May-19 22:27pm

Add a Solution

Comments

Richard MacCutchan 25-May-19 4:23am

Examine each row and test what status the combobox contains. Count the items from that information.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2019-05-24T22:27:00

Firstly, you probably shouldn't use the DGV content directly - you would normally have the DGV DataSource set to a collection or table of data which it display, and you would work from that instead of the DGV.

But either way, you need to pass through the rows, counting which rows contain matching elements, either with an explicit loop (for or foreach probably) or with an implicit loop using Linq (or Linq methods).

We can't be explicit here: we can't tell you "do this and it'll work" - there are just too many different ways all this could be organised and we have no access to your code or data to find out. Heck, we don't even know what exactly you are storing in your ComboBox, and I can think of maybe half a dozen different ways to do that alone!

So start by looking at your data sources, and how they are organised for display - then work from there.