I need to filter datatable for blanks

datatable
studio

#1

I have a datatable that has a status column. This column starts blank and once the first action is taken it is marked as found or not found. I want to be able filter the status column by blanks/null/empty but have been unsuccessful so far. i am using dtInvoiceNum.Select(“Status=Null”) to create an array of datarows and then doing a for each in the array.


#2

Hello!

Have you tried to use

dtInvoiceNum.Select(“Status=’’”)

OR

dtInvoiceNum.Select(“Status=’ '”) ?

Regards,


#3

i have tried the second but not the first i will try that now. Thanks


#4

Incase if above solution doesn’t work.

dtInvoiceNum.Select(“Status is NULL OR Status=''”)


#5

Status is Null worked Thanks vvaidya


#6

You can also use dtInvoiceNum.Select("[Status]=‘Null’").


#7

What to do for not null coloumns?