using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
namespace SSCMS.CommonClass
{
public class DataTableHelper
{
/// <summary>
/// DataTable 行列转置
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static DataTable TransposeDt(DataTable dt)
{
DataTable dtNew = new DataTable();
dtNew.Columns.Add("ColumnName", typeof(string));
for (int i = 0; i < dt.Rows.Count; i++)
{
dtNew.Columns.Add("Column" + (i + 1).ToString(), typeof(string));
}
foreach (DataColumn dc in dt.Columns)
{
DataRow drNew = dtNew.NewRow();
drNew["ColumnName"] = dc.ColumnName;
for (int i = 0; i < dt.Rows.Count; i++)
{
drNew[i + 1] = dt.Rows[i][dc].ToString();
}
dtNew.Rows.Add(drNew);
}
return dtNew;
}
}
}