Database

with cte as (
    SELECT  [Guid] ,
            UserGuid ,
            ReferenceGuid ,
            ReferenceID ,
            [Event] ,
            Comments ,
            [Time] ,
            IPAddress,
            rn = ROW_NUMBER() OVER (Partition By Event Order By Time Desc)
    FROM     EventLogs
)
select * from cte where rn = 1

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
    DateTime FromDate =Convert.ToDateTime(ddlFrom.SelectedValue);
    DateTime ToDate =Convert.ToDateTime(ddlTo.SelectedValue);
 
   if(e.Day.Date >= FromDate && e.Day.Date <= ToDate )
   {
	e.Cell.BackColor = System.Drawing.Color.Red;
   }
}

protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
//do databse connectivity 
//run while loop store this fromdate and todate in two variable
//do same thing as u have done to display in red fore
if (e.Day.Date < DateTime.Today)
{

e.Day.IsSelectable = false;
e.Cell.ForeColor = System.Drawing.Color.Gray;
}
else
{
if(e.Cell.ForeColor != System.Drawing.Color.Red)
e.Cell.ForeColor = System.Drawing.Color.Green;
}
if (e.Day.Date >= FromDate && e.Day.Date <= ToDate)
{
e.Cell.ForeColor = System.Drawing.Color.Red;
}
}