How to get sum on label from datagridview column

Question

0.00/5 (No votes)

See more:

i mean say is

i have

1) Datagridview
2) 4 columns in datagridview...ie id,name,subject,marks
3) label under datagridview
4) i want to get sum of selected row of marks column...ie if want to get sum of 2 rows then i have to get sum of 2 subjects only but not total marks column sum

i have tried but i am not getting for dragged row only

What I have tried:

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
int sum = 0;
int i = e.RowIndex;
DataGridViewRow selectedrow = dataGridView1.Rows[i];
sum += Convert.ToInt32(selectedrow.Cells[6].Value);
label1.Text = sum.ToString();
}

Also tried this

private void autosum()
{
int sum = 0;
for(int i = 0;i<dataGridView1.Rows.Count;++i)
{
sum += Convert.ToInt32(dataGridView1.Rows[i].Cells[6].Value);
}

label1.Text = "Total sum is :" + sum.ToString();
}

Posted 18-May-18 7:20am

Prateek gsharma

Updated 22-May-18 2:39am

Add a Solution

Comments

Richard MacCutchan 18-May-18 15:20pm

What is the problem?

Prateek gsharma 22-May-18 6:41am

ere i am getting total sum marks column using above code...but requirement is if i select 1 cell then it should display that value only...if i select 2 cells of marks column then it should be displayed sum of 2 cells only... & so on....

Prateek gsharma 19-May-18 1:52am

here i am getting total sum marks column using above code...but requirement is if i select 1 cell then it should display that value only...if i select 2 cells of marks column then it should be displayed sum of 2 cells only... & so on....

Prateek gsharma 21-May-18 10:00am

can any one help me?

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 · 2018-05-22T02:40:00

Solution 1

Quote:
i want to get sum of selected row of marks column

If i understand you correctly, you want to get collection of DataGridView.SelectedRows[^] then to display sum(marks) in label.
So, you should use DataGridView.SelectionChanged Event (System.Windows.Forms)[^] to be able to achieve that. Use below code inside that event (body of event):

C#

int sum = 0;
foreach(DataGridViewRow dgr in dataGridView1.SelectedRows)
{
    sum+= dgr[6].Value;
}
label1.Text = sum.ToString();

Another way is to use Linq[^]:

C#

label1.Text = dataGridView1.SelectedRows.Cast<DataGridViewRow>().Sum(dgr=>dgr.Cells[6].Value).ToString();

Posted 22-May-18 2:40am

Maciej Los

Updated 24-May-18 9:55am

v2

Comments

Prateek gsharma 24-May-18 13:44pm

i am getting error like "cannot apply indexing with[] to an expression of type "datagridview"....

can i provide you attachment to see my exact requirment?how attach word docs to this page?

Maciej Los 24-May-18 15:52pm

So, try to replace:

Sum(dgr=>dgr[6].Value)

with

Sum(dgr=>dgr.Cells[6].Value)

See: How to: Manipulate Rows in the Windows Forms DataGridView Control | Microsoft Docs[^]

Prateek gsharma 25-May-18 9:41am

Sum(dgr=>dgr.Cells[6].Value)

still not working

Prateek gsharma 25-May-18 9:43am

sum(dgr=>dgr.Cells[6].Value);

now i am getting "method name expected" error

Maciej Los 25-May-18 11:21am

Well, i was lazy to re-construct your issue. I'll promise to take a look closer and let you know about progress.

Prateek gsharma 30-May-18 2:12am

anyone plz reply me?

Maciej Los 30-May-18 6:31am

I checked out my solution and it works as expected:

label1.Text = dgv.Rows.Cast<DataGridViewRow>().Sum(x=>Convert.ToDouble(x.Cells[6].Value)).ToString();

For datagridview which is bind with data source, you have to use database methods!

Prateek gsharma 14-Jun-18 4:13am

My Question is "How to sum datagridview selected cell" on label?but still i didn't get solution?

Prateek gsharma 1-Jun-18 7:14am

wher should i replace this code sir?

Prateek gsharma 14-Jun-18 4:12am

My Question is "How to sum datagridview selected cell" on label?but still i didn't get solution?

Maciej Los 14-Jun-18 4:32am

I provided an answer here:

label1.Text = dgv.SelectedRows.Cast<DataGridViewRow>().Sum(x=>Convert.ToDouble(x.Cells[6].Value)).ToString();

It works as expected to me.
For further details, please see:
DataGridView.SelectedRows Property (System.Windows.Forms)[^]
How to: Get the Selected Cells, Rows, and Columns in the Windows Forms DataGridView Control | Microsoft Docs[^]

Prateek gsharma 21-Jun-18 13:57pm

where should i paste it?