国产探花免费观看_亚洲丰满少妇自慰呻吟_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;

  


發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 扎鲁特旗| 安龙县| 象山县| 剑阁县| 山西省| 郸城县| 天镇县| 鹿邑县| 云龙县| 讷河市| 班玛县| 隆化县| 陈巴尔虎旗| 灵武市| 乌兰浩特市| 延寿县| 大悟县| 阆中市| 宁强县| 阳西县| 西平县| 油尖旺区| 鲁甸县| 永胜县| 蓝田县| 肥西县| 东光县| 瓦房店市| 涞水县| 上高县| 老河口市| 印江| 革吉县| 威宁| 邛崃市| 西充县| 阿合奇县| 女性| 衡阳市| 丹寨县| 库尔勒市|