blah blah blah is here! blah blah » Close

0
MikeDelvotti
690
333 views

Count double values in Datagridview rows

up1down
link

Guys, on form load i count my datagridview rows that only contain the status "UPREPD USED" and display the total on a label, it works fine.

My problem is i now want to count the rows that contain the status "UPREPD USED" and "UPREPD NEW" the code that works for the top line is below, i've tried putting ++ between the text quotations but doest work.

int count = 0; foreach (DataGridViewRow row in usedDataGridView.Rows)
            {
                if (row.IsNewRow) break;
                object obj = row.Cells[2].Value;
                if (obj != null && !DBNull.Value.Equals(obj) && obj.ToString() == "UNPREPD USED") count++;
                {
                    label6.Text = count.ToString();
                }
            }


As mentioned the above works but only to count one status.

count rows
  • asked one year ago
  • edited one year ago
add comment
last answered one year ago

1 answers

Sort:
up2down
tick
link

Just add to the condition a check for "UNPREPD NEW".

int count = 0;
foreach (DataGridViewRow row in usedDataGridView.Rows)
{
    if (row.IsNewRow) break;
    object val = row.Cells[2].Value;
    if (val != null && !DBNull.Value.Equals(val) &&
        (val.ToString() == "UNPREPD USED" || val.ToString() == "UNPREPD NEW"))
        count++;
}
label6.Text = count.ToString();


[edit]
oops on varnames.

  • answered one year ago by:

    Jeff1203
    538
  • edited one year ago
(x)
MikeDelvotti
690

Great reply - works a treat. Thanks.

add comment
Feedback