日历控件Calendar使用技巧－－根据数据库数据控制日期背景显示颜色

最新推荐文章于 2024-02-19 08:57:52 发布

angleoldhen

最新推荐文章于 2024-02-19 08:57:52 发布

阅读量6.1k

点赞数

分类专栏： asp.net 文章标签： calendar 日历数据库 dataset query object

本文链接：https://blog.youkuaiyun.com/angleoldhen/article/details/1916557

版权

asp.net 专栏收录该内容

30 篇文章

订阅专栏

本文介绍了一个使用ASP.NET实现的月计划数据加载和日历视图展示的例子。通过设定可见日期范围，从数据库中获取指定月份的数据，并在日历中突出显示有计划的日期。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

    protected DataSet ds;
    protected void Page_Load(object sender, EventArgs e)
    {
            Calendar1.VisibleDate = DateTime.Today;
            FillDataset();
    }
    protected void FillDataset()
    {
        DateTime firstDate = new DateTime(Calendar1.VisibleDate.Year,
            Calendar1.VisibleDate.Month, 1);
        DateTime lastDate = GetFirstDayOfNextMonth();
        ds = GetCurrentMonthData(firstDate, lastDate);
    }

    protected DateTime GetFirstDayOfNextMonth()
    {
        int monthNumber, yearNumber;
        if (Calendar1.VisibleDate.Month == 12)
        {
            monthNumber = 1;
            yearNumber = Calendar1.VisibleDate.Year + 1;
        }
        else
        {
            monthNumber = Calendar1.VisibleDate.Month + 1;
            yearNumber = Calendar1.VisibleDate.Year;
        }
        DateTime lastDate = new DateTime(yearNumber, monthNumber, 1);
        return lastDate;
    }

    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;
                }
            }
        }
    }