Solved

ASP.net SQL and pivot tables

Posted on 2014-01-22
7
1,176 Views
Last Modified: 2014-01-27
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
Comment
Question by:Murray Brown
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 35

Expert Comment

by:YZlat
ID: 39802696
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
 

Author Comment

by:Murray Brown
ID: 39802711
The data is stored in a cloud SQL database. I use the  SQLClient with connectin strings to query this
0
 
LVL 35

Expert Comment

by:YZlat
ID: 39803707
What exactly you need? Do you want to re-write the SQL query?
0
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 

Author Comment

by:Murray Brown
ID: 39803759
I wanted any example in VB.net of pivoting data coming from SQL
0
 

Author Comment

by:Murray Brown
ID: 39805832
Hi YZLat. I have the data in a dataset, which comes from SQL. Is it possible to pivot a dataset?
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 500 total points
ID: 39806192
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
 

Author Closing Comment

by:Murray Brown
ID: 39811412
Thanks very much
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question