I have following line of code that sometimes works, and sometimes doesn't.
teScalar) = False Then ThereIsEntry = adapter.SelectCommand.Exec
uteScalar Else ThereIsEntry = "0"
ThereIsEntry type is String
Sometimes ThereIsEntry is "0", sometimes is "ABCD", but the problem is when ThereISEntry shows as nothing when should be DBNull since there is 0 Rows inside table.
Table is empty, but it still recognize as valid row, but just as empty space and not DBNull.