How to calculate sum of column in data grid view empty cells.

Question

1.00/5 (1 vote)

See more:

How to get data grid view sum values for label in c# win forms 2010, but my data grid view some cells are empty.

What I have tried:

How to calculate sum of column in data grid view empty cells.

Posted 17-Jul-16 23:25pm

Boopalslm

Updated 22-Feb-20 18:24pm

Add a Solution

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)

Mithlesh Shaw · Answer 1 · 2016-07-17T23:54:00

Solution 1

Try below code:

C#

decimal val=0;
foreach (DataGridViewRow item in dataGridView1.Rows)
{
   if (item.Cells[1] != null && item.Cells[1].Value != null)
        val += Convert.ToDecimal(item.Cells[1].Value);
}
MessageBox.Show(val.ToString());

Posted 17-Jul-16 23:54pm

Mithlesh Shaw

Comments

Boopalslm 18-Jul-16 6:13am

Error is came for below line

val += Convert.ToDecimal(item.Cells[1].Value);

Input string was not in a correct format.

Mithlesh Shaw 18-Jul-16 6:16am

Here 1 is the cell index. In your program you put your cell index. Cell index starts with 0.

Boopalslm 18-Jul-16 6:19am

i know, but my cell index is 9, i am set 9 for cell index, in 9th cell some empty cell are available so below error is came.

Object cannot be cast from DBNull to other types.

Mithlesh Shaw 18-Jul-16 6:18am

decimal val=0;
const int CELL_INDEX = 1;//Your column index
foreach (DataGridViewRow item in dataGridView1.Rows)
{
if (item.Cells[CELL_INDEX] != null && item.Cells[CELL_INDEX].Value != null)
val += Convert.ToDecimal(item.Cells[CELL_INDEX].Value);
}
MessageBox.Show(val.ToString());

Boopalslm 18-Jul-16 6:21am

Same error is came.

val += Convert.ToDecimal(item.Cells[9].Value);

Object cannot be cast from DBNull to other types.

Mithlesh Shaw 18-Jul-16 6:24am

replace if statement with this one and check
if (item.Cells[CELL_INDEX] != null
&& item.Cells[CELL_INDEX].Value != null && item.Cells[CELL_INDEX].Value != System.DBNull.Value)

Boopalslm 18-Jul-16 6:28am

i am change your if statement line but
before run error is came

invalid expression term '}'

Boopalslm 18-Jul-16 6:30am

k its working fine , but shown value zero(0), but my grid view cells having some values.

Mithlesh Shaw 18-Jul-16 6:31am

you have missed the '}'
here is the full code

decimal val=0;
const int CELL_INDEX = 1;//Your column index
foreach (DataGridViewRow item in dataGridView1.Rows)
{
if (item.Cells[CELL_INDEX] != null
&& item.Cells[CELL_INDEX].Value != null && item.Cells[CELL_INDEX].Value != System.DBNull.Value)
val += Convert.ToDecimal(item.Cells[CELL_INDEX].Value);
}
MessageBox.Show(val.ToString());

Boopalslm 18-Jul-16 6:33am

Sir thanks a lot working super and again thanks.