Saving month name and year from Ajax Calender into SQL Server 2005 DateTime Column

Question

I have a simple Asp.NET webform with a TextBox. I have attached an AjaxControlToolkit CalendarExtender to this TextBox to provide for Calendar functionality. I have set the CalenderExtender format property to "MMMM" such that the calender by default will display months rather than month days.

WHAT I WANT TO ACHIEVE:
I have a table with a StartMonth column whose datatype is DateTime. When the user selects say June or October from the calendar, I want to save that month in this DateTime column but unfortunately, strings "June" or "October, ....." can not be saved in a DateTime column.

How should implement this better?, I want to store the month name and year, I'm not interested in the day part.

Answer 1

i take this as the answer to my question.

http://www.aghausman.net/asp/how-to-show-and-select-monthyear-in-calendar-extender.html