problem to find out the string is null or not

Question

in mysql default null value is (NULL)

when i try to use it in c# that code not work because it is a string who have a value "(NULL)"

how i can check that string is null or not. if i check by string.insnullorempty or ==null it's not worked

how can i check this row is null or not in c#

Answer 1

String.IsNullOrEmpty() - should help IMO...

Answer 2

Ok, so have you tried string.IsNullOrEmpty() or using a comparison like myValue == NULL?

Answer 3

Is it possible that you have some configuration problem (e.g. wrong SQL in 'create table' statement) for which mySql is returning you a string containing "(NULL)" instead of a null value?

Answer 4

if (dbval == System.DBNull.Value)