การเปรียบเทียบเวลาและลงสีที่แถวใน Gridview คือว่า select ข้อมูลออกมาใน Gridview แบบเป็นวันที่แล้ว

    protected void Page_Load(object sender, EventArgs e)
    {
        SqlDatabaseManager SqlDatabaseManager1 = new SqlDatabaseManager();
        SqlDatabaseManager1.CommandString = "Select [HolidayTable].[HolidayID], [DayTable].[DayName], [HolidayTable].[Holiday], [HolidayTable].[HolidayThaiDetail], [HolidayTable].[HolidayDetail] From [HolidayTable] Inner Join [DayTable] On ([HolidayTable].[DayID] = [DayTable].[DayID])";

        DataTable Dt = new DataTable();
        Dt = SqlDatabaseManager1.ExecuteQuery();

        GridView1.DataSource = Dt;
        GridView1.RowDataBound += new GridViewRowEventHandler(GridView1_RowDataBound);
        GridView1.DataBind();

        Label1.Text = SqlDatabaseManager1.Message;
    }

    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if (e.Row.Cells[0].Text == "8")
            {
                e.Row.BackColor = System.Drawing.Color.FromName("#E9E9E9");
                e.Row.ForeColor = System.Drawing.Color.Red;
            }
        }
    }