Hi Cetin,

In fact I am fighting whole day with DataCalendar example by Mike Ellison and here is
problem:

cmd.CommandText =
String.Format("Select * From EventInfo Where EventDate >= #{0}# And EventDate <= #{1}#", 
              startDate, endDate);
....

DateTime startDate = new DateTime(cal1.VisibleDate.Year, cal1.VisibleDate.Month, 1).AddDays(-7);
DateTime endDate = new DateTime(cal1.VisibleDate.Date.AddMonths(1).Year, cal1.VisibleDate.Date.AddMonths(1).Month, 1).AddDays(7);

this gives error because date must be in form MM/dd/yyyy

if I put hardcoded dates like

cmd.CommandText =
"Select * From EventInfo Where EventDate >= #03/03/2007# And EventDate <= #11/24/2007#";    

that is working !

How should i put in above string startDate and endDate in MM/dd/yyyy format