book

Professional DevExpress™ ASP.NET Controls

Name: Professional DevExpress™ ASP.NET Controls
ISBN: 9780470500835

by Paul Kimmel, Julian Bucknall, Joe Kunk

November 2009

Intermediate to advanced

668 pages

16h 12m

English

Wrox

Read now

Unlock full access

Copyright
About the Authors
Credits
Acknowledgments
Introduction
I. Grids, Editors, Navigation, and Controls
1. Programming with the ASPxGridView
1.1. Understanding How Ajax Delivers Real Performance to the ASPxGridView1.1.1. What Does Ajax Do for Web Developers?1.1.2. ASPxGridView and Ajax1.2. Binding and Editing Data in the ASPxGridView1.2.1. Creating a New Data Source from the Task Menu1.2.2. Editing Column Information1.3. Filtering Data1.3.1. Using the Filter Row1.3.2. Using the Filter Row Menu1.3.3. Filtering with the Header Filter Button1.3.4. Defining Dynamic Predicates with the Filter Bar1.3.4.1. Filtering with a Logical Or1.3.4.2. Adding Condition Groups1.3.5. Filtering the Grid Programmatically1.3.6. Configuring Filtering Using web.config Settings1.4. Grouping and Sorting Data1.5. Creating and Using Summary Values1.5.1. Calculating Summary Values1.5.2. Calculating Custom Summaries1.5.3. Calculating Total Custom Summaries1.6. Managing the Grid's Appearance1.7. Summary
2. Advanced ASPxGridView Computing
2.1. Storing Changes2.1.1. Implementing Write Behaviors Declaratively2.1.2. Using Stored Procedures for Declarative Writes2.1.3. Implementing Write Behaviors Dynamically (with Code)2.2. Enabling Callback Compression2.3. Catching Callback Errors Using an ASPxHttpHandlerModule2.3.1. Displaying Callback Errors2.3.2. Redirecting Callback Errors to a Specific Web Error Page2.3.2.1. Logging Errors in Application_Error Event2.3.2.2. Implementing an Error Logging IHttpModule2.4. Binding the ASPxGridView to an ArrayList or Collection2.4.1. Binding an ArrayList to an ASPxGridView2.4.2. Binding a Generic Collection to an ASPxGridView2.4.2.1. Defining Custom Entities and Collections2.4.2.2. Initializing Custom Collections2.4.2.3. Using Test Projects2.4.2.3.1. Implementing an Object Dumper Using Reflection2.4.2.3.2. For Fun: Implementing an Object Dumper with LINQ2.4.2.4. Binding a Custom Collection to an ASPxGridView2.5. Using Unbound Columns2.6. Implementing a Custom Sort2.7. Exporting Grid Data2.7.1. Exporting ASPxGridView Data to PDF, RTF, CSV, and XLS2.7.2. Adding Export Detail with the RenderBrick Event2.7.3. Implementing Your Own Exporter2.8. Using Master and Detail Grids2.9. Saving User Customizations with Cookies2.10. Programming Client-Side Events2.10.1. Adding an ASPxPopupMenu to an ASPxGridView2.10.2. Implementing the ASPxPopupMenu Behavior2.10.3. Debugging JavaScript2.11. Using Custom Script Properties2.12. Enabling Horizontal Scrolling2.13. Displaying Images Directly from a Database in a Template Region2.13.1. Displaying Images from a Database Manually2.13.2. Displaying Images from a Database in the ASPxGridView2.14. Summary
3. Using the ASPxTreeList, ASPxDataView, and ASPxNewsControl
3.1. Displaying Data in Tree Views3.1.1. Using the ASPxTreeList in Unbound Mode3.1.1.1. Defining Columns3.1.1.2. Adding TreeListNodes Programmatically3.1.1.2.1. Tightening Up the Code with Refactor! Pro3.1.1.2.2. Replacing foreach with Array.ForEach3.1.1.3. Defining Template Columns3.1.2. Creating a Windows Explorer-Style Web Page with Virtual Mode3.1.3. Binding (over Building) to a SqlDataSource3.1.3.1. Defining a Query with the Query Builder3.1.3.2. Paging (and Overlapping Control Features)3.1.4. Sorting Hierarchies of Data3.1.5. Modifying ASPxTreeList Data3.1.5.1. Editing When a Node Contains Multiple Tables3.1.5.1.1. Implementing an UPDATE Stored Procedure with T-SQL3.1.5.1.2. Constructing the Web Page with an Updatable ASPxTreeList3.1.5.2. Defining a Custom Form Template3.1.5.2.1. Adding the Update and Cancel Command Controls to the Toolbox3.1.5.2.2. Constructing a Custom Edit Template3.1.5.3. Editing ASPxTreeList Data Programmatically3.1.6. Exporting Data from an ASPxTreeList3.2. Introducing the ASPxDataView3.3. Displaying News and Product Headlines in a Web Page3.3.1. Using the ASPxNewsControl to Display Information about Published Books3.3.2. Reading ASPxNewsControl Images from a Database3.3.2.1. Using an IHttpHandler to Read Images from the Database3.3.2.1.1. Replacing an Image URL Field with an IHttpHandler Request3.3.2.1.2. Querying the Image and Writing It to the HttpResponse Stream3.3.2.2. Optimizing Database Reads with the Application Cache3.4. Summary
4. Adding SiteMaps, Navigation, and Pop-Up Dialog Boxes
4.1. Implementing a Navigation Bar4.1.1. Incorporating Basic Navigation Using an XML File4.1.1.1. Authoring an XML File4.1.1.2. Creating an XML File Using Functional Construction and LINQ4.1.1.3. Binding the XML Data to an ASPxNavBar4.1.1.4. Configuring the ASPxNavBar4.1.2. Exploring the Boundaries of the ASPxNavBar4.1.2.1. Adding Groups to an ASPxNavBar4.1.2.2. Defining Templates and Nesting Controls in the ASPxNavBar4.1.2.2.1. Adding Group Items4.1.2.2.2. Defining Custom JSProperties4.1.2.2.3. Getting User Information with JavaScript4.1.2.2.4. Defining an ItemTextTemplate4.1.2.2.5. Nesting Controls in a ContentTemplate4.1.2.3. Updating Dependent Controls Asynchronously with the CustomCallback4.1.2.3.1. Making JavaScript Easier with the ClientInstanceName4.1.2.3.2. Programming ClientSideEvents to Initiate a CustomCallback4.1.2.4. Enabling animation4.1.2.5. Improving the appearance with a theme4.2. Facilitating Social Networking with the ASPxCloudControl4.2.1. Configuring Microsoft Indexing Service4.2.2. Defining a Catalog and Directory, and Building the Index4.2.3. Linking the Indexing Service to the FileSystem Via SQL Server4.2.4. Querying the Indexing Service4.2.5. Configuring the ASPxCloudControl4.2.5.1. Setting the ASPxCloudControl properties4.2.5.2. Examining the Supporting C# code4.3. Creating a Sitemap with XML and the ASPxSiteMapControl4.3.1. Binding an ASPxSiteMapControl to an Existing .sitemap File4.3.2. Building a Sitemap Based on the Current Structure of Your Site4.3.3. Building a Site Map Dynamically4.4. Using Modal Dialogs in ASP.NET4.4.1. Blending showModalDialog with JavaScript and the ASPxCallbackPanel4.4.1.1. Using a RequiredFieldValidator4.4.1.2. Implementing the OK Behavior4.4.1.3. Implementing the Cancel Behavior4.4.1.4. Displaying a Modal Dialog with showModalDialogs4.4.1.5. Sending User Input to the Server Using the ASPxCallbackPanel4.4.2. Implementing a Modal Login Window with the ASPxPopupControl4.4.2.1. Replacing the RequiredFieldValidators with ASPxTextBox ValidationSettings4.4.2.1.1. Defining a ValidationGroup4.4.2.1.2. Specifying a Required Field4.4.2.2. Coding the Client-Side Events for the Popup4.4.2.2.1. Using the ASPxClientEdit Object4.5. Summary

