<div>
so where is the data stored? From which source will you be getting the data?<br />
<br />
If it is stored in one of the .NET structures such as DataSet, you might not be able to pivot it
</div>


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

<div>
The data is stored in a cloud SQL database. I use the &nbsp;SQLClient with connectin strings to query this
</div>


The data is stored in a cloud SQL database. I use the  SQLClient with connectin strings to query this

<div>
What exactly you need? Do you want to re-write the SQL query?
</div>


What exactly you need? Do you want to re-write the SQL query?

<div>
I wanted any example in VB.net of pivoting data coming from SQL
</div>


I wanted any example in VB.net of pivoting data coming from SQL

<div>
Hi YZLat. I have the data in a dataset, which comes from SQL. Is it possible to pivot a dataset?
</div>


Hi YZLat. I have the data in a dataset, which comes from SQL. Is it possible to pivot a dataset?

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I need to pivot data on my ASP.net web page pulled in via a VB.net data<br />
bind to a cloud SQL database.<br />
I just need a little advice on the best way to go about this.<br />
My SQL query is in VB.net and not inside the SQL database
</div>
</div>


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

ASP.net SQL and pivot tables

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.