asp.net日历控件自定义单元格内容

    protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
    {
        //首先隐藏掉默认的日显示字符
        e.Cell.Controls[0].Visible = false;
        string dt = Server.UrlEncode(e.Day.Date.ToString());

        string qq = e.Day.Date.ToString("yyyyMMdd");
        string sql = string.Format("select * from ExOrganizers where CONVERT(varchar(100), ExStartData, 112)=" + qq);
        DataSet ds = SqlHelper.ExecuteDataset(connstr, CommandType.Text, sql);
        if (ds.Tables[0].Rows.Count > 0)
        {
            //自定义一个日显示格式，如果是一个月的第一天就加上月份，否则只显示日
            HyperLink hlevent_add = new HyperLink();
            if (e.Day.Date.Day == 1)
            {
                hlevent_add.Text = e.Day.Date.Month.ToString() + "月" + e.Day.Date.Day.ToString() + "<br>";
                hlevent_add.NavigateUrl = "Default11.aspx?select_date=" + dt;
                hlevent_add.Target = "_blank";
            }
            else
            {
                hlevent_add.Text = e.Day.Date.Day.ToString() + "<br>";
                hlevent_add.NavigateUrl = "Default11.aspx?select_date=" + dt;
                hlevent_add.Target = "_blank";
            }
            e.Cell.Controls.Add(hlevent_add);

        }
        else
        {
            //自定义一个日显示格式，如果是一个月的第一天就加上月份，否则只显示日
            HyperLink hlevent_add = new HyperLink();
            if (e.Day.Date.Day == 1)
            {
                hlevent_add.Text = e.Day.Date.Month.ToString() + "月" + e.Day.Date.Day.ToString() + "<br>";
            }
            else
            {
                hlevent_add.Text = e.Day.Date.Day.ToString() + "<br>";
            }
            e.Cell.Controls.Add(hlevent_add);

        }

        string sqll = string.Format("select * from ExOrganizers where CONVERT(varchar(100), ExStartData, 112)=" + e.Day.Date.ToString("yyyyMMdd"));
        DataSet dss = SqlHelper.ExecuteDataset(connstr, CommandType.Text, sqll);
        int a = dss.Tables[0].Rows.Count;
        this.Label1.Text = System.DateTime.Now.ToString() + "共有" + a + "个展会";

    }