由于最近用ASP.NET做手机H5效果时,数据表字段太多,不适合打横显示,突发奇想让它打竖显示,就是第一列为字段名,第二列开始为数据
public static DataTable Col2Row(DataTable dt) { DataTable dtNew = new DataTable(); dtNew.Columns.Add("ColumnName", typeof(string)); for (int i = 0; i < dt.Rows.Count; i++) { dtNew.Columns.Add("Column" + (i + 1).ToString(), typeof(string)); } foreach (DataColumn dc in dt.Columns) { DataRow drNew = dtNew.NewRow(); drNew["ColumnName"] = dc.ColumnName; for (int i = 0; i < dt.Rows.Count; i++) { drNew[i + 1] = dt.Rows[i][dc].ToString(); } dtNew.Rows.Add(drNew); } return dtNew; }
发表评论: