i am trying to SUM values .but there is so may NULL value so how i can total it? and my value is string value

Question

DataTable dt1 = new DAL.DALHelper().getData(cmd);

if (dt.Rows.Count > 0)
{
    int x = 0;
    foreach (DataRow r in dt.Rows)
    {
        x += Convert.ToInt32(r["amount"]);
    }
    lblExpense.Text = x.ToString();
}

I am trying to SUM values. but there is so may NULL value so how I can total it? And my value is string value. showing this error(Object cannot be cast from DBNull to other types.)

`Convert.ToInt32` returns `0` for `null` and that is not okey for you? Kind of confused.. — Soner Gönül, Sep 03 '15 at 13:14

score 0 · Answer 1 · answered Sep 03 '15 at 13:14

0

Check if r["amount"] != System.DBNull.Value. then add in sum.

answered Sep 03 '15 at 13:14

M_Idrees

2,080
2
23
53

i am trying to SUM values .but there is so may NULL value so how i can total it? and my value is string value

1 Answers1