C#中DataTable完成行列轉換的辦法。本站提示廣大學習愛好者:(C#中DataTable完成行列轉換的辦法)文章只能為提供參考,不一定能成為您想要的結果。以下是C#中DataTable完成行列轉換的辦法正文
本文實例講述了C#中DataTable完成行列轉換的辦法。分享給年夜家供年夜家參考。詳細完成辦法以下:
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DataTable tt = GetCrossTable(CreateDT()); GridView1.DataSource = tt; GridView1.DataBind(); } } //創立DataTable protected DataTable CreateDT() { DataTable tblDatas = new DataTable("Datas"); //數據列 tblDatas.Columns.Add("姓名", Type.GetType("System.String")); tblDatas.Columns.Add("科目", Type.GetType("System.String")); tblDatas.Columns.Add("分數", Type.GetType("System.Int32")); tblDatas.Rows.Add(new object[] { "張三", "語文", 89 }); tblDatas.Rows.Add(new object[] { "張三", "數學", 90 }); tblDatas.Rows.Add(new object[] { "張三", "英語", 79 }); tblDatas.Rows.Add(new object[] { "張三", "地輿", 70 }); tblDatas.Rows.Add(new object[] { "張三", "生物", 95 }); tblDatas.Rows.Add(new object[] { "李四", "語文", 87 }); tblDatas.Rows.Add(new object[] { "李四", "英語", 86 }); tblDatas.Rows.Add(new object[] { "李四", "地輿", 82 }); tblDatas.Rows.Add(new object[] { "王五", "語文", 81 }); tblDatas.Rows.Add(new object[] { "王五", "數學", 70 }); tblDatas.Rows.Add(new object[] { "王五", "英語", 88 }); tblDatas.Rows.Add(new object[] { "王五", "生物", 96 }); return tblDatas; } /// <summary> /// 將DataTable的第二列的值轉化為列 //(行將本來的行表,轉化成穿插表,沒有對應值則默許"0") /// </summary> /// <param name="dt">必需三列,第三列為值</param> /// <returns></returns> public static DataTable GetCrossTable(DataTable dt) { if (dt == null || dt.Columns.Count != 3 || dt.Rows.Count == 0) { return dt; } else { DataTable result = new DataTable(); result.Columns.Add(dt.Columns[0].ColumnName); DataTable dtColumns = dt.DefaultView.ToTable("dtColumns", true, dt.Columns[1].ColumnName); for (int i = 0; i < dtColumns.Rows.Count; i++) { string colName; if (dtColumns.Rows[1][0] is DateTime) { colName = Convert.ToDateTime(dtColumns.Rows[i][0]).ToString(); } else { colName = dtColumns.Rows[i][0].ToString(); } result.Columns.Add(colName); result.Columns[i + 1].DefaultValue = "0"; } DataRow drNew = result.NewRow(); drNew[0] = dt.Rows[0][0]; string rowName = drNew[0].ToString(); foreach (DataRow dr in dt.Rows) { string colName = dr[1].ToString(); double dValue = Convert.ToDouble(dr[2]); if (dr[0].ToString().Equals(rowName, StringComparison.CurrentCultureIgnoreCase)) { drNew[colName] = dValue.ToString(); } else { result.Rows.Add(drNew); drNew = result.NewRow(); drNew[0] = dr[0]; rowName = drNew[0].ToString(); drNew[colName] = dValue.ToString(); } } result.Rows.Add(drNew); return result; } }
願望本文所述對年夜家的C#法式設計有所贊助。