C# .NET - Checking for NULL values while computing the SUM of a dataset column.

Hi,

I am trying to compute the SUM total of a particular column in my DataSet.

I am using the below code to achieve it.

var totalABC = ds.Tables[0].AsEnumerable().SUM(x => Convert.ToDecimal(x["ABC"]));

where ABC is the column that I am summing up.

However, at runtime I get an error saying :

Cannot convert System.DBNull to decimal type. How do I check for Nulls in the above code & only convert the non-Null values to decimal?


Thanks in advance,
Charvi.

x["ABC"].ToString()

You may also need to write a little function that converts an empty string to zero.

var totalABC = ds.Tables[0].AsEnumerable().Sum(x => Convert.ToDecimal(x["ABC"] == DBNull.Value ? 0 : x["ABC"]));

You can decorate it more by avoiding x["ABC"] two times in expression.