Blogs

This Blog

News

DevExpress

Email Subscriptions

Mehul Harry's DevExpress Blog

> All Tags

ASPxPivotGrid 101: How To Get Started With A Pivot Grid For ASP.NET

      

Check out this 10 minute video that introduces you to the ASPxPivotGrid control. You’ll learn:

  • The basics of how a pivot table works
  • What a pivot grid looks like
  • How to use the ASPxPivotGrid in an ASP.NET website
  • Runtime features of the ASPxPivotGrid

What can the ASPxPivotGrid do for you? Suppose you’ve created a table or view in your database that represents some meaningful data about your product downloads. Using the ASPxPivotGrid, you can extract useful information from the data and find answers to such questions as:

  • What product has the highest download?
  • Which month has the highest downloads?

The ASPxPivotGrid is an interactive grid that takes your data and automatically extracts, organizes, and summarizes it. You can use the ASPxPivotGrid to analyze, compare, find patterns and relationships, and discover trends from the data.

Click the image below to watch the introduction to the pivot grids video:

image

Published Sep 18 2008, 04:11 PM by Mehul Harry (DevExpress)
Filed under: , , , , , , , , , ,
Technorati tags: Features, screencast, Video, How-To, Tutorial, ASP.NET, Pivot, Summaries, Pivot Table, CrossTab, ASPxPivotGrid
Bookmark and Share

Comments

 

Jason Dreikorn said:

My system locks up every time that I try to watch this video.  Is there anything that you can do in order to allow me to view the vidoe?  Can you zip it so that I could download a smaller file?

Thanks-Jay

October 6, 2008 4:27 PM
 

Mehul Harry (DevExpress) said:

Hi Jason,

The videos use Adobe Flash and I recommend upgrading to the latest version. You can also download the videos:

Look for the "Download movie" links on the tv site.

October 6, 2008 4:45 PM
 

orly said:

i try to get data from oracle db and if i use SqlDataSource i have problam with oracle type = CURSOR , i try to use oracle reader but the DataSourceID property of 'ASPxPivotGrid1' must refer to an existing control and  there is no control with the specified ID: 'reader'.

May 25, 2009 5:15 AM
 

Mehul Harry (DevExpress) said:

Hello Orly,

Creating the OracleDataReader object called "reader" is correct. Unfortunately, OracleDataReader isn't a control that can be placed on a web page so that the ASPxPivotGrid can find it. Instead, create a DataTable object and fill it with the reader. For example:

DataTable table = new DataTable();

table.Load(reader);

ASPxPivotGrid1.DataSource = table.DefaultView;

This will fill the ASPxPivotGrid with a data returned from the Oracle server. The DataSourceID property should be empty.

If this doesn't help then please open an issue in the support center and post the page code there. The support team will find help you.

May 26, 2009 4:49 PM
 

Victor Hernandez_1 said:

Hi Mehul

I try to use a SqlDataReader, loading the ASPxGridView from code, but I have two problems:

1) the filters columns are empty

2) after making some change, like page change, I lost all the data

did I missing something?

October 13, 2009 12:56 PM

About Mehul Harry (DevExpress)

Mehul Harry is an ASP.NET technical evangelist at Developer Express. You can reach him directly at mharry@DevExpress.com. You can also follow him on Twitter: http://twitter.com/mehulharry
More from DevExpress
DevExpress
About Us
Awards
Community Events
User Comments
Careers
Licensing
Contact Information		Press
DevExpress News
Logos
Reviews and Publications
Case Studies
DevExpress on Facebook
DevExpress on Twitter		Support
Knowledge Base
Ask a Question
Report an Issue
Online Documentation
Download Documentation
Technical Blogs		Training
Online Demos
Webinars
Videos
Courses
Partners
DXSquad
MVP Program
Community Group Support		Version History
What's New
Current Version/Build
Version History
Live Chat
Have a pre-sales question?
Need assistance with your evaluation?
We are here to help.
Chat is one of the many ways you can contact members of the DevExpress Team. We are available Monday-Friday between 8:30am and 5:00pm Pacific Time.
If you need additional product information, require pre-sales assistance, or want help with your order, write to us at info@devexpress.com or call us at
+1 (818) 844-3383.
DevExpress engineers feature-complete Presentation Controls, IDE Productivity Tools, Business Application Frameworks, and Reporting Systems for Visual Studio. Whether using WPF, Silverlight, ASP.NET or WinForms, DevExpress tools help you build and deliver your best in the shortest time possible.
Your Privacy - Legal Statements
Copyright © 1998-2012 Developer Express Inc.
ALL RIGHTS RESERVED
All trademarks or registered trademarks
are property of their respective owners