爱无罪吉他谱,sheqingwang,70周年阅兵式观后感
/// <summary>
/// datatable行转列
/// </summary>
/// <param name="dtable">需要转换的表</param>
/// <param name="head">转换表表头对应旧表字段(小写)</param>
/// <returns></returns>
public static datatable datatablerowtocon(datatable dtable, string head)
{
datatable dt = new datatable();
dt.columns.add("numberid");
for (int i = 0; i < dtable.rows.count; i++)
{//设置表头
dt.columns.add(dtable.rows[i][head].tostring());
}
for (int k = 0; k < dtable.columns.count; k++)
{
string temcol = dtable.columns[k].tostring();
if (dtable.columns[k].tostring().tolower() != head)//过滤掉设置表头的列
{
datarow new_dr = dt.newrow();
new_dr[0] = dtable.columns[k].tostring();
for (int j = 0; j < dtable.rows.count; j++)
{
string temp = dtable.rows[j][k].tostring();
new_dr[j + 1] = (object)temp;
}
dt.rows.add(new_dr);
}
}
return dt;
}
如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!!
点击进行留言回复
网友评论