在RowDataBound中改变或设置Header和Footer

1. protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) 
2.     { 
3.         if (e.Row.RowType == DataControlRowType.Footer) 
4.         { 
5.             e.Row.Cells[0].Text = "21"; 
6.             e.Row.Cells[1].Text = "All"; 
7.             e.Row.Cells[2].Text = "Total Dealers Status"; 
8.             //e.Row.Cells[4].Text = Convert.ToInt32(HidCount.Value).ToString("###,###"); 
9.             //e.Row.Cells[6].Text = Convert.ToDouble(HidSoldPrice.Value).ToString("C"); 
10.             e.Row.Cells[2].HorizontalAlign = HorizontalAlign.Right; 
11.            //e.Row.Cells[4].HorizontalAlign = HorizontalAlign.Right; 
12.             //e.Row.Cells[6].HorizontalAlign = HorizontalAlign.Right; 
13.  
14.             //e.Row.Cells[7].Text = DateTime.Now.ToString("yyyy-MM-dd"); 
15.             //e.Row.Cells[8].Text = DateTime.Now.ToString(@"HH:mm:ss G/MT zzz"); 
16.         } 
17.         if (e.Row.RowType == DataControlRowType.DataRow) 
18.         { 
19.              
20.             e.Row.Cells[3].Attributes.Add("style", "vnd.ms-excel.numberformat: @"); 
21.             //e.Row.Cells[4].Attributes.Add("style", "vnd.ms-excel.numberformat: @"); 
22.              
23.         } 
24.         if (e.Row.RowType == DataControlRowType.Header) 
25.         { 
26.  
27.             
28.             GridViewRow row = new GridViewRow(-1, -1, DataControlRowType.Header, 
30. DataControlRowState.Normal); 
31.              
32.             TableCell cell1 = new TableCell(); 
33.             cell1.Text = "<b>Report:</b>"; 
34.             row.Cells.AddAt(0, cell1); 
35.  
36.             TableCell cell2 = new TableCell(); 
37.             cell2.Text = "New Loans By Deal"; 
38.             row.Cells.AddAt(1, cell2); 
39.  
40.             TableCell cell3 = new TableCell(); 
41.             cell3.Attributes["align"] = "right"; 
42.             cell3.Text = "<font style=/"text-align:right; font-
44. weight:bold;/">Date/Time:</font>"; 
45.             row.Cells.AddAt(2, cell3); 
46.  
47.  
48.  
49.             //TableCell cell4 = new TableCell(); 
50.             //cell4.Text = DateTime.Now.ToString("yyyy-MM-dd") + " " + 
52. DateTime.Now.ToString(@"HH:mm:ss"); 
53.             //row.Cells.AddAt(3, cell4); 
54.             
55.  
56.             GridView1.Controls[0].Controls.AddAt(0, row); 
57.         } 
58.     } 
59. }