01.protected void Page_Load(object sender, EventArgs e)
02.{
03. SqlDatabaseManager SqlDatabaseManager1 = new SqlDatabaseManager();
04. SqlDatabaseManager1.CommandString = "Select [HolidayTable].[HolidayID], [DayTable].[DayName], [HolidayTable].[Holiday], [HolidayTable].[HolidayThaiDetail], [HolidayTable].[HolidayDetail] From [HolidayTable] Inner Join [DayTable] On ([HolidayTable].[DayID] = [DayTable].[DayID])";
05.
06. DataTable Dt = new DataTable();
07. Dt = SqlDatabaseManager1.ExecuteQuery();
08.
09. GridView1.DataSource = Dt;
10. GridView1.RowDataBound += new GridViewRowEventHandler(GridView1_RowDataBound);
11. GridView1.DataBind();
12.
13. Label1.Text = SqlDatabaseManager1.Message;
14.}
15.
16.protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
17.{
18. if (e.Row.RowType == DataControlRowType.DataRow)
19. {
20. if (e.Row.Cells[0].Text == "8")
21. {
22. e.Row.BackColor = System.Drawing.Color.FromName("#E9E9E9");
23. e.Row.ForeColor = System.Drawing.Color.Red;
24. }
25. }
26.}
