如何计算C＃窗体中datagridview列列中的特定值 [英] How to count specific values in a column of datagridview column in C# windows form

问题描述

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                [e-mail]           pending
2                    chisom            [e-mail]               approved
3                    Dami               [e-mail]         Denied
4                     Hausa            [e-mail]            Denied
5                    jones               [e-mail]          Denied
6                     Alfred            [e-mail]          Approved.
 
in the column LoanApproval i want to count how many   loans was approved,denied,pending 
i will like to put the information on a label like 
txtapproved.text........2
txtdenied.text........1
txtpending.text....1

我尝试过：

What I have tried:

var countdi = this.dtuserpro.Rows.Cast<DataGridViewRow>()
       .Count(row => row.Cells["LOANAPPROVAL"].Value == "Denied");
this.lbldenied.Text = countdi.ToString();

但它给我0而不是实数

but it is giving me 0 instead of the real number

推荐答案

你已经发布了这个问题来自 https：// www .codeproject.com / Questions / 5043556 /如何计算特定数据中的数据量[ ^ ]。请不要重新发布。

You already posted this question at https://www.codeproject.com/Questions/5043556/How-to-count-the-amount-of-data-in-a-specific-colo[^]. Please do not repost.

这篇关于如何计算C＃窗体中datagridview列列中的特定值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！