转 xrll() :在DataTable中修改,重新建一个DataTable:
DataTable dn= new DataTable();
dn.Columns.Add("ColumnName", typeof(string));
for (int i=0; i < dt.Rows.Count; i++)
dn.Columns.Add("Column" + (i+1).ToString(), typeof(string));
foreach(DataColumn dc in dt.Columns)
{
DataRow dnr = dn.NewRow();
dnr["ColumnName"] = dc.ColumnName;
for (int i=0; i < dt.Rows.Count; i++)
{
dnr[i+1] = dt.Rows[i][dc].ToString();
}
dn.Rows.Add(dnr);
}
DataTable dn= new DataTable();
dn.Columns.Add("ColumnName", typeof(string));
for (int i=0; i < dt.Rows.Count; i++)
dn.Columns.Add("Column" + (i+1).ToString(), typeof(string));
foreach(DataColumn dc in dt.Columns)
{
DataRow dnr = dn.NewRow();
dnr["ColumnName"] = dc.ColumnName;
for (int i=0; i < dt.Rows.Count; i++)
{
dnr[i+1] = dt.Rows[i][dc].ToString();
}
dn.Rows.Add(dnr);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货