how to set holidays in calendar control from xml file

i have attached working code once please check and if it is helped you please mark my answer.

Front End: aspx page

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>title>
head>
<body>
<form id="form1" runat="server">
<div>
<div>
<p style="text-align: center">
<b>
<asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Names="Arial Black" Font-Size="Medium"
ForeColor="#0066FF">Indian List of Holidays 2011asp:Label>
<br />
b>
p>
<asp:Calendar ID="Calendar1" runat="server" BackColor="#FFFFCC" BorderColor="#FFCC66"
BorderWidth="1px" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt"
ForeColor="#663399" ShowGridLines="True" OnDayRender="Calendar1_DayRender" OnSelectionChanged="Calendar1_SelectionChanged"
OnVisibleMonthChanged="Calendar1_VisibleMonthChanged">
<SelectedDayStyle BackColor="#CCCCFF" Font-Bold="True" />
<SelectorStyle BackColor="#FFCC66" />
<TodayDayStyle BackColor="#FFCC66" ForeColor="White" />
<OtherMonthDayStyle ForeColor="#CC9966" />
<NextPrevStyle Font-Size="9pt" ForeColor="#FFFFCC" />
<DayHeaderStyle BackColor="#FFCC66" Font-Bold="True" Height="1px" />
<TitleStyle BackColor="#990000" Font-Bold="True" Font-Size="9pt" ForeColor="#FFFFCC" />
asp:Calendar>
<br />
<b>b>
<asp:Label ID="LabelAction" runat="server">asp:Label>
<br />
b>
div>
div>
form>
body>
html>

backend : aspx.cs

using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml.Linq;
namespace CalenderHoldaysAndEvents
{
public partial class Calender : System.Web.UI.Page
{
Hashtable HolidayList;
protected void Page_Load(object sender, EventArgs e)
{
HolidayList = Getholiday();
Calendar1.Caption = "Calender - Author: Brijesh";
Calendar1.FirstDayOfWeek = FirstDayOfWeek.Sunday;
Calendar1.NextPrevFormat = NextPrevFormat.FullMonth;
Calendar1.TitleFormat = TitleFormat.MonthYear;
Calendar1.ShowGridLines = true;
Calendar1.DayStyle.Height = new Unit(50);
Calendar1.DayStyle.Width = new Unit(50);
Calendar1.DayStyle.HorizontalAlign = HorizontalAlign.Center;
Calendar1.DayStyle.VerticalAlign = VerticalAlign.Middle;
Calendar1.OtherMonthDayStyle.BackColor = System.Drawing.Color.AliceBlue;
}
protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
if (HolidayList[e.Day.Date.ToShortDateString()] != null)
{
Literal literal1 = new Literal();
literal1.Text = "
";
e.Cell.Controls.Add(literal1);
Label label1 = new Label();
label1.Text = (string)HolidayList[e.Day.Date.ToShortDateString()];
label1.Font.Size = new FontUnit(FontSize.Small);
label1.Font.Bold = true;
e.Cell.Controls.Add(label1);
}
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
LabelAction.Text = "Date changed to :" + Calendar1.SelectedDate.ToShortDateString();
}
protected void Calendar1_VisibleMonthChanged(object sender, MonthChangedEventArgs e)
{
LabelAction.Text = "Month changed to :" + e.NewDate.ToShortDateString();
}
private Hashtable Getholiday()
{
Hashtable holiday = new Hashtable();
XDocument doc = XDocument.Load("XMLFilePath");
var holidays = doc.Descendants("Holiday");
foreach (var hol in holidays)
{
DateTime date = Convert.ToDateTime(((System.Xml.Linq.XContainer)hol.FirstNode).FirstNode.ToString());
string Date = date.Month + "/" + date.Day + "/" + date.Year; ;
string Occasion = ((System.Xml.Linq.XContainer)hol.LastNode).LastNode.ToString();
holiday[Date] = Occasion;
}
//holiday["1/1/2019"] = "New Year";
//holiday["1/5/2019"] = "Guru Govind Singh Jayanti";
//holiday["1/8/2019"] = "Muharam (Al Hijra)";
//holiday["1/14/2019"] = "Pongal";
//holiday["1/26/2019"] = "Republic Day";
//holiday["2/23/2019"] = "Maha Shivaratri";
//holiday["3/10/2019"] = "Milad un Nabi (Birthday of the Prophet";
//holiday["3/21/2019"] = "Holi";
//holiday["3/21/2019"] = "Telugu New Year";
//holiday["4/3/2019"] = "Ram Navmi";
//holiday["4/7/2019"] = "Mahavir Jayanti";
//holiday["4/10/2019"] = "Good Friday";
//holiday["4/12/2019"] = "Easter";
//holiday["4/14/2019"] = "Tamil New Year and Dr Ambedkar Birth Day";
//holiday["5/1/2019,5/1/2019"] = "May Day";
//holiday["5/9/2019"] = "Buddha Jayanti and Buddha Purnima";
//holiday["6/24/2019"] = "Rath yatra";
//holiday["8/13/2019"] = "Krishna Jayanthi";
//holiday["8/14/2019"] = "Janmashtami";
//holiday["8/15/2019"] = "Independence Day";
//holiday["8/19/2019"] = "Parsi New Year";
//holiday["8/23/2019"] = "Vinayaka Chaturthi";
//holiday["9/2/2019"] = "Onam";
//holiday["9/5/2019"] = "Teachers Day";
//holiday["9/21/2019"] = "Ramzan";
//holiday["9/27/2019"] = "Ayutha Pooja";
//holiday["9/28/2019"] = "Vijaya Dasami (Dusherra)";
//holiday["10/2/2019"] = "Gandhi Jayanti";
//holiday["10/17/2019"] = "Diwali & Govardhan Puja";
//holiday["10/19/2019"] = "Bhaidooj";
//holiday["11/2/2019"] = "Guru Nanak Jayanti";
//holiday["11/14/2019"] = "Children's Day";
//holiday["11/28/2019"] = "Bakrid";
//holiday["12/25/2019"] = "Christmas Day";
//holiday["12/28/2019"] = "Muharram";
return holiday;
}
}
}

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

