how to multiply the value of column in DataGridView and show it another column

Question

0.00/5 (No votes)

See more:

I am new in CSharp....

I want to multiply the value of two column and display it another column.
I have written the code as..

C#

int s = Convert.ToInt32(dataGridView1.Rows[0].Cells[0].Value);
            int s1 = Convert.ToInt32(dataGridView1.Rows[0].Cells[1].Value);
            int s13 = s1 * s;
dataGridView1.Rows[0].Cells[2].Value = s13;

bt this code work in one row. I want to do more than one row may be 5/6.

And after that I want to save the value of datagridView in a table.

Plz help me..

Thanks in advans

Posted 29-Feb-12 17:06pm

Mithlesh Shaw

Updated 21-Feb-17 19:23pm

Add a Solution

Comments

Ankit Kumar Gupta 29-Feb-12 23:19pm

What you are binding with the grid?
dataset, or
sqlDataSource etc.

6 solutions

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)

Ganesan Senthilvel · Answer 1 · 2012-02-29T17:08:00

Solution 1

Got it. Instead of Rows[0] attribute, you should use CurrentRow. It should be fine.

C#

int s = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
            int s1 = Convert.ToInt32(dataGridView1.CurrentRow.Cells[1].Value);
            int s13 = s1 * s;
dataGridView1.CurrentRow.Cells[2].Value = s13;

Posted 29-Feb-12 17:08pm

Ganesan Senthilvel

Comments

Mithlesh Shaw 29-Feb-12 23:30pm

I think y have not understand my problm.
This code works bt it does not giv me appropiat answer.
I have enterd three row bt the multipication shows of 3rd row.
I want to display the multipication of all three row in diffrent column.
Like this...
5 5 25
6 6 36
7 7 49

**AmitGajjar** · Answer 2 · 2012-02-29T17:37:00

Solution 2

Hi,

Why you are doing this code from codebehind, instead you can use your SQL query to multiply value and display it in your third column.

like

SQL

select productID,productPrize,productSellCount, productPrize*productSellCount from products;

hope this will solve your problem.

Thanks
-Amit.

Posted 29-Feb-12 17:37pm

AmitGajjar

Comments

Mithlesh Shaw 1-Mar-12 0:09am

I dont want to do like this. If i do like I will face problem. Plz help me.....Plz

AmitGajjar 1-Mar-12 0:12am

what kind of problem you have. As computation in database level will be the best option. and don't say please, i will try my best to solve your problem.

Mithlesh Shaw 1-Mar-12 0:42am

Provide me the code because I am new in programing. You have just provide me the Quary.

AmitGajjar 1-Mar-12 0:44am

you must have SQL query or Storedprocedure to fetch your code. right ? post your SQL code so that i can modify it and postback.

Mithlesh Shaw 1-Mar-12 0:59am

I dont have any SQLQuary. Actually a dataGridView control in my form and user will put the value in runtime after that a button is there. Then the user click the button and the Multipication of given number will show. Just like that...
5 5 25
6 6 36
7 7 49
User will provide 5& 5, 6&6, 7&7.
The multipication will generate after the click event of the button.

AmitGajjar 1-Mar-12 1:07am

please check this link

rajrprk · Answer 3 · 2012-03-01T00:48:00

Solution 3

int A = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
int B = Convert.ToInt32(dataGridView1.CurrentRow.Cells[1].Value);
int C = A * B;
dataGridView1.CurrentRow.Cells[2].Value = C;

Posted 1-Mar-12 0:48am

rajrprk

Comments

sagar Lalage 20-Jun-12 9:19am

please give same solution for grid view

Member 10285877 · Answer 4 · 2014-04-08T02:02:00

Solution 4

Modify Your cOde like this

for (int n = 0; n < (dataGridView1.Rows.Count - 1); n++)
{

int s = Convert.ToInt32(dataGridView1.Rows[n].Cells[0].Value);
int s1 = Convert.ToInt32(dataGridView1.Rows[n].Cells[1].Value);
int s13 = s1 + s;
dataGridView1.Rows[n].Cells[2].Value = s13;

}

Posted 8-Apr-14 2:02am

Member 10285877

Member 12988384 · Answer 5 · 2017-02-07T18:48:00

Solution 6

for (int n = 0; n < (dataGridView1.Rows.Count); n++)
            {
                int s = Convert.ToInt32(dataGridView1.Rows[n].Cells[0].Value);
                int s1 = Convert.ToInt32(dataGridView1.Rows[n].Cells[1].Value);
                int s13 = s1 * s;
                dataGridView1.Rows[n].Cells[2].Value = s13;
            }

Posted 7-Feb-17 18:48pm

Member 12988384

Updated 7-Feb-17 18:49pm

v2

Comments

CHill60 8-Feb-17 12:39pm

Apart from the fact this question was answered 5 years ago, this solution you have posted is identical to Solution 4. Claiming someone else's work as your own is not tolerated on this site. It's bad code anyway as it could cause exceptions

Member 13016086 · Answer 6 · 2017-02-21T19:23:00

Solution 7

select productID,productPrize,productSellCount, productPrize*productSellCount from products;

how to display productPrize*productSellCount into data gridview in winforms can anybody explain that