110,502
社区成员
发帖
与我相关
我的任务
分享
for(int i=0;i <DataTable1.Columns.count;i++ )
{
for(int j=0;j<DataTable1.Rows.count;j++)
{
if(j==0)
{
DataTable[i][j] = DataTable1.Columns[i].ColumnName;
}
else if(i==0)
{
DataTable.Columns[j].ColumnName = DataTable1[j][i];
}
else
{
DataTable[i][j] = DataTable1[j][i];
}
}
}
for(int i=0;i <DataTable1.Columns.count;i++ )
{
for(int j=0;j<DataTable1.Rows.count;j++)
{
if(j==0)
{
DataTable[i][j] = DataTable1.Columns[i].ColumnName;
}
DataTable[i][j] = DataTable1[j][i];
}
}
DataTable dt1 = new DataTable();
dt1.Columns.AddRange(new DataColumn[] { new DataColumn("ID"), new DataColumn("Name"), new DataColumn("Age"), new DataColumn("Mail") });
dt1.Rows.Add(1, "张三", 100, " zhangsan@qq.com");
dt1.Rows.Add(2, " test", 100, " teste2@qq.com ");
dt1.Rows.Add(3, "test1", 100, "test1@qq.com ");
DataTable dt2 = new DataTable();
dt2.Columns.Add(new DataColumn());
for (int i = 0; i < dt1.Rows.Count; i++)
{
dt2.Columns.Add(new DataColumn());
}
for (int i = 0; i < dt1.Columns.Count; i++)
{
DataRow row = dt2.NewRow();
row[0] = dt1.Columns[i].ColumnName;
for (int j = 1; j <= dt1.Rows.Count; j++)
{
row[j] = dt1.Rows[j - 1][i];
}
dt2.Rows.Add(row);
}