cmd.CommandText = String.Format("Select * From EventInfo Where EventDate >= #{0}# And EventDate <= #{1}#", startDateString, endDateString); .... 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); string startDateString = startDate.ToString("MM-dd-yyyy"); string endDateString = endDate.ToString("MM-dd-yyyy");~~Bonnie
> >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 !