How to count all the rows in a column? using microsoft access 2000 database

[sword117]

i want to count all the rows values in a column,

example:

-- euro --
21
43
44
45



so if i count all i get 153 euro.

i already got this

     for (int i = 0; i < dataGridView26.RowCount; i++)
                    {
                        label34.Text = i.ToString();
 
                     }
 

help : )

[Christian Binder]

You can address the single rows of the DataGridView with dataGridView26.Rows[i]. This will return a DataGridViewRow with the specified index (i). Now you can call the Cells-property of this row with .Cells["myColumnName"].Value. That will return the cell's value as an object. At least, you just need to cast or convert this object to a numeric variable e.g. int and sum them up.