Espero me puedan ayudar gracias
Código:
lbModelData.Text = "<table cellspacing=\"0\" cellpadding=\"0\"><tr><td colspan=\"3\" class=\"ownerTitle\">" + sqlDR_Items["ownerdesc"].ToString() + "</td></tr><tr><td class=\"checklistTitles\">Item</td><td class=\"checklistTitles\">Commit Date</td><td class=\"checklistTitles\">Completion Date</td></tr>";
sqlDR_Items.Close();
sqlDR_Items = sqlItems.ExecuteReader();
while (sqlDR_Items.Read())
{
DateTime fecha = DateTime.Parse(sqlDR_Items["commitDate"].ToString());
DateTime hoy = DateTime.Today;
if (sqlDR_Items["value"].ToString() == "0" && fecha <= hoy)
lbModelData.Text += "<tr><td style=\"height:21px;width:60%;padding-right:7px;background:DarkRed;color:white;\" class=\"checkListTD\">" + sqlDR_Items["item"] + "</td ><td style=\"width: 20%; text-align:center;background:DarkRed;color:white;\" class=\"checkListTD\">" + sqlDR_Items["commitDate"].ToString() + "</td><td class=\"checkbox\" style=\"background:DarkRed;color:white;\"><input id=\"cb" + i + "\" type=\"checkbox\"/></td></tr>";
else if (sqlDR_Items["value"].ToString() == "0" && fecha > hoy)
lbModelData.Text += "<tr><td style=\"height:21px;width:60%;padding-right:7px;\" class=\"checkListTD\">" + sqlDR_Items["item"] + "</td ><td style=\"width: 20%; text-align:center;background:gold;\" class=\"checkListTD\">" + sqlDR_Items["commitDate"].ToString() + "</td><td class=\"checkbox\"><input runat=\"server\" id=\"cb" + i + "\" type=\"checkbox\"/></td></tr>";
else if (sqlDR_Items["value"].ToString() == "1" && (sqlDR_Items["commitDate"].ToString() != sqlDR_Items["finishDate"].ToString()))
lbModelData.Text += "<tr><td style=\"height:21px;width:60%;padding-right:7px;\" class=\"checkListTD\">" + sqlDR_Items["item"] + "</td ><td class=\"checkListTD\" style=\"width:20%;text-align:center;vertical-align:middle;background:ForestGreen;color:white;\">" + sqlDR_Items["commitDate"].ToString() + "</td><td style=\"width:20%;text-align:center;background:ForestGreen;color:DarkRed;\" class=\"checkListTD\">" + sqlDR_Items["finishDate"].ToString() + "</td></tr>";
else if (sqlDR_Items["value"].ToString() == "1")
lbModelData.Text += "<tr><td style=\"height:21px;width:60%;padding-right:7px;\" class=\"checkListTD\">" + sqlDR_Items["item"] + "</td ><td class=\"checkListTD\" style=\"width:20%;text-align:center;vertical-align:middle;background:ForestGreen;color:white;\">" + sqlDR_Items["commitDate"].ToString() + "</td><td style=\"width:20%;text-align:center;background:ForestGreen;color:white;\" class=\"checkListTD\">" + sqlDR_Items["finishDate"].ToString() + "</td></tr>";
i++;
}
lbModelData.Text += "</table>";
sqlCon.Close();