DataTable dt1 = new DataTable();
for (int k = 0; k < 7 ; k++) //遍历dt前7列
{
dt1.Columns.Add("列"+k);//添加一列,想加几列再自己加
}
DataRow dr;
int j = 0;
while (j < dt.Rows.Count)
{
dr = dt1.NewRow();
for (int m = 0; m < 7; m++)// dt 的列
{
string str = dt.Rows[j][m].ToString();
dr["列" + m.ToString()] = dt.Rows[j][m].ToString();
}
dt1.Rows.Add(dr);//添加一行
j++;
}
dg.DataSource = dt1;
dg.DataBind();