sharepoint Datatable 行列转换

来源:互联网 发布:杭州淘宝客服培训班 编辑:程序博客网 时间:2024/06/05 19:45
/// <summary>        /// 将DataTable行列转换        /// </summary>        /// <param name="src">要转换的DataTable</param>        /// <param name="columnHead">要作为Column的哪列</param>        /// <returns></returns>        public static DataTable Col2Row(DataTable src, int columnHead)        {            DataTable result = new DataTable();            DataColumn myHead = src.Columns[columnHead];            result.Columns.Add(myHead.ColumnName);            for (int i = 0; i < src.Rows.Count; i++)            {                result.Columns.Add(src.Rows[i][myHead].ToString());            }            //            foreach (DataColumn col in src.Columns)            {                if (col == myHead)                    continue;                object[] newRow = new object[src.Rows.Count + 1];                newRow[0] = col.ColumnName;                for (int i = 0; i < src.Rows.Count; i++)                {                    newRow[i + 1] = src.Rows[i][col];                }                result.Rows.Add(newRow);            }            return result;        }        public static DataTable Col2Row(DataTable src, string columnHead)        {            for (int i = 0; i < src.Columns.Count; i++)            {                if (src.Columns[i].ColumnName.ToUpper () == columnHead.ToUpper())                    return Col2Row(src, i);            }            return new DataTable();        }
手写:群 212099235
原创粉丝点击