如何比较SQLdate和CalendarDay
||
嗨,我正在尝试将Sqldate与CalendarDay进行比较,如果日期匹配,我正在更改日历的bg颜色
private void Calendar1_DayRender(Object source, DayRenderEventArgs e)
{
CalendarDay de = null;
int i = 0, j = 0;
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[\"MYDB\"].ToString()))
{
conn.Open();
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(new SqlParameter(\"@Today\", SqlDbType.Date));
cmd.Parameters[\"@Today\"].Value = e.Day.Date.;
cmd.CommandText = \" Select Date from tour where date >= @Today\";
SqlDataReader sr = cmd.ExecuteReader();
de = (CalendarDay) sr.GetValue(0);
while (sr.NextResult())
{
if (e.Day.Equals(de))
{
e.Cell.BackColor = System.Drawing.Color.Yellow;
}
i++;
de = (CalendarDay)sr.GetValue(i);
}
sr.Close();
sr.Dispose();
}
conn.Close();
}
}
没有找到相关结果
已邀请:
1 个回复
赣借