Loading

(C#) I need to multiply the price and qty in datagridview?

Sai Yang

Hi all! I meed to multiply the price and tqy in datagridview to display the sum to third cell on currentrow. I my default price is 0.0 so I give the new value to it and the default qty is 1. After I am changimg the price to new value I press Enter key on keyboard or press allow next on keyboard I need the price automatically sum to third cell. How do I do it and which event I put the source code to. I new user in developing C# winform. Thank so much.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ravishankar N8y ago
Hi Sai Yang,

You can multiply the datagrid values by below code
int price = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value);
int qty = Convert.ToInt32(dataGridView1.CurrentRow.Cells[1].Value);
int result = price * qty;
dataGridView1.CurrentRow.Cells[2].Value = result;
+1
snehal suryavanshi8y ago
1. private void dataGridView1_CurrentCellChanged(object sender, EventArgs e)
2. {
3. for (int i = 0; i < dataGridView1.Rows.Count; ++i)
4. {
5. int price = Convert.ToInt32(dataGridView1.Rows[i].Cells[1].Value);
6. int quantity = Convert.ToInt32(dataGridView1.Rows[i].Cells[2].Value);
8. dataGridView1.Rows[i].Cells[3].Value = price * quantity;
10. }
11. }
+1