回写DataSet的例子

 1         public void Bind(DataGrid dataGridName, string t, string submit, string create, string username)
 2         {
 3             try
 4             {
 5                 //数据层对数据库操作的公共类中的绑定方法
 6                 DAL.Charts.TradeCreateOrder TCO = new DAL.Charts.TradeCreateOrder();
 7                 dataGridName.DataSource = TCO.Bind(t, submit, create, username);
 8                 dataGridName.DataBind();
 9 
10                 //遍历DataGrid的每一行
11                 for (int i = 0; i < dataGridName.Items.Count; i++)
12                 {
13                     int ii = i + 1;
14                     //定义当前DataGrid的一个视图,用来修改视图内容
15                     DataRowView mydrv;
16                     //取得遍历到当前行的视图
17                     mydrv = TCO.Bind(t, submit, create, username).Tables[0].DefaultView[i];
18 
19                     //取得数据表中的字段,用来进行判断
20                     string gIntro1 = Convert.ToString(mydrv["TMPROVIDE"]);
21                     string gIntro2 = Convert.ToString(mydrv["TMBUY"]);
22                     string gIntro3 = Convert.ToString(mydrv["TMPRODUCT"]);
23                     string gIntro4 = Convert.ToString(mydrv["TMENTERPRISE"]);
24                     string gIntro5 = Convert.ToString(mydrv["TMINFO"]);
25                     string gIntro6 = Convert.ToString(mydrv["TMTRADE"]);
26 
27                     string gIntro11 = Convert.ToString(mydrv["TMPROVIDEDATE"]);
28                     string gIntro22 = Convert.ToString(mydrv["TMBUYDATE"]);
29                     string gIntro33 = Convert.ToString(mydrv["TMPRODUCTDATE"]);
30                     string gIntro44 = Convert.ToString(mydrv["TMENTERPRISEDATE"]);
31                     string gIntro55 = Convert.ToString(mydrv["TMINFODATE"]);
32                     string gIntro66 = Convert.ToString(mydrv["TMCREATE"]);
33                     //根据Judge方法进行信息是否提交判断,然后重新排写模板列中的内容
34                     dataGridName.Items[i].Cells[3].Text = this.Judge(gIntro6, gIntro11, gIntro22, gIntro33, gIntro44, gIntro55);
35 
36 
37                     if (gIntro66 == "未生成")
38                     {
39                         dataGridName.Items[i].Cells[4].Text = "<font color='red'>尚未生成</font>";
40                     }
41                     else
42                     {
43                         dataGridName.Items[i].Cells[4].Text = "已经生成";
44                     }
45                     dataGridName.Items[i].Cells[1].Text = ii.ToString();
46                 }
47             }
48             catch(Exception ex)
49             {
50                 HttpContext.Current.Response.Write(ex.Message);
51                 HttpContext.Current.Response.End();
52             }