Csharp 两个DataTable或DataView互换,可以用来加密解密

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
  /// <summary>
  /// 涂聚文 geovindu.blog.163.com
  /// www.dusystem.com  www.dupcit.com
 /// 2011-05-28
/// </summary>
  /// <param name="table"></param>
  /// <returns></returns>
  static DataTable GetDecTable(DataTable table)
  {
      if (!object.Equals(table, null))//
      {
          DataTable tableDec = new DataTable();
          tableDec.Columns.Add("序号", typeof(string));
          tableDec.Columns.Add("员工编号", typeof(string));
          tableDec.Columns.Add("姓名", typeof(string));
          tableDec.Columns.Add("身份证号", typeof(string));
          tableDec.Columns.Add("入职时间", typeof(DateTime));
          foreach (DataRow row in table.Rows) // Loop over the rows.
          {
              tableDec.Rows.Add(row["序号"].ToString(), row["员工编号"].ToString(),  row["姓名"].ToString(),  row["身份证号"].ToString(), row["入职时间"].ToString());
 
          }
          return tableDec;
      }
      else
      {
          return null;
      }
  }
  /// <summary>
  /// 涂聚文 締友計算機信息技術有限公司,捷為工作室,geovindu.blog.163.com
  /// www.dusystem.com  www.dupcit.com
 /// 2011-05-28
/// </summary>
  /// <param name="view"></param>
  /// <returns></returns>
  static DataView getDecView(DataView view)
  {
       
      if (!object.Equals(view, null))
      {
           
          DataTable tableDec = new DataTable();
          tableDec.Columns.Add("序号", typeof(string));
          tableDec.Columns.Add("员工编号", typeof(string));
          tableDec.Columns.Add("姓名", typeof(string));
          tableDec.Columns.Add("身份证号", typeof(string));
          tableDec.Columns.Add("入职时间", typeof(DateTime));
          DataView dv = new DataView(tableDec);
          //DataSet dset = new DataSet();
          //dset = hr.HrestDataSet();
          dv.AllowNew = true;
           
          //rowView["ProductName"] = "New Product Name";
          //dv.AddNew();
          //foreach (DataRow theRow in thisDataSet.Tables["Employee"].Rows)
          //{
          //    Console.WriteLine(theRow["ID"] + "\t" + theRow["FirstName"]);
          //}
 
          //DataView view = new DataView(ds.Tables[0]);
          foreach (DataRowView drv in view)
          {
              DataRowView rowView = dv.AddNew();
              rowView["序号"] = drv["序号"].ToString();
              rowView["员工编号"] =drv["员工编号"].ToString();
              rowView["姓名"] = drv["姓名"].ToString;
              rowView["身份证号"] = drv["身份证号"].ToString();
              rowView["入职时间"] = drv["入职时间"].ToString();
          }
 
          //// find the record for Rick
          //view.RowFilter = "Name = 'Evy'";
          //foreach (DataRowView drv in view)
          //{
          //    Console.WriteLine(drv["Name"].ToString());
          //}
          return dv;
      }
      else
      {
          return null;
      }
  }
posted @   ®Geovin Du Dream Park™  阅读(963)  评论(0编辑  收藏  举报
编辑推荐:
· AI与.NET技术实操系列:基于图像分类模型对图像进行分类
· go语言实现终端里的倒计时
· 如何编写易于单元测试的代码
· 10年+ .NET Coder 心语,封装的思维:从隐藏、稳定开始理解其本质意义
· .NET Core 中如何实现缓存的预热?
阅读排行:
· 25岁的心里话
· 闲置电脑爆改个人服务器(超详细) #公网映射 #Vmware虚拟网络编辑器
· 基于 Docker 搭建 FRP 内网穿透开源项目(很简单哒)
· 零经验选手,Compose 一天开发一款小游戏!
· 一起来玩mcp_server_sqlite,让AI帮你做增删改查!!
< 2011年5月 >
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31 1 2 3 4
5 6 7 8 9 10 11
点击右上角即可分享
微信分享提示