Unselectable dates in Calendar

[na]

I need to make certain date selectable in a calendar control depending
on records found in a database. For example, if the 10/20/2006 and
11/20/2006 records exist in the database, then only enable and
highlight thoese two days in the calendar control. Also, I need to
disable all weekends. Is this doable? How do I do this in the
calendar control's DataBinding, Load, or PreRender event. Thanks.

[Bruno Alexandre]

you do that in DayRender event of the Calendar Control

http://odetocode.com/Articles/223.aspx

--

Bruno Alexandre
København, Danmark

"a Portuguese in Denmark"

Blog. http://balexandre.blogspot.com/
Photos. http://www.flickr.com/photos/balexandre/
"na" <an********@yahoo.comwrote in message
news:11**********************@b28g2000cwb.googlegr oups.com...

>I need to make certain date selectable in a calendar control depending
on records found in a database. For example, if the 10/20/2006 and
11/20/2006 records exist in the database, then only enable and
highlight thoese two days in the calendar control. Also, I need to
disable all weekends. Is this doable? How do I do this in the
calendar control's DataBinding, Load, or PreRender event. Thanks.

[na]

Thank you for your response.

Great article, but I need the dates rendered as text inside e.cell, not
as <Atag for those dates that have not data in the database. I used
e.cell.enabled=false, but it still render each date as <Ainside <TD>
tag. Thanks.

On Oct 14, 5:15 am, "Bruno Alexandre" <[e-mail]:

you do that in DayRender event of the Calendar Control

http://odetocode.com/Articles/223.aspx

--

Bruno Alexandre
København, Danmark

"a Portuguese in Denmark"

Blog.http://balexandre.blogspot.com/
Photos.http://www.flickr.com/photos/balexandre/

"na" <[e-mail] in messagenews:11**********************@b28g2000cwb.g ooglegroups.com...

I need to make certain date selectable in a calendar control depending
on records found in a database. For example, if the 10/20/2006 and
11/20/2006 records exist in the database, then only enable and
highlight thoese two days in the calendar control. Also, I need to
disable all weekends. Is this doable? How do I do this in the
calendar control's DataBinding, Load, or PreRender event. Thanks.- Hidequoted text -- Show quoted text -

[Mark Rae]

"na" <an********@yahoo.comwrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

Great article, but I need the dates rendered as text inside e.cell, not
as <Atag for those dates that have not data in the database. I used
e.cell.enabled=false, but it still render each date as <Ainside <TD>
tag. Thanks.

Preventing days being "clickable" is extremely simple. All you do is clear
the controls in the <tdand then write the date back in so that it's still
visible.

E.g. the following code will prevent dates being clicked if they fall on a
weekend:

protected void cal_DayRender(object source, DayRenderEventArgs e)
{
if (e.Day.IsWeekend)
{
e.Cell.Controls.Clear();
e.Cell.Text = e.Day.DayNumberText;
}
}

You could also give the user some sort of visual hint that the weekend dates
are "different", maybe by changing the back colour of the <tdor the font
colour.

You can even get rid of the dates entirely. I sometimes do this if they fall
outside the current month e.g.

if (e.Day.IsOtherMonth)
{
e.Cell.Controls.Clear();
e.Cell.Text = "&nbsp;"
}

[na]

Thanks, Mark. Now add one more twist. How do I disable the dates that
does not have record in a database? I hope I dont' have to connect to
the database and query it using the e.date as a parameter. It would be
too many connections and queries going on. Thanks.

On Oct 14, 3:19 pm, "Mark Rae" <[e-mail]:

>
Preventing days being "clickable" is extremely simple. All you do is clear
the controls in the <tdand then write the date back in so that it's still
visible.

E.g. the following code will prevent dates being clicked if they fall on a
weekend:

protected void cal_DayRender(object source, DayRenderEventArgs e)
{
if (e.Day.IsWeekend)
{
e.Cell.Controls.Clear();
e.Cell.Text = e.Day.DayNumberText;
}

}You could also give the user some sort of visual hint that the weekend dates
are "different", maybe by changing the back colour of the <tdor the font
colour.

You can even get rid of the dates entirely. I sometimes do this if they fall
outside the current month e.g.

if (e.Day.IsOtherMonth)
{
e.Cell.Controls.Clear();
e.Cell.Text = "&nbsp;"
}

[Mark Rae]

"na" <an********@yahoo.comwrote in message
news:11********************@k70g2000cwa.googlegrou ps.com...

Thanks, Mark. Now add one more twist. How do I disable the dates that
does not have record in a database? I hope I dont' have to connect to
the database and query it using the e.date as a parameter. It would be
too many connections and queries going on

No of course not - that would be ridiculous.

I do this by querying the database once to return all records between the
start and end date of the calendar (or calendars) on the page, which I then
store in a List<DateTimegeneric collection. Then, on the DayRender, I
simply check if the generic list contains the key e.Date.

pseudo-code:

List<DateTimemlstDates = new List<DateTime>;

Page_Init or Page_Load
{
<clear out mlstDates>;
SqlDataReader objDR = <SqlDataReader of dates>;
while (objDR.Read())
{
mlistDates.Add(<Date from SqlDataReader>);
}
}

Calendar_DayRender
{
if (!mlstDates.ContainsKey(e.Date))
{
// disable the date in the Calendar;
}
}