hi, i have my calendar control code please help me how to display my database table entries to my calendar control
 protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        SelectedDatesCollection theDates = Calendar1.SelectedDates;
        DataTable dtSelectedDateEvents = Calendar1.EventSource.Clone();
        DataRow dr;

        foreach (DataRow drEvent in Calendar1.EventSource.Rows)
            foreach (DateTime selectedDate in theDates)
                if (selectedDate.Date >= (Convert.ToDateTime(drEvent[Calendar1.EventStartDateColumnName])).Date
                    && selectedDate.Date <= (Convert.ToDateTime(drEvent[Calendar1.EventEndDateColumnName])).Date)
                {
                    // This Condition is just to ensure that Every Event Details are added just only once
                    // irrespective of the number of days for which the event occurs.
                    if (dtSelectedDateEvents.Select("Id= " + Convert.ToInt32(drEvent["Id"])).Length > 0)
                        continue;

                    dr = dtSelectedDateEvents.NewRow();
                    dr["Id"] = drEvent["Id"];
                    dr[Calendar1.EventStartDateColumnName] = drEvent[Calendar1.EventStartDateColumnName];
                    dr[Calendar1.EventEndDateColumnName] = drEvent[Calendar1.EventEndDateColumnName];
                    dr[Calendar1.EventHeaderColumnName] = drEvent[Calendar1.EventHeaderColumnName];
                    dr[Calendar1.EventDescriptionColumnName] = drEvent[Calendar1.EventDescriptionColumnName];

                    //dr[Calendar1.EventForeColorName] = drEvent[Calendar1.EventForeColorName];
                    //dr[Calendar1.EventBackColorName] = drEvent[Calendar1.EventBackColorName];

                    dtSelectedDateEvents.Rows.Add(dr);
                }

        gvSelectedDateEvents.DataSource = dtSelectedDateEvents;
        gvSelectedDateEvents.DataBind();

    }
hi, i have my calendar control code please help me how to display my database table entries to my calendar control
===

 protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        SelectedDatesCollection theDates = Calendar1.SelectedDates;
        DataTable dtSelectedDateEvents = Calendar1.EventSource.Clone();
        DataRow dr;

        foreach (DataRow drEvent in Calendar1.EventSource.Rows)
            foreach (DateTime selectedDate in theDates)
                if (selectedDate.Date >= (Convert.ToDateTime(drEvent[Calendar1.EventStartDateColumnName])).Date
                    && selectedDate.Date <= (Convert.ToDateTime(drEvent[Calendar1.EventEndDateColumnName])).Date)
                {
                    // This Condition is just to ensure that Every Event Details are added just only once
                    // irrespective of the number of days for which the event occurs.
                    if (dtSelectedDateEvents.Select("Id= " + Convert.ToInt32(drEvent["Id"])).Length > 0)
                        continue;

                    dr = dtSelectedDateEvents.NewRow();
                    dr["Id"] = drEvent["Id"];
                    dr[Calendar1.EventStartDateColumnName] = drEvent[Calendar1.EventStartDateColumnName];
                    dr[Calendar1.EventEndDateColumnName] = drEvent[Calendar1.EventEndDateColumnName];
                    dr[Calendar1.EventHeaderColumnName] = drEvent[Calendar1.EventHeaderColumnName];
                    dr[Calendar1.EventDescriptionColumnName] = drEvent[Calendar1.EventDescriptionColumnName];

                    //dr[Calendar1.EventForeColorName] = drEvent[Calendar1.EventForeColorName];
                    //dr[Calendar1.EventBackColorName] = drEvent[Calendar1.EventBackColorName];

                    dtSelectedDateEvents.Rows.Add(dr);
                }

        gvSelectedDateEvents.DataSource = dtSelectedDateEvents;
        gvSelectedDateEvents.DataBind();

    }