i want to convert datetime into date only to get values from db

[jimmybaba]

hi all i am newly graduate and started my first job.......i am geting problem to convert datetime into date only , i am trying to get values from sqlserver table with comparison of date. i am using c# what i am doing is:
switch (completed)
{
case 0 : if(date<DateTime.Today)
e.Cell.Text += "<tr><td style=\"font-size:8px;color:red;line-height:12px;vertical-align:center;\">";
e.Cell.Text += "<tr><td style=\"font-size:8px;color:blue;line-height:12px;vertical-align:center;\">";
break;
case 1 : e.Cell.Text += "<tr><td style=\"font-size:8px;color:green;line-height:10px;vertical-align:center;\">";
break;
}

in completed column either i have 0 or 1 . 0 i am using to get two values with comparison of date and 1 is showing true.

hopefully you will help me to solve this problem

waiting

[Plater]

Well I made your code a little "neater" to have a better look at it.
What is you question exactly? I see that you are switching on a "completed" variable. if completed=0 then check to see if "date" was before today's date. if it is, you add some html data. Then, regardless of the outcome of that if statement, you add MORE html data (creating broken tags and incorrect html).
if completed==1 then you just add one set of html data.

switch (completed)
{
   case 0 : 
      if(date<DateTime.Today)
      {
         e.Cell.Text += "<tr><td style=\"font-size:8px;color:red;line-height:12px;vertical-align:center;\">";
      }
      e.Cell.Text += "<tr><td style=\"font-size:8px;color:blue;line-height:12px;vertical-align:center;\">";
      break;
   case 1 : 
      e.Cell.Text += "<tr><td style=\"font-size:8px;color:green;line-height:10px;vertical-align:center;\">";
      break;
}