SUM Filtered DGV Column

Question

0.00/5 (No votes)

See more:

Hi Guys

I have an unbound DGV and i can filter it by hiding rows according to value.

I use the following code to get the SUM of column and it works 100%

VB

Dim total = (From row In Me.DataGridView2.Rows _
     Let r = DirectCast(row, DataGridViewRow) _
     Where r.Cells("ExclTot").Value IsNot Nothing _
     Select CDec(r.Cells("ExclTot").Value)).Sum

       Me.Baskettot.Text = FormatCurrency(total)

Only problem is that it also calculates the hidden CELLS

Is there a way of getting the SUM only on visible values?
I have found solutions for BOUND DGV but take in mind my DGV is UNBOUND.

:(

Posted 13-Jun-15 21:45pm

Mario Van Deventer

Add a Solution

Comments

Tomas Takac 15-Jun-15 4:18am

I guess there is a Visiblity or IsVisible property on the data row, did you try to use that?

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)

Maciej Los · Answer 1 · 2015-06-16T10:41:00

Use DataGridViewRow.Visible[^] property.

VB

Dim total = (From row As DataGridViewRow In Me.DataGridView2.Rows _
     Where r.Visible And r.Cells("ExclTot").Value IsNot Nothing _
     Select CDec(r.Cells("ExclTot").Value)).Sum

or:

SQL

Dim visibleRowsSum  = DataGridView2.Rows.OfType(Of DataGridViewRow)().Where(Function(row) row.Visible And row.Cells("ExclTot") IsNot Nothing).Select(Function(row) CDec(row.Cells("ExclTot").Value)).Sum()