asp:calendar binds last value to date from database

See more:

ASP.NET

LINQ

I have to bind an <asp:calendar> with data fetched from a database using a linq query.

Here is the linq code

public List<AllCalander> SearchCalender(int month, int zip, string type, int cause)
{
        var xyz = (from m in DB.Calenders 
                   where(m.DateFrom.Value.Month==month || m.Zip==zip || m.ActivityType==type || m.CauseID==cause) 
                   group m by new { m.DateFrom } into grp
                   select new
                   {
                       caustitle = grp.Select(x => x.Caus.CauseTitle),
                       datfrm = grp.Key.DateFrom,
                       total = grp.Count()
                   })
          .ToList()
          .Select(m => new AllCalander
          {


              DateFrom =Convert.ToDateTime(m.datfrm),
              CauseTitle = string.Join(",", m.caustitle),
              Total = m.total
          });

My aspx.cs code is here

List<AllCalander> calnder = calbll.SearchCalender(mnth,ZipString,type,causeString);

foreach (var myItem in calnder)
{
    string datetime = myItem.DateFrom.ToString();

    Literal myEventNameLiteral = new Literal();
    myEventNameLiteral.ID = i + myItem.CauseID.ToString();

    // string currentcalanderDate = e.Day.Date.Day.ToString() ;
    if (string.Equals(DateTime.Parse(datetime).ToString("MMM dd yyyy"), e.Day.Date.ToString("MMM dd yyyy")))
    {
        string a = myItem.CauseTitle;

        if (a != cause)
            cause = a;

        coun++;

        myEventNameLiteral.Mode = LiteralMode.PassThrough;
        myEventNameLiteral.Text = "<br /><span style='font-family:verdana; font-size:10px;'>" + myItem.CauseTitle + "(" + myItem.Total + ")"+ " ";
        e.Cell.Controls.Add(myEventNameLiteral);
    }

    i++;
}

but on output it only shows the last value from database(overwriting the previous one) instead of showing all the data.

Can somebody please tell me what's wrong? Thanks in advance