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 kun@gmail.com pending 2 chisom chi@msn.com approved 3 Dami dams@gmail.com Denied 4 Hausa sasd@gmail.com Denied 5 jones jasss@yahoo.com Denied 6 Alfred alsada@yahoo.com Approved. in the column LoanApproval i want to count how many loans was approved,denied,pending

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 kun@gmail.com Approved 2 kun@gmail.com Pending 1 kun@gmail.com Declined 1 You can add Where condition in above query to get customer specific output.

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

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

Select Count(LoanApproval), Email from tablename group by LoanApproval

Answers

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

Oladotun Obileye

669

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