对于用sql查询出来的数据,有时候列很少,行很多(相比列),看起来不美观。需要进行行列转换。但是使用sql进行的话是比较麻烦的,使用DataTable来进行转换相对容易很多。
这里给出一个代码段。代码简单。
![](https://i-blog.csdnimg.cn/blog_migrate/8f900a89c6347c561fdf2122f13be562.gif)
![](https://i-blog.csdnimg.cn/blog_migrate/961ddebeb323a10fe0623af514929fc1.gif)
///
<summary>
/// 将DataTable行列转换
/// </summary>
/// <param name="src"> 要转换的DataTable </param>
/// <param name="columnHead"> 要作为Column的哪列 </param>
/// <returns></returns>
public static DataTable Col2Row(DataTable src, int columnHead)
{
DataTable result = new DataTable();
DataColumn myHead = src.Columns[columnHead];
result.Columns.Add(myHead.ColumnName);
for ( int i = 0 ; i < src.Rows.Count; i ++ )
{
result.Columns.Add(src.Rows[i][myHead].ToString());
}
//
foreach (DataColumn col in src.Columns)
{
if (col == myHead)
continue ;
object [] newRow = new object [src.Rows.Count + 1 ];
newRow[ 0 ] = col.ColumnName;
for ( int i = 0 ; i < src.Rows.Count; i ++ )
{
newRow[i + 1 ] = src.Rows[i][col];
}
result.Rows.Add(newRow);
}
return result;
}
public static DataTable Col2Row(DataTable src, string columnHead)
{
for ( int i = 0 ; i < src.Columns.Count; i ++ )
{
if (src.Columns[i].ColumnName.ToUpper () == columnHead.ToUpper())
return Col2Row(src, i);
}
return new DataTable();
}
/// 将DataTable行列转换
/// </summary>
/// <param name="src"> 要转换的DataTable </param>
/// <param name="columnHead"> 要作为Column的哪列 </param>
/// <returns></returns>
public static DataTable Col2Row(DataTable src, int columnHead)
{
DataTable result = new DataTable();
DataColumn myHead = src.Columns[columnHead];
result.Columns.Add(myHead.ColumnName);
for ( int i = 0 ; i < src.Rows.Count; i ++ )
{
result.Columns.Add(src.Rows[i][myHead].ToString());
}
//
foreach (DataColumn col in src.Columns)
{
if (col == myHead)
continue ;
object [] newRow = new object [src.Rows.Count + 1 ];
newRow[ 0 ] = col.ColumnName;
for ( int i = 0 ; i < src.Rows.Count; i ++ )
{
newRow[i + 1 ] = src.Rows[i][col];
}
result.Rows.Add(newRow);
}
return result;
}
public static DataTable Col2Row(DataTable src, string columnHead)
{
for ( int i = 0 ; i < src.Columns.Count; i ++ )
{
if (src.Columns[i].ColumnName.ToUpper () == columnHead.ToUpper())
return Col2Row(src, i);
}
return new DataTable();
}