Registration: Click here to register for this class.

Duration: 2 days

Prerequisites: Attendees should have professional development experience creating Windows applications with Visual Studio 2005 or Visual Studio 2008.

Hardware and Software Required: While we suggest attendees bring their laptops to class to work with, computers can be provided if necessary. Evaluation copies of FarPoint Spread for ASP.NET 4 will be provided for attendees to install.

Overview and Course Content: In this two-day, hands-on training class, software developers will learn how to fully leverage the capabilities of Spread for ASP.NET 4 by adding powerful, Excel-like spreadsheet functionality into their ASP.NET based web applications. You will learn how to customize the look and feel of the spreadsheet, bind it to your data, code event handlers, import and export data with a variety of formats, and much more. Code examples and hands-on labs will be provided in both VB.NET and C#.

All of our classes are taught by industry expert software development professionals. Class sizes are limited to insure you receive the one-on-one attention needed to successfully learn the concepts presented.

Spread for ASP.NET 4 Introduction
AJAX Support
Features of Spread
Product History
Client-side Scripting
Distribution Issues
Where to Find Information & Help

Using A Spreadsheet Instead of a Grid
Differences in Functionality
When to Use Each
Application Ideas
Customer Showcase

Working With Spread For ASP.NET 4
Installation
Adding to a Project
Adding to a Web Form
Setting Properties
Overview of Spread Designer
Smart Tags Options
Working With Formulas
Coding Events

Working With Spread Designer
User Interface
Editors
Data Area
Design Features

Capabilities of Spread for ASP.NET 4
Import/Export
Databinding
Cell Types
Interactivity
Load on Demand
Printing
CSS Styles & Skins

Spread Object Model
Namespaces
Shortcut Objects
Sheets
Named Styles
Columns
Rows
Cells
Underlying Models

Spreadsheet Appearance
Overall Component
Sheet, Headers, Rows, Columns
Cells
Focus Indicators
Sheet Skins/Spread Skins
CSS Style Sheets

Cell Types
Editable Cell Types (from Currency to Text Cells)
Graphical Cell Types (from Buttons to Slider Cells)
Custom Cell Types
Best Practices in Using Cell Types

Working With Cell Data
Assigning Data to Cells
Validating Input
Copy/Move/Delete/Clear Cells

Working With Formulas
Cell References
Sheet References
Operators
Calling Functions
Using the Built-In Functions
Writing Custom Functions

Databinding
Binding to DataSets
Unbound Rows / Columns
Binding Controls to DataReaders
Custom Headers
Custom Cell Types
Custom Column Binding
Working with Hierarchical Data

File Operations
Saving Data to XML
Saving Data to Excel
Saving Data to Text
Opening & Loading Files

Maintaining State
Working With ViewState
Working With Session State
Working with SQL Server

Interactivity Features
Component Level
Rows & Columns
Cells
Cell Types

Adding Code to Respond to Events
Click Actions
Select Actions
Data Entry Actions
Sheet-level Actions
Interactivity Actions

Printing
Print Preview
Exporting PDFs
Adding Watermarks
Custom Headers & Footers

Performance Tips & Tricks From The FarPoint Development Team
Suspend Layout
Suspend Notification
AutoUpdateNotes
AllowCellOverflow