how to set holidays in calendar control from xml file

Question

I have an XML file containing some holiday list. 01/01/2019 New Year Day 02/26/2019 Republic Day 08/15/2019 IndependenceDay I have a Calendar control, so I want to display the holiday date and occasion in my calendar control. How to do this? Any suggestion. Thank You.

brijesh rathor · Answer

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 2011 asp: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; } } }

Sujit Sahoo · Answer

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 rathor · Answer

once check below screenshot.

brijesh rathor · Answer

i used same xml as you mentioned and got result.

brijesh rathor · Answer

hi sujit that issue is correct date format . i have attached working solution code in up just once check it will sure work.

Sujit Sahoo · Answer

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 rathor · Answer

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.

brijesh rathor · Answer

I have attached source code files so please once check. thanks

brijesh rathor · Answer

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.

how to set holidays in calendar control from xml file

Answers (9)