How to count times a data exist in a column in c#

Oladotun Obileye

Good day everyone please I am working on a windows form loan application i have 6records. I have a column that is for loan approval i.e it has three different values(approved,denied,pending)

ID NAME EMAIL LOANAPPROVAL

1 kunle [email protected] pending

2 chisom [email protected] approved

3 Dami [email protected] Denied

4 Hausa [email protected] Denied

5 jones [email protected] Denied

6 Alfred [email protected] Approved.

in the column LoanApproval i want to count how many loans was approved,denied,pending

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Oladotun Obileye7y ago
thanks for your concern. please i will like to put the information on a textbox like
txtapproved.text........2
txtdenied.text........1
txtpending.text....1
0
Manoj Bhoir7y ago
Hi,

You can try this query.
SELECT LOANAPPROVAL, COUNT(*) FROM YourTableName GROUP BY LOANAPPROVAL;
This will gives you output like
Approved 2
Pending 1
Declined 1

If you want details based on the customer then you can use below query.
SELECT EMAIL, LOANAPPROVAL, COUNT(*) FROM YourTableName GROUP BY EMAIL, LOANAPPROVAL
This will give you output like
[email protected] Approved 2
[email protected] Pending 1
[email protected] Declined 1

You can add Where condition in above query to get customer specific output.
0
Oladotun Obileye7y ago
but please i want to be able to count for example some customer were denied 3 threes,approved two times and one pending and send the value to a label form a datagridview
0
Amit Gupta7y ago
Select Count(LoanApproval), Email from tablename group by LoanApproval
0

[email protected]	Approved	2
[email protected]	Pending	1
[email protected]	Declined	1