How to perform multiplication on two column for datagrid view and assigning it in third column?

Question

0.00/5 (No votes)

See more:

Here is my code, I am trying to display multiplication of Rate * Supply column values and assigning it to the Amount column in data grid view :

C#

try
{
    Query = "Select  id,Code,Description,Rate,Cust_Id,Supply,Empty,Amount,Received from Items ";
    adap = new SQLiteDataAdapter(Query, GlobalVars.conn);
    ds = new DataSet();
    adap.Fill(ds, "Items");
    dtgVOuchers.DataSource = ds.Tables[0];

    ds.Tables[0].Columns["Amount"].DefaultValue = (ds.Tables[0].Columns["Rate"].DefaultValue) * (ds.Tables[0].Columns["Supply"].DefaultValue); //error

    //dtgVOuchers.Rows.Clear();
    ds.Tables[0].Clear();
    dtgVOuchers.Refresh();
}

Does anyone know how I can accomplish this functionality in data grid view ? . .Please help me to correct this code. Thanks

Note : i want to multiply in code not in query

Posted 27-Nov-13 23:13pm

Member 8840306

Add a Solution

2 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)

AnthonyMG · Answer 1 · 2013-11-27T23:46:00

Solution 1

Try this in your Code.

C#

private void MultiplyMethod(int Rate , int Supply, int Amount )
 {
        double outVal = 0;
        foreach (DataGridViewRow row in dataGridView1.Rows)
        {
            double localSum = (Convert.ToDouble(row.Cells[Rate].Value) *                 Convert.ToDouble(row.Cells[Supply].Value);
            outVal = outVal + localSum;
            row.Cells[Amount].Value = localSum;
        }        
    }
}

Posted 27-Nov-13 23:46pm

AnthonyMG

Comments

Member 8840306 28-Nov-13 6:20am

private void MultiplyMethod(int Rate , int Supply, int Amount ) How to get the value of these arguments in function?

Karthik_Mahalingam 28-Nov-13 6:38am

he is mentioning the column index of the gridview...

AnthonyMG 28-Nov-13 6:26am

See these are all not values, these are your dataGridColumn's, which you use in your dataGrid
Rate - 1st column in dataGrid
Supply - 2nd Column
Amount - 3rd Column

you can Pass corresponding Column's index to this method as per your logic

C@dER@j · Answer 2 · 2013-11-29T01:16:00

C#

DataTable table1 = new DataTable("Registration");
       table1.Columns.Add("L1");
       table1.Columns.Add("L2");
       table1.Columns.Add("L3");
       table1.Rows.Add("1",5);
       table1.Rows.Add("3", 5);
       table1.Rows.Add("4", 9);
       table1.Rows.Add("7", 3);
       table1.Rows.Add("6", 6);

       DataSet Dset = new DataSet("DSET1");
       Dset.Tables.Add(table1);

       if (Dset.Tables[0].Rows.Count > 0)
       {
           for (int i = 0; i < Dset.Tables[0].Rows.Count; i++)
           {
               DataRow dr = Dset.Tables[0].Rows[i];
               int a = Convert.ToInt32(dr["L1"]);
               int b = Convert.ToInt32(dr["L2"]);

               int c = a * b;
               dr["L3"] = c.ToString();
           }
       }

Good luck.