asp.net 日历控件calendar 怎么把有安排的日程变红

Question

点击日期 可以为当天添加工作记录 点击日期 可以在下方gridview 上看到自己的工作记录 怎么把已经有工作记录的日期变成红色

Answer 1

您好，
我认为你可以创建一个datatable，检索数据库，将数据存储到datatable。然后在日历的render 事件中，渲染它的字体颜色。你可以尝试如下代码：

 protected DataSet GetCurrentMonthData(DateTime firstDate,DateTime lastDate)
    {
        DataSet dsMonth = new DataSet();
        ConnectionStringSettings cs;
        cs = ConfigurationManager.ConnectionStrings["qztvoaConnectionString"];
        String connString = cs.ConnectionString;
        SqlConnection dbConnection = new SqlConnection(connString);
        String query;
        query = "SELECT DISTINCT plandate FROM tplan WHERE plandate >= @firstDate AND plandate < @lastDate";
        SqlCommand dbCommand = new SqlCommand(query, dbConnection);
        dbCommand.Parameters.Add(new SqlParameter("@firstDate",firstDate));
        dbCommand.Parameters.Add(new SqlParameter("@lastDate", lastDate));
        SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(dbCommand);
        try
        {
            sqlDataAdapter.Fill(dsMonth);
        }
        catch {}
        return dsMonth;
    }
    protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
    {
        DateTime nextDate;
        if (ds!= null)
        {
            Label1.Text = ds.Tables.Count.ToString();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                nextDate = (DateTime)dr["plandate"];
                if (nextDate == e.Day.Date)
                {
                    e.Cell.BackColor = System.Drawing.Color.Red;
                }
            }
        }
    }