Part I: Getting Started
Introducing Iron Speed Designer
A Quick Tour of Iron Speed Designer
What is an Iron Speed Designer Application?
Creating Your First Application
Step 1a: Create child tables for one-to-many relationships
Step 1b: Create separate lookup tables
Step 1c: Create database views to express multi-table joins and complex queries
Step 1d: Explicitly declare primary keys in your database
Step 1e: Explicitly declare foreign keys in your database
Step 1f: Declare virtual primary keys in Iron Speed Designer
Step 1g: Declare virtual foreign keys in Iron Speed Designer
Step 2: Select a Web Page Style
Step 3: Connect to a Database Server
Microsoft Access Options for Database Server Selection
Microsoft SQL Server Options for Database Server Selection
MySQL Options for Database Server Selection
Oracle Options for Database Server Selection
Working with Complex Databases
Database, Table, and Field Name Restrictions
Step 4: Select Pages to Create
Step 5: Select Virtual Primary Keys and Virtual Foreign Keys
Step 6: Select Language and Localization Settings
Application Name and Folder Selection
Code Language and .NET Framework Selection
Namespace and Virtual Directory Selection
Step 8: Build Your Application
Navigating Your Application in Design Mode
Using the Page Layout Spreadsheet and Toolbox
Example: Using Tab Groups to Organize Fields
Example: Placing Master and Detail Panels within the Same Tab Group
Customizing Page Contents with the Cell Editor
Example: Adding Third-Party Controls to a Page
Example: Adding Custom ASCX Controls
Configuring Cell, Row and Table Styles
Example: Configuring an Expand / Collapse Row Button
Placing ASP.NET Directives in Application Pages
Example: Automatically Refresh Page on Periodic Basis
Example: Adding Application-Wide HTML Tags via Master Pages
Using Frames in Application Pages
Using Client-Side JavaScript in Application Pages
Capturing the Enter Key in Application Pages
Setting Focus in Application Pages
Adding New Web Pages to Your Application
Linking Add, Edit, Show Record, and Table Report Pages
Adding Foreign Key Table and Look Up Table Pages
Integrating Web Pages into Existing Applications
Incorporate Existing ASPX Pages into Iron Speed Designer Applications
Customizing Style Sheets and Page Styles
Example: Change the Panel Header Style
Example: Customizing Multi-Level Menu Styles
Example: Customizing Classic Menu Styles
Example: Customizing the Data Grid Styles
Example: Customizing Button / Pagination Bar Styles
Example: Set Application Page Width
Example: Set Table Panel Width
Example: Set Table Column Width
Example: Change Data Input Field Styles
Example: Customizing Button Styles
Example: Display Multi-Line Labels
Compendium of CSS Classes Used in Applications
Configuring Table and Record Panels with the Configuration Wizard
Table Column Total Configuration
Configuring Charts with the Charting Wizard
Changing Chart Labels, Titles and Data Display with Formulas
Configuring Dashboards with the Sums and Counts Wizard
Using Sum and Count Data Sources in Formulas
Specifying Security Roles for Multi-Level Menus
Specifying the Sitemap Provider
Renaming and Deleting Menu Controls
Adding Menu Items Programmatically at Application Run-time
Changing the Application Menu Type from Classic to Multi-level
Improving Multi-Level Menu Performance
Configuring Classic-style Menus
Adding Multiple Menus to a Page
Creating a Custom Classic Menu
Setting the Start Page and Error Pages
Configuring Third-Party Controls
Building and Running Your Application
Always Pre-compile Before Running
Setting the Application Assembly Information