select * from Dev_tab where isnull(status,'') not in ('Cancelled','Completed')
ProjectList = (From c In db.Dev_tab Where c.Status <> "Cancelled" AndAlso c.Status <> "Completed"
From c in db.Dev_tab Where c.Status Is Nothing OrElse (c.Status <> "Cancelled" AndAlso c.Status <> "Completed")
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)