SELECT Col1, Col2, Col3 FROM Table1 WHERE (Col1 IS NOT NULL) AND (Col2 IS NOT NULL) AND (Col3 IS NOT NULL)
var a = from p in obj.tableName where p.Col1 != null && p.Col2 != null select p;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)