brijesh rathor7y ago
I have attached source code files so please once check.

thanks
brijesh rathor7y ago
Hi Sujit,
i have used same xml as you mentioned in question. and able to show calender holidays.

are you used my same code which i have attached? please create one aspx page and then just copy paste my code . it sure work because i have tested in my machine.

thanks

my xml format is:

01/01/2019
New Year Day

02/26/2019
Republic Day

08/15/2019
IndependenceDay

1/26/2019
Republic Day

1/14/2019
Pongal

2/23/2019
Maha Shivaratri

i compared your xml it is datetime format issue now once check it and let me know if still you will face issue. you need to maintain mm/dd/yyyy date format in xml file.
Sujit Sahoo7y ago
can you please tell me what is your xml format?

Mine xml File is this but still didn't get my value in calendar control don't know why.

01/01/2019
New Year Day
26/01/2019
Republic Day
18/02/2019
My BirthDay

here i am again face same problem.my control didn't enter if block.

Here i got value in Holiday list but control didn't enter my block what to do.

Thanks for your all reply.
brijesh rathor7y ago
once check below screenshot.
brijesh rathor7y ago
i used same xml as you mentioned and got result.
brijesh rathor7y ago
hi sujit that issue is correct date format .
i have attached working solution code in up just once check it will sure work.
Sujit Sahoo7y ago
protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
if (HolidayList[e.Day.Date.ToShortDateString()] != null)
{
Literal literal1 = new Literal();
literal1.Text = "
";
e.Cell.Controls.Add(literal1);
Label label1 = new Label();
label1.Text = (string)HolidayList[e.Day.Date.ToShortDateString()];
label1.Font.Size = new FontUnit(FontSize.Small);
label1.Font.Bold = true;
e.Cell.Controls.Add(label1);
}
}

In HolidayList i got my all value but control didn't enter my inside if block.
thats the reason i didn't get my output in calendar control.
brijesh rathor7y ago
i have attached working code once please check and if it is helped you please mark my answer.

