如何将两列的数据乘以datagridview中的第三列 [英] How to multiply data of two columns for third column in datagridview

问题描述

我想将两列的数据相乘并在第三列中显示。

I want to multiply the data of two columns and show it in the third column.

例如：

1st Column: Quantity
2nd Column: Rate
3rd Column: Price

我想在用户输入数量和费率数据时相乘，例如 Quantity = 2 ， rate =我想在价格栏中自动显示50 100 。

I want to multiply as user enters the data for quantity and rate like Quantity=2, rate=50automatically in price column I want 100 to be appear.

同时我想要用户输入数量和费率数据（例如 Price = 100 ， rate = 50 ）时自动进行数量划分希望出现 2 。

Simultaneously I want to division as user enters the data for quantity and rate like Price=100, rate=50automatically in Quantity column I want 2 to be appear.

当用户输入数量和费率的数据时，例如
我想要在 50 Price = 100 ， Quantity = 2 $ c>出现。

And when a user enters the data for quantity and rate like Price=100, Quantity=2automatically in Rate column I want 50 to be appear.

这三个将在同一datagridview中发生。用户只需输入这三个字段中的任何两个字段，第三个字段就会自动出现。

This three will happen in a same datagridview. User only enter any two field within this three and third will come automatically.

使用C＃，VS2008，SQL 2008

Using C#, VS2008, SQL 2008

private void dataGridView2_CellEndEdit(object sender, DataGridViewCellEventArgs e) 
{ 
    int quantity,rate; 
    for (int i = 0; i < dataGridView2.Rows.Count; i++) 
    { 
        if(int.TryParse(dataGridView2.Rows[i].Cells[1].Value.ToString(), out quantity) && int.TryParse(dataGridView2.Rows[i].Cells[2].Value.ToString(), out rate)) 
        { 
             int price = quantity * rate; dataGridView2.Rows[i].Cells[3].Value = price.ToString(); 
        } 
    } 
}

我写这段代码。显示错误。对象引用未设置为

I write this code. There shows a error. Object reference not set to an instance of an object on

if(int.TryParse(dataGridView2.Rows[i].Cells[1].Value.ToString(), out quantity) && int.TryParse(dataGridView2.Rows[i].Cells[2].Value.ToString(), out rate)) 

此行。

我想做这个。用户可以在这3个字段中填写任意2个字段。第三个字段将自动填写。

I want to do like this. User can fill any 2 field among this 3. And third will take automatically.

推荐答案

处理gridview的 CellEndEdit 事件。然后在这种情况下，将值计算并分配给第三列

handle the CellEndEdit event of your gridview. And in that event calculate and assign the value to the third column

类似

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
    {
        int quantity,rate;
        if (int.TryParse(dataGridView1.Rows[e.RowIndex].Cells["quantity"].Value.ToString(), out quantity) && int.TryParse(dataGridView1.Rows[e.RowIndex].Cells["rate"].Value.ToString(), out rate))
        {
            int price = quantity * rate;
            dataGridView1.Rows[e.RowIndex].Cells["price"].Value = price.ToString();
         }
    }

这篇关于如何将两列的数据乘以datagridview中的第三列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！