Datagridview column total

Question

I tried to calculate the total of the column named QTY in the datagridview. But I coul not.My code is below. Could you help me , please?

public int RowCount { get; set; }

    [BrowsableAttribute(false)]
    private void dataGridView1_SelectionChanged(object sender, EventArgs e)

    {

    private void UpdateLabelText()
    {
        int QtyTotal = 0;

        int counter;

        // Iterate through all the rows and sum up the appropriate columns.
        for (counter = 0; counter < (dataGridView1.Rows.Count);
            counter++)
        {
            if (dataGridView1.Rows[counter].Cells["Qty"].Value
                != null)
            {
                if (dataGridView1.Rows[counter].
                    Cells["Qty"].Value.ToString().Length != 0)
                {
                    QtyTotal += int.Parse(dataGridView1.Rows[counter].
                        Cells["Qty"].Value.ToString());
                }
            }
        }

        // Set the labels to reflect the current state of the DataGridView.
        label17.Text = "Qty Total: " + QtyTotal.ToString();

    }

What is the problem with that code? Exception, unexpected result? — Pikoh, Mar 06 '17 at 11:32
Close your SelectionChanged method. `private void dataGridView1_SelectionChanged(object sender, EventArgs e) { }` Just add `}` where you error is — Pikoh, Mar 06 '17 at 11:39
@Bahadir you need to add e closing bracket for which it shows error — Rami Far, Mar 06 '17 at 11:40

score 1 · Answer 1 · answered Mar 06 '17 at 11:36

1

Try this:

int sum = 0;
int col_index=YOUR_COLUMN_INDEX;
for (int i = 0; i < dataGridView1.Rows.Count; ++i)
{
    sum += Convert.ToInt32(dataGridView1.Rows[i].Cells[col_index].Value);
}
label17.Text= sum.ToString();

answered Mar 06 '17 at 11:36

imsome1

1,182
4
22
37

score 0 · Answer 2 · edited Mar 06 '17 at 11:50

0

Try this

foreach (DataGridViewRow item in dataGridView2.Rows)
{
  int n = item.Index;
  text_tot.Text = (int.Parse(label17.Text) + int.Parse(dataGridView1.Rows[n].Cells[(index)].Value.ToString())).ToString();
}

edited Mar 06 '17 at 11:50

imsome1

1,182
4
22
37

answered Mar 06 '17 at 11:39

Rami Far

406
1
10
29

Datagridview column total

2 Answers2