/// <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
/// 将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