Transpose a DataTable in .Net

.Net by default does not provide a default method to Transpose a DataTable. Here's the Code Snippet to do the same.

Please Note:
"dataset" is the name of the dataset used in the below example. 

//To call the Transpose method
DataView transposedDataView = Transpose(dataset.Tables[0].Copy()).DefaultView;

/// <summary>
/// Transpose DataTable 
/// </summary>
// <param name="dt"></param>
/// <returns></returns>
private DataTable Transpose(DataTable dt)
    DataTable dtNew = new DataTable();
//adding columns for(int i=0; i<=dt.Rows.Count; i++) { dtNew.Columns.Add(i.ToString()); }

//Changing Column Captions:
dtNew.Columns[0].ColumnName = " "; for(int i=0; i<dt.Rows.Count; i++) {
      //For dateTime columns use like below dtNew.Columns[i+1].ColumnName = Convert.ToDateTime(dt.Rows[i].ItemArray[0].ToString()).ToString("MM/dd/yyyy");
      //Else just assign the ItermArry[0] to the columnName prooperty } //Adding Row Data for(int k=1; k<dt.Columns.Count; k++) { DataRow r = dtNew.NewRow(); r[0] = dt.Columns[k].ToString(); for(int j=1; j<=dt.Rows.Count; j++) r[j] = dt.Rows[j-1][k]; dtNew.Rows.Add(r); } return dtNew;
By [)ia6l0 iii   Popularity  (5991 Views)