1 private void Bind()//数据绑定方法
 2     {
 3         int TotalPage = 0;
 4         PageBarManager p = new PageBarManager();
 5 
 6         dt = p.GetPageBarDate("WorkDaySet", "id", WebUserControl1.strFieldName, WebUserControl1.strFieldValue, 10, p.CurrentPage, ref TotalPage);//调用了分页存储过程
 7         DataTable dtnew = new DataTable();   //新建一个对象  
 8         if (dt != null && dt.Rows.Count > 0)
 9         {
10             DataColumn ID = new DataColumn("ID", typeof(int));  //设置各列类型
11             DataColumn Day = new DataColumn("day", typeof(DateTime));
12             DataColumn state = new DataColumn("state", typeof(string)); 
13             dtnew.Columns.Add(ID);  //向datatable中添加列
14             dtnew.Columns.Add(Day);
15             dtnew.Columns.Add(state);  
16             for (int i = 0; i < dt.Rows.Count; i++)   //遍历原数据向新datatable中赋值
17             {
18                 dtnew.Rows.Add(dt.Rows[i].ItemArray);  
19             }
20             foreach (DataRow dr in dtnew.Rows)  //对特定的行添加限制条件
21             {
22                 if (dr[2].ToString() =="0")
23                 {
24                     dr[2] = "工作日转非工作日";
25                 }
26                 else
27                 {
28                     dr[2] = "非工作日转工作日";
29                 }
30             }
31         }
32         rptCurrency.DataSource = dtnew;  //数据绑定  显示
33         rptCurrency.DataBind();
34         if (dt.Rows.Count == 0)
35             WebUserControl1.Visible = false;
36         WebUserControl1.lblPage = TotalPage.ToString();
37 
38     }