Calculate sum(14.50) and 5.0 values the display in text box

Question

Dear Sir Please Find the attachment in that form VAT Percentage and Vat Amount VAT percentage has different type of percentege like 14.5,5.0 those details are will display in gridvie one by one so i want to calculate total value of 14.50 and same as 5.0 values from gridview please help me i am new to C#

Amit Gupta · Answer

@yesubabu Well, it was just an idea to get the tax amount quickly. I assume that DataTable has been used to bind the gridview. var dt = new DataTable (); // assuming having rows and bind with gridview var sumFirst = Convert.ToDouble (dt.Compute ( "Sum (vat)" , "[vat(%)] = 14.5" )); var sumSecond = Convert.ToDouble (dt.Compute ( "Sum (vat)" , "[vat(%)] = 5.0" )); // display your outputs as required Hope you got an idea to implement this.

yesubabu k · Answer

Sir Please Fint The Attachment Requirement is sum(14.50)=result sum(5.0)=result from gridview then i will show in text box please help to me sir

Ramesh Palanivel · Answer

Hi Yesubabu, Share your result code and send some screen shot of your result

yesubabu k · Answer

SIR total 14.50 values =Result total 5.0 values=Result how can i show seperatly

yesubabu k · Answer

SIR total 14.50 values =value total 5.0 values=value how can i show seperatly

Ramesh Palanivel · Answer

Hi Yesubabu, Its simple Try this code, private void Form3_Load( object sender, EventArgs e) { myDataGridView.Rows.Add(); myDataGridView.Rows.Add(); myDataGridView.Rows[0].Cells[0].Value = 1; myDataGridView.Rows[0].Cells[1].Value = "Ice Cream" ; myDataGridView.Rows[0].Cells[2].Value = 14.50; myDataGridView.Rows[1].Cells[0].Value = 1; myDataGridView.Rows[1].Cells[1].Value = "Cone" ; myDataGridView.Rows[1].Cells[2].Value = 5.0; } rivate void button1_Click( object sender, EventArgs e) { decimal sum = 0; for ( int i=0;i { sum = sum + Convert.ToDecimal(myDataGridView.Rows[i].Cells[2].Value); } MessageBox.Show(myDataGridView.Rows.Count.ToString()); myDataGridView.Rows[2].Cells[2].Value = sum; }

Calculate sum(14.50) and 5.0 values the display in text box

spgilmore