DataTable实现行转换列

    数据库的查询结果通常为每一行为单独的信息，有时需要以某一列为基准（姓名），将某一列（科目）转换成行

         /// <summary>

        ///
        /// </summary>
        /// <param name="sourceTable">数据源</param>
        /// <param name="indexColumn">主键列</param>
        /// <param name="crossColumn">转换列</param>
        /// <param name="valueColumn">数值列</param>
        /// <param name="sortStr"></param>
        /// <returns></returns>
        public DataTable GetCrossTable(DataTable sourceTable, int indexColumn, int crossColumn, int valueColumn, string sortStr, string defaultValue)
        {
            if (sourceTable == null || sourceTable.Rows.Count == 0)
            {
                return sourceTable;
            }
            else
            {
                DataTable resultTable = G