How to highlight specific date/dates in MonthCalendar?

Mayank Jani

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

5 Replies

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

Raja T8y ago
Accepted 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 < ds.Tables[0].Rows.Count; i++)
                  {
DateTime date = Convert.ToDateTime(ds.Tables[0].Rows[i][0].ToString());
list.Add(date);

}
}
         monthCalendar1.BoldedDates = list.ToArray();

}

0
Raja T8y ago
Hi,most welcome Jani, Happy coding :)
0
Mayank Jani8y ago
Hi Raja T,

It's working perfectly.

Thank You So Much.... :)
0
Mayank Jani8y ago
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
0
Raja T8y ago
Hi, please refer below link... http://www.authorcode.com/how-to-show-specific-dates-in-bold-in-monthcalendar-control/
0