5. Implementing a Menu and Tabbed Controls
5.1. Building Menus with the ASPxMenu5.1.1. Defining Menu Items5.1.2. Binding to an ASPxSiteMapDataSource and XML File5.1.3. Exploring ASPxMenu Features5.1.3.1. Defining Menu Separators5.1.3.2. Adding Menu Tooltips5.1.3.3. Specifying Display Delay5.1.3.4. Using MenuItem Hot Tracking and Opacity5.1.4. Defining Menu Items with Code5.1.5. Defining Menu Templates5.1.5.1. Using the ASPxRoundPanel5.1.5.2. Adding a CallbackPanel5.1.5.3. Defining the ClientInstanceName or Not5.1.5.4. Adjusting the ASPxMenu's Gutter Width5.1.5.5. Adding Separators between Groups of MenuItems5.1.5.6. Using an HTML<table> to Manage Template Layout5.1.5.6.1. Converting a Number to a String in JavaScript5.1.5.6.2. Converting a String to a Number5.1.5.6.3. Closing All Menus with JavaScript5.1.5.6.4. Converting Strings to Enum Types5.1.5.6.5. Creating Templates Quickly5.1.6. Implementing a Tabbed Menu5.1.6.1. Defining the RootItemTemplate5.1.6.2. Enhancing Visual Appearance with a Cascading Style Sheet5.1.6.2.1. Using a Background Image to Create a Gradient Effect5.1.6.2.2. Using Images to Shape the ASPxMenu's Appearance5.1.6.2.3. Creating a Gradient Effect with a DXImageTransform5.1.7. Emulating a Toolbar with the ASPxMenu5.2. Incorporating Pop-Up Menus into Your Web Application5.2.1. Designing the ASPxPopupMenu5.2.2. Implementing the JavaScript Class5.2.3. Coding the Client-Side Behaviors5.3. Creating Tabbed Views5.3.1. Customizing the Appearance of Tabs5.3.2. Using the ASPxPageControl5.4. Summary
6. Managing Scheduled Items and Using Gauges
6.1. Scheduling Calendar Events6.1.1. Data Binding an AccessDataSource to the ASPxScheduler6.1.1.1. Reviewing the CarsDB.mdb Database Tables6.1.1.2. Mapping the CarsDB.mdb Tables to the ASPxScheduler6.1.1.2.1. Mapping the Appointments Data Source6.1.1.2.2. Mapping the Resources Data Source6.1.1.3. Implementing the Code-Behind to Support Inserts6.1.2. Using the Scheduler in List Bound Mode6.1.2.1. Defining the Custom Entity Class6.1.2.2. Implementing the BindingList<T> class6.1.2.3. Implementing the Custom Data Source6.1.2.4. Defining and Associating the Custom Data Source with an ObjectDataSource6.1.2.5. Programmatically Defining the Appointment Mappings6.1.2.6. Programmatically Specifying the Resources6.1.2.7. Completing the Code-Behind6.1.3. Exploring View Types6.1.3.1. Changing Work Days6.1.3.2. Modifying the Holidays Collection6.1.3.2.1. Using the ASPxDateNavigator6.1.3.2.2. Displaying Multiple Months6.1.4. Changing the Active View with Client-Side Script6.1.5. Grouping Schedule Events with the ASPxResourceNavigator6.1.6. Defining an Appointment Template6.1.6.1. Implementing the UserControl Template6.1.6.2. Incorporating the Template in the ASPxScheduler's DayView6.1.7. Exporting and Importing a Calendar6.2. Using the ASPxGaugeControl6.2.1. Exploring the ASPxGaugeControl Properties6.2.2. Dynamically Applying Gauge Styles6.2.2.1. Assembling the Sample GUI6.2.2.2. Implementing the Code-Behind6.2.2.2.1. Exploring the Page_Load and Callback Handlers6.2.2.2.2. Reviewing the MatchCollection in the CallbackParameterParser6.2.2.2.3. Exploring the StyleChangedHandler6.2.3. Data Binding Gauges6.2.3.1. Adding Labels6.2.3.2. Adding Gauge Needles6.2.3.2.1. Associating Needles with ArcScaleNeedleComponents6.2.3.2.2. Specifying (Needle) Shaders6.2.3.3. Adding DataBinding to the ArcScaleComponent6.2.3.4. Defining the Custom Data Type6.2.3.5. Implementing Custom Extension Methods6.2.3.6. Reading the XML Data with LINQ for XML6.2.3.7. Dynamically Updating the Scale6.3. Summary
II. Data Sources, JavaScript, CSS, and Themes
7. Using the Data That Makes Sense for Your Solution
7.1. Using an XpoDataSource7.1.1. Using the DevExpress' Object Relational Mapping Capability7.1.2. Using the ASPxTitleIndex with an XpoDataSource7.1.3. Using a View with (XPO) Persistent Objects7.1.3.1. Defining a Persistent Class Based on a View7.1.3.2. Specifying XpoDataSource Criteria7.1.3.3. Contriving a Unique ID for Views7.2. Enabling ServerMode for High Performance Applications7.3. Generating a Database Dynamically with XPO7.3.1. Requesting a Connection String from the Database Server7.3.2. Defining the Tweet Class7.3.3. Creating a Database Dynamically with XPO7.3.4. Querying Twitter7.3.5. Extracting the Tweet Data with LINQ for XML7.3.6. Using UnitOfWork to Update the Database7.4. Summary
8. Implementing Data Solutions with the ASPxPivotGrid
8.1. Transforming Relational Data into an ASPxPivotGrid8.1.1. Using Relational Data in an ASPxPivotGrid8.1.1.1. Defining the SQL Query8.1.1.2. Configuring the ASPxPivotGrid Fields8.1.2. Using Multiple Data Fields8.1.3. Choosing the Field Summary Type8.1.4. Implementing a Custom Summary8.1.5. Calculating Fields Manually8.1.6. Using the Built-in Summary Variation Feature8.2. Exporting Data to Create Crosstab Reports8.3. Binding to an OLAP Cube8.4. Using an ASPxPivotGrid as a WebChartControl's Data Source8.5. Grouping Axis Values8.5.1. Grouping Axis Values8.5.2. Grouping Values Manually8.6. Arranging Values Hierarchically8.6.1. Creating a Hierarchy8.6.2. Keeping Fields Together8.7. Calculating Totals8.7.1. Computing Summaries Automatically8.7.2. Computing Running Totals8.7.3. Using Manually Specified Totals8.8. End-User Data Filtering8.9. Sorting Data and Displaying Top or Bottom Values8.9.1. Sorting Manually8.9.2. Displaying Top or Bottom Numbers8.10. Using the Drill-Down Window8.11. Summary
9. Using the ASPxHtmlEditor
9.1. Managing ASPxHtmlEditor Features9.1.1. Enabling or Disabling Scripts9.1.2. Allowing IFrames9.1.3. Allowing Form Elements9.1.4. Allowing Supported Editor Views9.1.5. Updating Document Elements Automatically9.2. Defining a Custom ASPxHtmlEditor Toolbar9.2.1. Adding a Custom Toolbar Item with Code9.2.2. Defining CustomCommand Toolbar Behavior and Ajax9.3. Applying Custom Styles (CSS)9.4. Enabling Spell Checking9.5. Summary
10. Using Themes, CSS, and JavaScript for Customizations and Enhancements
10.1. Defining and Managing Style Information10.1.1. Specifying Style Information and Understanding Precedence10.1.1.1. Creating Inline Styles10.1.1.2. Creating Page-Specific Styles10.1.1.3. Linking External Cascading Style Sheets10.1.1.4. Understanding Style Precedence10.1.2. Creating Cascading Style Sheets10.1.2.1. Defining Element-based Styles10.1.2.2. Defining Class-based styles10.1.2.3. Defining ID-based Styles10.1.2.4. Defining At-rule Styles10.1.2.5. Qualifying Style Rules with Specific Selectors10.1.2.6. Exploring Additional Style Sheet Attributes10.1.2.6.1. Using the Expression Attribute10.1.2.6.2. Using the Behavior Attribute10.1.2.6.3. Using the !Important Declaration10.1.2.6.4. Defining Filters10.1.2.6.5. Specifying an Accelerator10.1.2.6.6. Using the Zoom Attribute10.1.2.7. Creating a Behavior Script Component10.1.3. Managing Style Information with Visual Studio Features10.2. Using Skins and Themes10.2.1. Applying Existing Themes10.2.2. Applying a Theme to Your Web Application10.2.3. Changing a Theme Dynamically10.2.4. Defining Custom Skins and Themes10.2.4.1. Creating a New Skin File10.2.4.2. Defining a Custom Theme10.3. Making the Most of JavaScript10.3.1. Common Client-Side Functionality10.3.2. Client-Side Discussion10.3.3. Client-Side Events10.3.3.1. Quick Language Overview10.3.3.2. Creating a Singleton10.3.3.3. Prototypal Inheritance10.3.4. JavaScript Debugging10.4. Summary
III. Ajax, Charting, Reporting, and Cloud Computing
11. Asynchronous Computing for ASP.NET
11.1. Controlling Asynchronous Behavior with a Timer11.1.1. Controlling Asynchronous Behavior with Callbacks11.1.2. Using the ASPxCallback Control11.1.3. Using the ASPxCallbackPanel Control11.2. Displaying Multimedia Content11.2.1. Creating a YouTube Player11.2.2. Controlling the YouTube Player11.2.3. Playing FLV Files11.3. Summary
12. Adding Charts and Graphs to Your Applications
12.1. The Vernacular12.2. Creating a Chart12.3. Medium Trust12.4. Real-time Updates12.5. Runtime Visual Effects12.6. Summary
13. XtraReports For the Web
13.1. Creating a Tabular Report13.1.1. Displaying the Report in an ASP.NET Web Page13.2. Using the SQLDataAdapter as a DataSource13.3. Using an IBindingList as a DataSource13.4. Using XML as a DataSource13.5. Conditional Report Bands13.6. Master-Detail Report13.7. Drill-Through Report13.8. Label Report13.9. Mail Merge Report13.10. Caching the Report13.11. Parameterized Stored Procedure Report13.12. Combining Multiple Reports13.13. End-User Report Designer13.14. Summary
A. Understanding How Web Applications Differ from Windows Applications
A.1. Using ASP.NET Page Lifecycle EventsA.1.1. Mastering EventsA.1.2. Reviewing the ASP.NET LifecycleA.1.3. Upgrading to IIS 7A.1.4. Reviewing Lifecycle EventsA.1.5. Programming Application-Level EventsA.1.5.1. Writing to the EventLogA.1.5.1.1. Creating an InstallerA.1.5.1.2. Running the InstallerA.1.5.1.3. Writing to the EventLog from a Web ApplicationA.1.5.1.4. Viewing the Event Entry in Visual StudioA.1.6. Programming Page-Level EventsA.2. Understanding ViewStateA.3. Why Session Information Is So ImportantA.3.1. Understanding Session ServersA.3.1.1. Configuring the SQL Server Session State DatabaseA.4. Leaving ViewState on the Server with PageAdaptersA.5. Caching Controls, Pages, and DataA.5.1. Using the @OutputCache DirectiveA.5.2. Caching Multiple Page VersionsA.5.3. Caching Parts of a PageA.5.4. Caching Application DataA.5.4.1. Adding Data to and Removing Data from the Application CacheA.5.4.2. Using Cache Dependencies to Refresh DataA.5.4.3. Expressing an Expiration PolicyA.5.4.4. Receiving Notification of Items Removed from the CacheA.6. Summary

