DataTable Compute null values

[gchq]

Hi there

I am attempting to compute some values from a DataTable. It works fine as long as there is a value to retrieve, otherwise it blows out!

This will work as there are valid dates:-

Actuals_09.InnerText = Format(nTable.Compute("Sum(Amount)", "Item_Date >= " & "'" & vMonth09 & "'" & " AND Item_Date < " & "'" & vMonth10 & "'"), "###,##0.00")

But this will not:-

Actuals_02.InnerText = Format(nTable.Compute("Sum(Amount)", "Item_Date >= " & "'" & vMonth02 & "'" & " AND Item_Date < " & "'" & vMonth03 & "'"), "###,##0.00")

Is there a DataTable equiv. of IsNull ??? Or is there another way round this?

Thanks in advance

[gchq]

OK - found a way round it!

Dim vActual01 As Object = nTable.Compute("Sum(Amount)", "Item_Date >= " & "'" & vMonth01 & "'" & " AND Item_Date < " & "'" & vMonth02 & "'")
        If Not vActual01.Equals(DBNull.Value) Then
            Actuals_01.InnerText = Convert.ToDouble(Format(vActual01, "###,##0.00"))
        Else
            Actuals_01.InnerText = "0.00"
        End If

[kenobewan]

Well done! Thanks for sharing the solution. You could also use a try catch block to catch any errors.