c# - How to check DBNull value in Linq query results

Question

I am using the below code and trying to group by Currency and Code. After this I am trying to loop through the result set.

But the issue is while looping through the results, at the end I am getting the below exception on the for each statement:

Object cannot be cast from DBNull to other types.

    DataTable dt = new DataTable();

    var result = from r in dt.AsEnumerable()
               result r by new
               {
                    currency = r.Field<String>("CURRENCY"),
                    Code = r.Field<String>("CODE")
               }
              into grp
              select new
              {
                   currency = grp.Key.currency,
                   Code = grp.Key.Code,
                   amount = grp.Sum(x => Convert.ToDouble(x["AMOUNT"]))
              };

    foreach (var obj in result)
    {
      String sCurr =obj.currency;
      String Code = obj.Code;
      string amount= obj.amount.ToString());
    }

Please help me to resolve this issue.

Answer 1

Something like

 amount = grp.Sum(x => Convert.ToDouble(x["AMOUNT"] == DBNull.Value ? 0 : x["AMOUNT"]));

If that is the line that is giving you the problem.