Judul : How to Pivot a DataTable in .NET
link : How to Pivot a DataTable in .NET
How to Pivot a DataTable in .NET
So I would have thought this problem would have already been solved by the Internets at large. As it turns out, I couldn’t find a very simple method to solve this relatively simple task. So here’s my attempt
Here’s a dead simple pivot table.
Let’s say I have a table that looks like this:
Person | Age | Sport |
---|---|---|
Susan | 22 | Tennis |
Bob | 29 | Soccer |
Terry | 16 | Basketball |
And I want to pivot it to to look like this:
Person | Susan | Bob | Terry |
---|---|---|---|
Age | 22 | 29 | 16 |
Sport | Tennis | Soccer | Basketball |
Here’s How
Private Function PivotTable(oldTable As DataTable,
Optional pivotColumnOrdinal As Integer = 0
) As DataTable
Dim newTable As New DataTable
Dim dr As DataRow
' add pivot column name
newTable.Columns.Add(oldTable.Columns(pivotColumnOrdinal).ColumnName)
' add pivot column values in each row as column headers to new Table
For Each row In oldTable.Rows
newTable.Columns.Add(row(pivotColumnOrdinal))
Next
' loop through columns
For col = 0 To oldTable.Columns.Count - 1
'pivot column doen't get it's own row (it is already a header)
If col = pivotColumnOrdinal Then Continue For
' each column becomes a new row
dr = newTable.NewRow()
' add the Column Name in the first Column
dr(0) = oldTable.Columns(col).ColumnName
' add data from every row to the pivoted row
For row = 0 To oldTable.Rows.Count - 1
dr(row + 1) = oldTable.Rows(row)(col)
Next
'add the DataRow to the new table
newTable.Rows.Add(dr)
Next
Return newTable
End Function
Then just call like this:
Dim newTable = PivotTable(oldTable, 0)
And that’s that.
Demikianlah Artikel How to Pivot a DataTable in .NET
Sekianlah artikel How to Pivot a DataTable in .NET kali ini, mudah-mudahan bisa memberi manfaat untuk anda semua. baiklah, sampai jumpa di postingan artikel lainnya.
Anda sekarang membaca artikel How to Pivot a DataTable in .NET dengan alamat link https://jendeladuniainternet.blogspot.com/2014/06/how-to-pivot-datatable-in-net.html
0 Response to "How to Pivot a DataTable in .NET"
Posting Komentar