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

yesubabu k

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#

6 Replies

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

Amit Gupta9y ago
Accepted 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 k9y ago
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 Palanivel9y ago
Hi Yesubabu,

Share your result code and send some screen shot of your result
yesubabu k9y ago
SIR

total 14.50 values =Result
total 5.0 values=Result

how can i show seperatly
yesubabu k9y ago
SIR

total 14.50 values =value
total 5.0 values=value

how can i show seperatly
Ramesh Palanivel9y ago
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;

       }