csharp: DataTable Rename ColumnName and remove Column

最新推荐文章于 2022-03-01 11:45:27 发布

geovi

最新推荐文章于 2022-03-01 11:45:27 发布

阅读量1k

点赞数

分类专栏： .NET 文章标签： csharp c#

本文链接：https://blog.csdn.net/geovi/article/details/46821397

版权

.NET 专栏收录该内容

88 篇文章 0 订阅

订阅专栏

enum ChangeNume
      {
          /// <summary>
          /// 简体
          /// </summary>
          gbk=1,
          /// <summary>
          /// 英文
          /// </summary>
          en=2,
          /// <summary>
          /// 繁体
          /// </summary>
          big=3,
          ko=4,
          jp=5,
      }
 
      /// <summary>
      ///
      /// </summary>
      /// <returns></returns>
      DataTable setData()
      {
          DataTable dt = new DataTable();
          dt.Columns.Add("id", typeof(int));
          dt.Columns.Add("name", typeof(string));
          dt.Columns.Add("patner", typeof(int));
          dt.Columns.Add("time", typeof(DateTime));
          dt.Rows.Add(1, "dgeo", 0, "2015-01-02");
          dt.Rows.Add(2, "geovindu", 1, "2015-03-03");
          dt.Rows.Add(3, "gess", 1, "2015-03-23");
          dt.Rows.Add(4, "dfadfd", 2, "2015-04-03");
          return dt;
      }
      /// <summary>
      ///
      /// </summary>
      /// <param name="dv"></param>
      /// <param name="lname"></param>
      private DataTable setGridViewName(DataTable dv, ChangeNume lname)
      {
          DataTable dt = dv;
          switch (lname)
          {
              case ChangeNume.gbk:
                  dt.Columns[0].ColumnName = "序号";
                  dt.Columns[1].ColumnName = "名称";
                  dt.Columns[2].ColumnName = "父节点";
                  dt.Columns[3].ColumnName = "日期";
                  break;
              case ChangeNume.big:
                  dt.Columns[0].ColumnName = "序號";
                  dt.Columns[1].ColumnName = "名稱";
                  dt.Columns[2].ColumnName = "父節點";
                  dt.Columns[3].ColumnName = "日期";
                  break;
              case ChangeNume.en:
                  dt.Columns[0].ColumnName = "id";
                  dt.Columns[1].ColumnName = "name";
                  dt.Columns[2].ColumnName = "patner";
                  dt.Columns[3].ColumnName = "time";
                  break;
              default:
                  dt.Columns[0].ColumnName = "序号";
                  dt.Columns[1].ColumnName = "名称";
                  dt.Columns[2].ColumnName = "父节点";
                  dt.Columns[3].ColumnName = "日期";
                  break;
          }
          return dt;
      }
 
      /// <summary>
      ///
      /// </summary>
      public Form2()
      {
          InitializeComponent();
      }
      /// <summary>
      ///
      /// </summary>
      /// <param name="sender"></param>
      /// <param name="e"></param>
      private void Form2_Load(object sender, EventArgs e)
      {
          this.dataGridView1.DataSource = setGridViewName(setData(), ChangeNume.en);
 
      }
      /// <summary>
      ///
      /// </summary>
      /// <param name="sender"></param>
      /// <param name="e"></param>
      private void button1_Click(object sender, EventArgs e)
      {
          this.dataGridView2.DataSource = setGridViewName(setData(), ChangeNume.big);
      }

/// <summary>
     /// DataTable列名移除
      /// </summary>
      /// <param name="dcName"></param>
      /// <param name="datatable"></param>
      private void DataTableRemoveColumn(string dcName,DataTable datatable)
      {
         // List<string> clmnames = new List<string>(new string[] { "clm6", "clm7", "clm20" });
            DataColumnCollection dcCollection = datatable.Columns;
            if (dcCollection.Contains(dcName))
            {
                dcCollection.Remove(dcName);
            }
      }
     /// <summary>
      /// DataTable列索引移除
     /// </summary>
     /// <param name="index"></param>
     /// <param name="datatable"></param>
     private void DataTableRemoveIndex(List<int> index, DataTable datatable)
     {
         //List<int> index = new List<int>(new int[] { 2, 3, 5 });
         List<string> primes = new List<string>();
         foreach (int i in index)
         {
             primes.Add(datatable.Columns[i].ColumnName);
         }
 
         foreach (string iname in primes)
         {
             DataTableRemoveColumn(iname, datatable);
         }
 
     }