I have a variable amount contains value 300 and a datable with columns debit and credit.
I need to check if the amount is in the debit column which will have 300.00 and sometimes debit column will have empty values
I am able to compare with simple linq but getting error if the debit value is empty. Could you pls help in applying condition to remove empty values in debit before using linq condition and getting syntax error when trying this.
This is the linq using
It will work only if debit column is not empty. If it is empty will get error conversion from “” to double.