国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 學院 > 開發設計 > 正文

csharp: DataTable Rename ColumnName and remove Column

2019-11-17 02:16:46
字體:
來源:轉載
供稿:網友

csharp: DataTable Rename ColumnName and remove Column

  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);            }        }

  測試:

            DataTable dt = setData();            DataTable ds=new DataTable();            //店鋪代碼店鋪名稱姓名身份證號職位基本出勤時數計薪時數遲到早退            //1            List<int> primes = new List<int>(new int[] {0, 2, 3});            DataTableRemoveIndex(primes, dt);            //2.            //List<string> clmnames = new List<string>(new string[] { "店鋪代碼", "基本出勤時數", "職位" });            //foreach (string i in clmnames)            //{            //  DataTableRemoveColumn(i, dt);            //}            this.dataGridView1.DataSource = dt;

  


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 麻城市| 措勤县| 且末县| 平利县| 广昌县| 青海省| 江川县| 喜德县| 光山县| 镇康县| 达日县| 融水| 科尔| 德化县| 甘孜县| 静宁县| 大厂| 雷山县| 福清市| 崇文区| 华亭县| 庐江县| 新疆| 自贡市| 宁化县| 贵州省| 馆陶县| 苏尼特右旗| 肥乡县| 池州市| 凤山市| 墨玉县| 盐津县| 信阳市| 武汉市| 延边| 昭苏县| 镇巴县| 中超| 富阳市| 赤壁市|