Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1277
  • Last Modified:

ASP.net SQL and pivot tables

Hi

I need to pivot data on my ASP.net web page pulled in via a VB.net data
bind to a cloud SQL database.
I just need a little advice on the best way to go about this.
My SQL query is in VB.net and not inside the SQL database
0
Murray Brown
Asked:
Murray Brown
  • 4
  • 2
1 Solution
 
YZlatCommented:
so where is the data stored? From which source will you be getting the data?

If it is stored in one of the .NET structures such as DataSet, you might not be able to pivot it
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
The data is stored in a cloud SQL database. I use the  SQLClient with connectin strings to query this
0
 
YZlatCommented:
What exactly you need? Do you want to re-write the SQL query?
0
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
I wanted any example in VB.net of pivoting data coming from SQL
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Hi YZLat. I have the data in a dataset, which comes from SQL. Is it possible to pivot a dataset?
0
 
CodeCruiserCommented:
Example here is in C# but should give you an idea of how pivoting is done on a datatable

http://www.codeproject.com/Articles/46486/Pivoting-DataTable-Simplified
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now