C#行列转换（交叉表）处理源代码

        /// <summary>
        /// 将DataTable的第二列的值转化为列（即将原来的行表，转化成交叉表，没有对应值则默认0）贾世义
        /// </summary>
        /// <param name="dt">必须三列，第三列为值</param>
        /// <returns></returns>
        public static DataTable GetCrossTable(DataTable dt)
        {
            if (dt == null || dt.Columns.Count != 3 || dt.Rows.Count == 0)
            {
                return dt;
            }
            else
            {
                DataTable result = new DataTable();
                result.Columns.Add(dt.Columns[0].ColumnName, dt.Columns[2].DataType);
                DataTable dtColumns = dt.DefaultView.ToTable("dtColumns", true, dt.Columns[1].ColumnName);
                foreach (DataRow drColumnsRow in dtColumns.Select("", dt.Columns[1