数据库的查询结果通常为每一行为单独的信息,有时需要以某一列为基准(姓名),将某一列(科目)转换成行
/// <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