>>> >>>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); >>> >>>>>>
>>>cmd.CommandText =
>>>"Select * From EventInfo Where EventDate >= #03/03/2007# And EventDate <= #11/24/2007#";
>>>
>>>that is working !>>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); >> >>cmd.CommandText = >> String.Format("Select * From EventInfo Where EventDate >= #{0}# And EventDate <= #{1}#", >> startDate.ToString("MM/dd/yyyy"), >> endDate.ToString("MM/dd/yyyy") ); >>>>Cetin