Multiplication operation of columns in datagrid ..?

Question

Hi Guys
Suppose I am having two columns and I wanted to perform multiplication on that and want output on another column
so how Can I.....?

Column Name :- Amt Quantity Total

total = Amt * Quantity.

Please hepl me........

Ankit Rathore · Answer

Gi Guys Please solve my problem  these things are not working ..............

Sreekanth · Answer

select amt as AMOUNTQuantity as Quantity (amt*Quantity) as Total from TABLE NAME

Lalit M · Answer

try this code DataTable dt = new DataTable(); DataColumn column4; column4 = new DataColumn(); column4.ColumnName = Column3; column4.Caption = Column3; column4.Expression = Column1*Column2; dt.Columns.Add(column3);

Jacob R · Answer

int myTotal = int.Parse(dataGridView1(0 0).Value) * int.Parse(dataGridView1(0 1).Value); dataGridView1(02).Value = myTotal.ToString(); dataGridView1.RefreshEdit(); my syntax might be off. I dont mess with dataGridView much. If the above doesn't work try dataGridView1.Rows[0].Cells[0].Value. Also remember that the rows and columns start at 0 and not 1