Content preview from Professional DevExpress™ ASP.NET Controls

Chapter 8. Implementing Data Solutions with the ASPxPivotGrid

I took the whole family to Washington D.C. for a vacation in 2001. We had an itinerary that included staying at the wonderful Watergate hotel in a suite on the Potomac side; touring the White House; seeing Mozart's Marriage of Figaro at the Kennedy Center, and visiting several of the museums in the Smithsonian complex. We were able to do everything except go to the Kennedy Center; Mozart was sold out. The opera was replaced with a trip on the Metro to see the Ringling Brothers. (I think the kids enjoyed that more, anyway.)

I recall that at the Smithsonian Natural Museum of American History we saw the Fonz's jacket (played by Henry Winkler on Happy Days), the Howdy Doody puppet, and an Altair MITS. The Altair was a blue box with lights. My recollection of this nascent period of the microcomputer industry is that the Altair was the first complete microcomputer kit, and it was the first microcomputer to have Microsoft software, a version of BASIC. The early version of BASIC made the lights blink, and the user had to interpret the meaning of the lights. I recall that microcomputers didn't seem to hit the mainstream consciousness until computers with monitors and keyboards existed and Lotus 1-2-3 started flying off the shelves. This interval spanned roughly 1975 to 1985 (or a little later).

Lotus 1-2-3 was the brainchild of Mitch Kapor and Jonathan Sachs. Lotus 1-2-3 was a spreadsheet application and was instrumental in helping ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 9780470500835Purchase book

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills

Professional DevExpress™ ASP.NET Controls

by Paul Kimmel, Julian Bucknall, Joe Kunk

Chapter 8. Implementing Data Solutions with the ASPxPivotGrid

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.