SELECT NAME, CASE WHEN dateSubmitted IS NULL THEN 'NOT YET SUBMITTED' ELSE 'ALREADY SUBMITTED' END 'STATUS' FROM MYTABLE
//dr is datareader if ( dr[0][0] is DBNull ) { //Handle null here }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)