Running Total of specific rows of a datagridview

ullas K

Hi,
      I have a Datagridview with Columns Product Name, Unit Price,Qty ,Total and Status. The value of Status Column will be "Y" or "N" depending upon the Product which is fetched from the database.What i need is to get the Grand total of Products with Status="Y" in Textbox1 and the Total of Products with Status="N" in TextBox2. This is what i should get,

Product       Unit Price     Qty   Total      Status

   A                   10             2       20.00      Y
   B                    20            1       20.00      N
   C                    50            2     100.00      Y
   D                   30             1       30.00      Y
   E                    25            1     25.00      N

                            TextBox1=150.00
                            TextBox2= 45.00

How to acheive this.Pls help and thanks in advance

4 Replies

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

Vulpes13y ago
The error message suggests that the Status column (column 4) may sometimes contain no data i.e. the Value property is null.

If that's the case, should we assume that it contains Y or N for the purposes of adding up the figures?
0
Anurag Sarkar13y ago
http://onurag-dotnetfunda.blogspot.in/ Please check this out.
0
ullas K13y ago
Thank you for your support but i am not getting the answer.what it is saying is " Object reference not set to an instance" in the line stat = dataGridViewEx1.Rows[row.Index].Cells[4].Value.ToString(); Actually my column4(status) is a invisible column.When i enter Value in the Qty column should all these happen
0
Gaurav Gupta13y ago
int i=0;
int j=0;

foreach (DataGridViewRow row in GrdCheckins.Rows)
{

status = GrdCheckins.Rows[row.Index].Cells[4].Value.ToString());

If (status=="Y")
{

i=i+Convert.ToInt32(GrdCheckins.Rows[row.Index].Cells[3].Value);

}
else if(status=="N")
{

j=j+Convert.ToInt32(GrdCheckins.Rows[row.Index].Cells[3].Value);

}
}

TextBox1=i.ToSting();
TextBox2= j.ToString();

Note: GrdCheckins is the name of the DataGridView Control.
0