PIVOT Table with ViewModel

Question

I am converting the Rows as Columns using PIVOT in SQL Server. Keeping the result set in a DataTable and binding the DataTable with a GridView. As I want to generate the Column Dynamically based on the Rows, I am using PIVOT operation. How do I proceed if i don't want to use DataTable and want to use a ViewModel in place of DataTable?

@Waqar, ViewModel is nothing but a view specific Model object. For example you can keep a DataSet or DataTable as a DataSource for a GridView in a View. Here you can replace DataTable or DataSet using Collection of ViewModel. — Rajkumar Vasan, Jul 14 '12 at 07:57

score 1 · Accepted Answer · edited May 23 '17 at 12:27

1

I've asked this question before but for winforms. I too had to pivot sql data. The answer was to make use of System.ComponentModel.

See top answer here: Data binding dynamic data

edited May 23 '17 at 12:27

Community

1
1

answered Jul 14 '12 at 08:19

Chris Moutray

18,029
7
45
66

1

Looks like I am not alone...Thanks..will accept the answer after going through the complete instructions. – Rajkumar Vasan Jul 14 '12 at 08:22

PIVOT Table with ViewModel

1 Answers1