How to highlight specific date/dates in MonthCalendar?

Question

Dear Memebers, Greetings of the day.... In my application of holiday planner, I want to highlight some dates as holiday in month calendar. I have saved a sequence of dates in a datatable as holidays (e.g. from 25/02/2018 to 28/02/2018). is there any way to highlight the dates in calendar? please note that I am working in C# WinApp and using MS Access as database. thank you mayank jani

Raja T · Answer

Hi Jani, i have used sql server db... u can change to ms access below code working fine. please try and let me know.... private void mothlycalender_Load(object sender, EventArgs e) { List list = new List (); DateTime[] VacationDates = { }; SqlConnection conn = new SqlConnection (@"Data Source=localhost;Initial Catalog=TestDemo; User ID=sa;Password=passwd@123"); conn.Open(); SqlDataAdapter da = new SqlDataAdapter ("SELECT [STARTDATE ] FROM tablename ", conn); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i { DateTime date = Convert.ToDateTime(ds.Tables[0].Rows[i][0].ToString()); list.Add(date); } } monthCalendar1.BoldedDates = list.ToArray(); }

Raja T · Answer

Hi,most welcome Jani, Happy coding :)

Mayank Jani · Answer

Hi Raja T, It's working perfectly. Thank You So Much.... :)

Mayank Jani · Answer

Hi Raja T, thank you for your reply. I have been already visited the site before I posted my query here. I have a table 'Holiday' and there are some dates saved as holiday e.g. 21/02/2018, 22/02/2018, 23/02/2018 etc. I want it as, when my formHoliday gets load, the system should read the table and highlight the month calendar according to the datatable date values. please suggest me how to do this or kindly suggest the code to achieve the result. thank you Mayank Jani

Raja T · Answer

Hi, please refer below link... http://www.authorcode.com/how-to-show-specific-dates-in-bold-in-monthcalendar-control/