程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> .NET網頁編程 >> C# >> C#入門知識 >> csharp復制DataTable修改某列的值

csharp復制DataTable修改某列的值

編輯:C#入門知識

/// <summary>
      /// 塗聚文
      /// 2012-04-14
      /// </summary>
      /// <param name="table"></param>
      /// <returns></returns>
      static DataTable GetDecTable(DataTable table)
      {
          if (!object.Equals(table, null))//
          {
                   // foreach(DataRow myRow in thisTable.Rows){
                   //foreach(DataColumn myCol in thisTable.Columns){
                   //   Console.WriteLine(myRow[myCol]);
                   //}
 
              //DataTable tablecopy = table.Copy();
              DataTable tableDec=new DataTable();
              //tableDec = table.Copy();
              //得到列的名稱和數據類型
              //foreach (DataColumn column in table.Columns)
              //{
              //    tableDec.Columns.Add(column.ColumnName,column.DataType);
              //}
              //    foreach (DataColumn myCol in table.Columns)
              //    {
              //        if (myCol.ColumnName == "EmployeeNo")
              //        {
              //           // row[myCol]
              //        }
              //foreach (DataRow row in table.Rows) // Loop over the rows.
              //{
 
              //        //tableDec.Rows.Add(myRow[myCol])
              //    }
              //    string employeeNo = CryptographerUTF.GetDecryptString(row["EmployeeNo"].ToString());
              //    string employeeName = CryptographerUTF.GetDecryptString(row["EmployeeName"].ToString());
              //    tableDec.Rows.Add();
              //}
              
              //克隆表結構,數據記錄沒有填充
 
              //tableDec = table.Clone();
              
              //foreach (DataColumn gcol in datatable.Columns)
              //{
              //    if (gcol.ColumnName == "EmployeeNo")
              //    {
              //        //修改數據類型
 
              //        gcol.DataType = typeof(String);
              //    }
              //}
              //為新表填充數據
                  //foreach (DataRow row in tableDec.Rows)
                  //{
                  //    DataRow 個nr = datatable.NewRow();
                  //    nr["EmployeeName"] = row["EmployeeName"];
                  //    //修改記錄
 
                  //    nr["EmployeeNo"] = row["EmployeeNo"] .toString()";
 
                  //    nr["sex"] = row["sex"];
                  //    datatable.Rows.Add(nr);
                  //}
 
               //復制表結構和數據
               tableDec = table.Copy();
              //為改變指定列的數據
              foreach (DataRow row in tableDec.Rows)
              {
                  //修改記錄的值
 
                  row["EmployeeNo"] = CryptographerUTF.GetDecryptString(row["EmployeeNo"].ToString());
                  //修改記錄值
                  row["EmployeeName"] = CryptographerUTF.GetDecryptString(row["EmployeeName"].ToString());
 
              }
              
 
              return tableDec;
 
          }
          else
          {
              return null;
          }
      }
 

 

摘自 ®Geovin Du Dream Park™

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved