How to save date range in database?

Question

Dear Members,

 

Greetings of the day....

 

In my C# WinApp, I am trying to create  a holiday planner. It is about to remind the user that there are some holidays in this month or up coming month.

 

there are two DateTimePickers in the form and a CommandButton to save the holidays. for example, I want to mark holidays from 20-Feb-2017 to 25-Feb-2017. 

Now, I need to save a date sequence from 20th to 25th in DataTable. please guide me how to do this..

 

also, is it possible to highlight the dates which are markd as holidays?

 

Please note that I am working on C# WinApp and using MS Access as database.

 

Thank You...

 

Mayank Jani