Front End: aspx page
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>title>
head>
<body>
<form id="form1" runat="server">
<div>
<div>
<p style="text-align: center">
<b>
<asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Names="Arial Black" Font-Size="Medium"
ForeColor="#0066FF">Indian List of Holidays 2011asp:Label>
<br />
b>
p>
<asp:Calendar ID="Calendar1" runat="server" BackColor="#FFFFCC" BorderColor="#FFCC66"
BorderWidth="1px" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt"
ForeColor="#663399" ShowGridLines="True" OnDayRender="Calendar1_DayRender" OnSelectionChanged="Calendar1_SelectionChanged"
OnVisibleMonthChanged="Calendar1_VisibleMonthChanged">
<SelectedDayStyle BackColor="#CCCCFF" Font-Bold="True" />
<SelectorStyle BackColor="#FFCC66" />
<TodayDayStyle BackColor="#FFCC66" ForeColor="White" />
<OtherMonthDayStyle ForeColor="#CC9966" />
<NextPrevStyle Font-Size="9pt" ForeColor="#FFFFCC" />
<DayHeaderStyle BackColor="#FFCC66" Font-Bold="True" Height="1px" />
<TitleStyle BackColor="#990000" Font-Bold="True" Font-Size="9pt" ForeColor="#FFFFCC" />
asp:Calendar>
<br />
<b>b>
<asp:Label ID="LabelAction" runat="server">asp:Label>
<br />
b>
div>
div>
form>
body>
html>
backend : aspx.cs
using System;
using System.Collections;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Xml.Linq;
namespace CalenderHoldaysAndEvents
{
public partial class Calender : System.Web.UI.Page
{
Hashtable HolidayList;
protected void Page_Load(object sender, EventArgs e)
{
HolidayList = Getholiday();
Calendar1.Caption = "Calender - Author: Brijesh";
Calendar1.FirstDayOfWeek = FirstDayOfWeek.Sunday;
Calendar1.NextPrevFormat = NextPrevFormat.FullMonth;
Calendar1.TitleFormat = TitleFormat.MonthYear;
Calendar1.ShowGridLines = true;
Calendar1.DayStyle.Height = new Unit(50);
Calendar1.DayStyle.Width = new Unit(50);
Calendar1.DayStyle.HorizontalAlign = HorizontalAlign.Center;
Calendar1.DayStyle.VerticalAlign = VerticalAlign.Middle;
Calendar1.OtherMonthDayStyle.BackColor = System.Drawing.Color.AliceBlue;
}
protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
if (HolidayList[e.Day.Date.ToShortDateString()] != null)
{
Literal literal1 = new Literal();
literal1.Text = "
";
e.Cell.Controls.Add(literal1);
Label label1 = new Label();
label1.Text = (string)HolidayList[e.Day.Date.ToShortDateString()];
label1.Font.Size = new FontUnit(FontSize.Small);
label1.Font.Bold = true;
e.Cell.Controls.Add(label1);
}
}
protected void Calendar1_SelectionChanged(object sender, EventArgs e)
{
LabelAction.Text = "Date changed to :" + Calendar1.SelectedDate.ToShortDateString();
}
protected void Calendar1_VisibleMonthChanged(object sender, MonthChangedEventArgs e)
{
LabelAction.Text = "Month changed to :" + e.NewDate.ToShortDateString();
}
private Hashtable Getholiday()
{
Hashtable holiday = new Hashtable();
XDocument doc = XDocument.Load("XMLFilePath");
var holidays = doc.Descendants("Holiday");
foreach (var hol in holidays)
{
DateTime date = Convert.ToDateTime(((System.Xml.Linq.XContainer)hol.FirstNode).FirstNode.ToString());
string Date = date.Month + "/" + date.Day + "/" + date.Year; ;
string Occasion = ((System.Xml.Linq.XContainer)hol.LastNode).LastNode.ToString();
holiday[Date] = Occasion;
}
//holiday["1/1/2019"] = "New Year";
//holiday["1/5/2019"] = "Guru Govind Singh Jayanti";
//holiday["1/8/2019"] = "Muharam (Al Hijra)";
//holiday["1/14/2019"] = "Pongal";
//holiday["1/26/2019"] = "Republic Day";
//holiday["2/23/2019"] = "Maha Shivaratri";
//holiday["3/10/2019"] = "Milad un Nabi (Birthday of the Prophet";
//holiday["3/21/2019"] = "Holi";
//holiday["3/21/2019"] = "Telugu New Year";
//holiday["4/3/2019"] = "Ram Navmi";
//holiday["4/7/2019"] = "Mahavir Jayanti";
//holiday["4/10/2019"] = "Good Friday";
//holiday["4/12/2019"] = "Easter";
//holiday["4/14/2019"] = "Tamil New Year and Dr Ambedkar Birth Day";
//holiday["5/1/2019,5/1/2019"] = "May Day";
//holiday["5/9/2019"] = "Buddha Jayanti and Buddha Purnima";
//holiday["6/24/2019"] = "Rath yatra";
//holiday["8/13/2019"] = "Krishna Jayanthi";
//holiday["8/14/2019"] = "Janmashtami";
//holiday["8/15/2019"] = "Independence Day";
//holiday["8/19/2019"] = "Parsi New Year";
//holiday["8/23/2019"] = "Vinayaka Chaturthi";
//holiday["9/2/2019"] = "Onam";
//holiday["9/5/2019"] = "Teachers Day";
//holiday["9/21/2019"] = "Ramzan";
//holiday["9/27/2019"] = "Ayutha Pooja";
//holiday["9/28/2019"] = "Vijaya Dasami (Dusherra)";
//holiday["10/2/2019"] = "Gandhi Jayanti";
//holiday["10/17/2019"] = "Diwali & Govardhan Puja";
//holiday["10/19/2019"] = "Bhaidooj";
//holiday["11/2/2019"] = "Guru Nanak Jayanti";
//holiday["11/14/2019"] = "Children's Day";
//holiday["11/28/2019"] = "Bakrid";
//holiday["12/25/2019"] = "Christmas Day";
//holiday["12/28/2019"] = "Muharram";
return holiday;
}
}
}
brijesh rathor7y ago
Hi sujit,

first we need to get holidays from xml.

after that please use below url for showing event and holiday date in calender.

https://www.c-sharpcorner.com/uploadfile/d5b8d2/how-to-add-holiday-details-within-calendar-control/

in above url consists Getholiday function there we need to extract holidays from xml file other code will same. hope it will help you.