SQL table check if cell is null

Help
1

Hi, I am querying a table where sometimes the value in the cell is null

How do you check for this? Do I use IsNothing(DT.Rows(0)(“column”)) ?

2

Hi,
If you need to check a column alone then you can check as you mentioned. But when need to check more columns then try to use linq for the same.

Instead of checking from the database if possible make that as a not null acceptable column in the database, so the source application should send the value for that column as well

3

The expression would be like
String.IsNullOrEmpty(Dt.Rows(rowindex)(“yourcolumnname”).ToString)

Where row index starts from 0 for first row

Cheers @DEATHFISH

1 Like