How to Pivot a DataTable in .NET

How to Pivot a DataTable in .NET - Hallo sahabat Jendela Dunia Internet Dan Tekhnologi, Pada Artikel yang anda baca kali ini dengan judul How to Pivot a DataTable in .NET, kami telah mempersiapkan artikel ini dengan baik untuk anda baca dan ambil informasi didalamnya. mudah-mudahan isi postingan Artikel .NET, Artikel DataTable, Artikel PivotTable, Artikel VB.NET, yang kami tulis ini dapat anda pahami. baiklah, selamat membaca.

Judul : How to Pivot a DataTable in .NET
link : How to Pivot a DataTable in .NET

Baca juga


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