Get current month from calendar control

[thehms]

hi all...

i have a website that shows scheduled events. i am using the calendar control to view the days that have events in them by shading them.

i get the dates from SQL server, by having a stored rocedure tha selects the events according to this months month..

my problem is that when i want to see the events in any other month i cant, because i cannot extract the month number from the calendar control to pass it to the sql stored procedure.

how can i get the current displayed month on the calendar control?

Thanx...
The HMS

 

[thehms]

i got it...

i added this eventHandler:

public void Calendar1_VisibleMonthChanged(object sender, MonthChangedEventArgs e)
		{
			Response.Write("You moved from month " + e.PreviousDate.Month + " to month " + e.NewDate.Month + ".");
		}

and i added this in the page initialization:

			this.Calendar1.VisibleMonthChanged += new System.Web.UI.WebControls.MonthChangedEventHandler(this.Calendar1_VisibleMonthChanged);