datatable
来源:互联网 发布:20岁的眼泪 知乎 编辑:程序博客网 时间:2024/05/16 23:46
public static DataTable Col2Row(DataTable src, int columnHead)
{
//存放更改后的datatable
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;
}
{
//存放更改后的datatable
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;
}
0 0
- DataTable
- DataTable
- DataTable
- DataTable
- datatable
- DataTable
- DataTable
- DataTable
- DataTable
- datatable???
- DataTable
- dataTable
- DataTable
- datatable
- dataTable
- datatable
- DataTable
- DataTable
- RHEL7破解root密码
- HDU_1017_AMathematicalCuriosity
- leetcode-190-Reverse Bits
- 转吧总结,一些零零碎碎的东西
- python encode和decode函数说明
- datatable
- leetcode--Maximum Depth of Binary Tree
- 手机APP自动化持续集成方案
- java trim
- netfilter 讲解 ,讲的很好
- 在预装Win8 (UEFI)的ThinkPad上加装ArchLinux系统
- Python学习之条件语句
- JNI入门教程
- 如何在mac本上安装android sdk