Home Page Icon
Home Page
Table of Contents for
VIII. Accessing Data in Expression Web
Close
VIII. Accessing Data in Expression Web
by Jim Cheshire
Special Edition Using Microsoft® Expression® Web
Copyright
Dedication
About the Author
Acknowledgments
We Want to Hear from You!
Reader Services
Introduction
Who Should Read This Book?
Rest in Peace, FrontPage
The Need for Expression Web
A Comparison Grid
How This Book Is Organized
Special Elements
Cross-References
Notes, Tips, Cautions, and Sidebars
Troubleshooting
Lagniappe (lan yap’) n., a gift or bonus
I. An Overview
1. A Tour of Expression Web
The Expression Web Interface
Task Panes
The Folder List
The Design Surface
The Status Bar
Working with Web Sites
Creating Web Sites
Features for Teams
Web Site Reports
Publishing Web Sites
Tools for Creating Pages
Powerful Table Tools
Dynamic Web Templates
Find and Replace
Editing Tag Properties
Quick Tag Tools
Powerful CSS Tools
Style Builder
Manage Styles Task Pane
Apply Styles Task Pane
Site Optimization
Accessibility Reports
Compatibility Reports
CSS Reports
Scripting and Dynamic Content
Interactive Buttons
Behaviors
Layers
ASP.NET 2.0 Controls
Data Access Features
Lagniappe (lan yap’) n., a gift or bonus: Extending Expression Web
II. Web Sites in Expression Web
2. Creating a Web Site
What Is a Web Site?
How Expression Web Maintains a Web Site
Web Sites and Subsites
Web Site Templates
Types of Web Sites
Disk-based Web Sites
Creating a Disk-Based Web Site
FTP Web Sites
Creating an FTP Web Site
HTTP Web Sites
Creating an HTTP Web Site
Creating a Site Using SSL
Troubleshooting
Don’t See _vti Folders
Cannot Locate Server Error Creating FTP Site
Repeatedly Prompted for Username and Password
Lagniappe (lan yap’) n., a gift or bonus: Deciding on a Web Site Type
3. Publishing a Web Site
What Is Publishing?
Server Options for Publishing
FrontPage Server Extensions
WebDAV
FTP
File System
Publishing Content
Configuring Publish Options
Optimizing HTML during Publishing
The Copy Web Site View
Troubleshooting HTTP Publishing
HTTP Authentication Traffic
Using Fiddler to Troubleshoot HTTP Publishing Errors
Using Ethereal to Troubleshoot HTTP Publishing Errors
Troubleshooting
Username and Password Not Accepted
FrontPage Server Extensions Aren’t Installed
FrontPage Server Extensions Are Used Instead of WebDAV
Content Missing after Publishing
HTML Optimization Doesn’t Affect Web Files
Ethereal Captures Nothing
Lagniappe (lan yap’) n., a gift or bonus: Hosting Your Web Site
4. Web Site Management and Reporting
Web Site Settings
General Tab
Preview Tab
Advanced Tab
Language Tab
Database Tab
Using Expression Web Source Control
Expression Web’s Source Control
Visual SourceSafe Integrated Source Control
Web Page Workflow
Web Site Reports
Configuring Reports
Saving Reports
Troubleshooting
Page Encoding Doesn’t Affect Pages
Source Control Options Disabled
Workgroup Settings Aren’t Correct
Lagniappe (lan yap’) n., a gift or bonus: Making the Most of Workflow
5. Importing a Web Site
Using the Import Web Site Wizard
Step 1: Choosing an Import Method
FrontPage Server Extensions
WebDAV
FTP
File System
HTTP
Step 2: Specifying a Destination Web Site Location
Step 3: Finish
Troubleshooting
Import Web Site Wizard Skips Set Import Limits Step
Username and Password Not Accepted
Lagniappe (lan yap’) n., a gift or bonus: Importing Versus Publishing
6. Using Personal Web Packages
What Are Personal Web Packages?
Creating a Personal Web Package
Importing a Personal Web Package
Troubleshooting
File Dependencies Incomplete
Lagniappe (lan yap’) n., a gift or bonus: Capitalizing on Personal Web Packages
III. Creating and Editing Web Content
7. Creating Pages and Content
Creating Web Pages
General Page
ASP.NET Pages
CSS Layouts
Style Sheets
Frames Pages
Importing Files
Formatting Text
How Expression Web Formats Text
Font Families
Font Sizes
Creating Hyperlinks
Targeting Hyperlinks
Hyperlink Parameters
HTML Bookmarks
Hyperlink ScreenTips
Spell-Checking
Configuring Page Properties
General Tab
Formatting Tab
Advanced Tab
Custom Tab
Language Tab
Workgroup Tab
Using Code Snippets
Configuring File Editors
Troubleshooting
Spelling Errors Not Underlined
Code Snippets Don’t Display
Lagniappe (lan yap’) n., a gift or bonus: Making the Most of Code Snippets
8. Using Web Page Views
Introduction to Page Views
Working in Design View
Visual Aids
Block Selection
Visible Borders
Empty Containers
Margins and Padding
CSS Display:none and CSS Visibility:hidden Elements
ASP.NET Non-visual Controls
ASP.NET Control Errors
Template Region Labels
Formatting Marks
Ruler and Grid
Tracing Images
Adjusting Page Size
Working in Code View
Customizing Code Formatting
Quick Tag Tools
IntelliSense
Context Menu
Bookmarks
Working in Split View
Troubleshooting
Tracing Image Disappears
Quick Tag Tools Not Visible
Lagniappe (lan yap’) n., a gift or bonus: Taking Advantage of Page Views
9. Using Tables and Layout Tables
The Origin of Tables
The Makeup of an HTML Table Tag
The align Attribute
The border Attribute
The cellpadding Attribute
The cellspacing Attribute
The frame Attribute
Rows, Columns, and Cells
The colspan and rowspan Attributes
Aligning Content in Cells
baseline
bottom
middle
top
Tables in Expression Web
Inserting Tables
Customizing Tables
Selecting and Merging Cells
Aligning Content in Cells
Adjusting Table Width
Adding and Deleting Rows and Columns
Layout Tables and Cells
Designing Layout with Tables
Configuring Columns and Rows Using the Layout Tool
Using the Layout Tables Task Pane
Troubleshooting
Table Is Too Wide
Cannot Clear Contradicting Height or Width
Cannot Drag and Drop Cells in Layout Table
Lagniappe (lan yap’) n., a gift or bonus: Designing for Multiple Resolutions Using Tables
10. Using Frames
Using Frames in Web Sites
When to Use Frames
When Not to Use Frames
Creating Frames Pages
Configuring Frames
Splitting Frames
Deleting Frames
Creating Alternate Content
Targeting Frames in Hyperlinks
Adding and Configuring Inline Frames
Troubleshooting
Targeted Hyperlink Opens New Window
Lagniappe (lan yap’) n., a gift or bonus: Tips for Frames
Frame Borders
Resizable Frames
Breaking Out of a Frameset
11. Using Form Controls
Understanding HTML Forms
Using Form Controls in Expression Web
Creating a Form
Saving Form Results to a File or E-mail
File Results Tab
E-mail Results Tab
Confirmation Page Tab
Saved Fields Tab
Saving Form Results to a Database
Updating a Database with New Fields
Troubleshooting
Latest Results At End Checkbox Disabled
Asked to Remove E-mail Recipient
Cannot Enter Validation Failure Page
Form Fields Not Mapped
Lagniappe (lan yap’) n., a gift or bonus: Hidden Form Fields
12. Editing Tag Properties
An Introduction to Tag Properties
Understanding the Tag Properties Task Pane
Viewing Tag Properties with the Tag Properties Task Pane
Setting Tag Attributes with the Tag Properties Task Pane
Creating a Page
Setting Tag Properties
Using Events with the Tag Properties Task Pane
Troubleshooting
Tag Properties Task Pane Not Visible
Set Properties Don’t Appear First
Lagniappe (lan yap’) n., a gift or bonus: Tag Properties and Web Standards
13. Using the Quick Tag Tools
Introduction to the Quick Tag Tools
Locating and Selecting Elements Using the Quick Tag Selector
Editing Page Content Using the Quick Tag Editor
Editing a Tag
Removing a Tag
Inserting HTML
Wrapping a Tag
Controlling Positioning
Editing Tag Properties
Troubleshooting
Quick Tag Tools Unavailable
Remove Tag Not Enabled
Lagniappe (lan yap’) n., a gift or bonus: When to Use the Quick Tag Editor
14. Using Graphics and Multimedia
Web Image Formats
The GIF Format
The JPEG Format
The PNG Format
Inserting Images
Formatting Images
Resizing Images
Changing Picture Properties
Converting Images
Creating Image Thumbnails
Configuring Auto Thumbnails
Creating Image Maps
Page Transitions
Troubleshooting
Images Sometimes Not Visible
Larger Image Appears Too Small
Page Transitions Don’t Work
Lagniappe (lan yap’) n., a gift or bonus: Inserting Multimedia
15. Configuring Page Editor Options
Accessing Page Editor Options
Editing Page Editor Options
The General Tab
AutoThumbnail Tab
Default Fonts Tab
Code Formatting Tab
CSS Tab
Color Coding Tab
Authoring Tab
Picture Tab
Code Snippets Tab
Ruler and Grid Tab
IntelliSense Tab
Font Families Tab
Lagniappe (lan yap’) n., a gift or bonus: Experiment to Learn More
16. Using Find and Replace
An Introduction to Find and Replace
Finding and Replacing Text
Using Regular Expressions
Finding Text
Replacing Text
Using HTML Rules in Find and Replace
Finding and Replacing HTML Tags
Saving Queries
Troubleshooting
Cannot Select Search Direction
Find in Source Code Disabled
Source Code Searches Don’t Work
Lagniappe (lan yap’) n., a gift or bonus: Editing and Removing Recent Searches
IV. Using CSS in Expression Web
17. Creating Style Sheets
The Purpose of CSS
How CSS Is Applied to Web Pages
External Style Sheets
Embedded Style Sheets
Inline Styles
Formatting Content with CSS
Positioning Content with CSS
CSS Classes
Basic Application of a CSS Class
Applying Multiple CSS Classes
Pseudo-Classes
Pseudo-Elements
Troubleshooting
Attach Style Sheet Link Is Disabled
Prompted to Save Embedded File
CSS Class Not Visible
:hover Pseudo-Class Doesn’t Work
Lagniappe (lan yap’) n., a gift or bonus: CSS Background Images
18. Managing CSS Styles
Expression Web’s CSS Tools
Apply Styles Task Pane
Manage Styles Task Pane
Link Style Sheet Dialog
CSS Properties Task Pane
CSS Reports
Style Builder
Working with Styles
Using the Manage Styles Task Pane
Using the Apply Styles Task Pane
Using the CSS Properties Task Pane
Using the Style Builder
Using the Attach Style Sheet and Link Style Sheet Dialogs
CSS Reports
Checking for CSS Errors
Checking CSS Usage
Troubleshooting
No Styles Appear in Task Pane
Selected Styles Don’t Display Preview
Cannot Remove CSS Elements
Lagniappe (lan yap’) n., a gift or bonus: Arranging CSS Styles
V. Optimizing Your Web Site
19. Accessibility Features in Expression Web
An Introduction to Accessibility
Designing for Accessibility
Accessible Hyperlinks
Accessible Tables
Accessible Frames
Other Accessibility Considerations
Using the Accessibility Checker
Checking Accessibility
Working with the Accessibility Task Pane
Generating Accessibility Reports
Lagniappe (lan yap’) n., a gift or bonus: Seeing Color
20. Designing for Compatibility
A Brief History
What Is Compatibility?
Compatibility Features in Expression Web
Identifying Code Problems
doctype
The Schema
Marking Invalid Code in Code View
Using Reports to Find Problems
Troubleshooting
doctype Not Added to Page
Code View Errors and Compatibility Checker Don’t Match
Lagniappe (lan yap’) n., a gift or bonus: Don’t Rely on Expression Web To Enforce Standards
VI. Scripting, DHTML, and Other Dynamic Content
21. Using Dynamic Web Templates
An Introduction to Dynamic Web Templates
Creating a Dynamic Web Template
Creating a Page Layout
Adding Editable Regions
Attaching a Dynamic Web Template
Attaching to an Existing Page
Attaching to a New Page
Updating a Site with Dynamic Web Templates
Modifying a Dynamic Web Template
Modifying an Attached Page in Code View
Managing Editable Regions
Adding a New Editable Region
Renaming an Existing Editable Region
Resolving Mismatched Editable Regions
Detaching a Dynamic Web Template
Troubleshooting
Dynamic Web Template Menu Items Disabled
No Rename Button in Editable Regions Dialog
Lagniappe (lan yap’) n., a gift or bonus: Under the Hood
22. Using Interactive Buttons
Overview of Interactive Buttons
Inserting and Configuring Interactive Buttons
The Button Tab
The Font Tab
The Image Tab
Saving an Interactive Button
Editing an Interactive Button
Troubleshooting
Interactive Button Images Broken
Multiple Image Copies Saved for an Interactive Button
Lagniappe (lan yap’) n., a gift or bonus: Practical Uses For Interactive Buttons
23. Using Behaviors
Understanding and Working with Behaviors
Using the Behaviors Task Pane
How Behaviors Work
Adding Behaviors Within a Paragraph
Expression Web Behaviors
The Call Script Behavior
The Change Property Behavior
The Change Property Restore Behavior
The Check Browser Behavior
The Check Plug-in Behavior
The Go To URL Behavior
The Jump Menu Behavior
The Jump Menu Go Behavior
The Open Browser Window Behavior
The Play Sound Behavior
The Popup Message Behavior
The Preload Images Behavior
The Set Text Behavior
Set Text of Frame
Set Text of Layer
Set Text of Status Bar
Set Text of Text Field
The Swap Image Behavior
The Swap Image Restore Behavior
Troubleshooting
Open Browser Window Pops Up Behind Existing Window
Lagniappe (lan yap’) n., a gift or bonus: Detecting Browsers
Creating a Blank Page for Redirecting
Editing the Check Browser Code
24. Client-side Scripting
A History of Browser Scripting
JavaScript Basics
Adding JavaScript to a Web Page
Linking to an External Script File
Adding Inline JavaScript
The Document Object Model
The window Object
The document Object
Writing Simple Scripts
Showing and Hiding Page Elements
Accessing and Changing Attributes
Preloading Images
Writing a Function to Swap Images
Adding the Images
Form Field Validation
Creating the Form to Validate
Adding the JavaScript Validation Function
Validating the Form Fields
Adding the Call to the JavaScript Function
Troubleshooting
Divs Don’t Change on Rollover
Images Don’t Swap Instantly
Lagniappe (lan yap’) n., a gift or bonus: Debugging
25. Using Layers
Introduction to Layers
Inserting and Configuring Layers
Adding Content to a Layer
Resizing a Layer
Creating and Working with Child Layers
Positioning Layers
Setting Layer Properties with Behaviors
Setting the Visibility of Layers
Adding Layer Interactivity
Configuring the Products Submenu
Configuring the Support Submenu
Troubleshooting
Behaviors Don’t Work
Lagniappe (lan yap’) n., a gift or bonus: Z-Order Anomalies
26. Creating VBA Macros
Introduction to Programming with Visual Basic for Applications
Understanding Modules, Class Modules, and UserForms
Module
Class Module
UserForm
Accessing Web Sites with VBA
The Application Object Model
The Web Object Model
The Page Object Model
Writing a Macro
Creating the UserForm
Implementing the Functionality
Finishing the Code
Running the Macro
When Something Goes Wrong—Debugging
Troubleshooting
UserForm Seems Hung
Browse-time Comments Still Exist
New Settings Don’t Take
Lagniappe (lan yap’) n., a gift or bonus: Protecting Macro Code
VII. ASP.NET Development in Expression Web
27. Using the ASP.NET Development Server
Introduction to the ASP.NET Development Server
How to Use the ASP.NET Development Server
Limitations of the ASP.NET Development Server
Process Identity
No Remote Access
No Support for ASP Pages
Troubleshooting
Dynamic Content Warning with ASP.NET Development Server
Lagniappe (lan yap’) n., a gift or bonus: Starting the ASP.NET Development Server from the Command Prompt
28. Using Standard ASP.NET Controls
ASP.NET 2.0: A Brief Introduction
Creating ASP.NET Pages
The Basics of ASP.NET Controls
Understanding Control Properties
An Overview of the Standard ASP.NET Controls
The AdRotator Control
Creating a Simple AdRotator Page
Creating the Advertisement File
The Calendar Control
Formatting the Calendar Control
Calendar Control Properties
CaptionAlign
DayNameFormat
FirstDayOfWeek
NextMonthText
NextPrevFormat
PrevMonthText
SelectedDate
SelectionMode
SelectMonthText
SelectWeekText
ShowDayHeader
ShowGridLines
ShowNextPrevMonth
ShowTitle
TitleFormat
UseAccessibleHeader
VisibleDate
The Wizard Control
Wizard Steps
Creating a Simple Wizard
Step 1: Welcome
Step 2: Name/E-mail
Step 3: Address
Step 4: Lists
Step 5: Finish
Making ASP.NET Work for You
Troubleshooting
ASP.NET Controls Do Not Appear in the Browser
XML Error When Browsing ASP.NET Page
Lagniappe (lan yap’) n., a gift or bonus: Formatting with Styles
29. Using ASP.NET Navigation Controls
Overview of Navigation Systems
Creating a Sitemap File
Using the ASP.NET Menu Control
Creating a Test Web Site
Adding a Menu Control
Formatting the Menu Control
Using the AutoFormat Feature
Using CSS Styles
Using the ASP.NET TreeView Control
Formatting the TreeView Control
Using the TreeView Control’s Properties
ExpandDepth Property
ImageSet Property
NodeIndent Property
ShowCheckBoxes Property
ShowExpandCollapse Property
ShowLines Property
Using CSS Styles
Using the ASP.NET SiteMapPath Control
Formatting the SiteMapPath Control
Using SiteMapPath Properties
Troubleshooting
Warned to Browse Page from Web Server
Cannot See Menu Control in Browser
TreeView Not Visible in Browser
Lagniappe (lan yap’) n., a gift or bonus: Improving Navigation with Master Pages
30. Using ASP.NET Master Pages and User Controls
The Need For a Common Layout
The Master Page
The Content Page
Developing a Master Page Web Site
Creating the Master Page
Creating the Content Page
Troubleshooting
Parser Error When Browsing Content Page
Column Width Doesn’t Stick
Cannot Drag Layout Cell
Lagniappe (lan yap’) n., a gift or bonus: Converting an Existing Site to a Master Page Site
31. Developing a Login System with ASP.NET
Web Site Login Systems
Overview of ASP.NET 2.0 Login Controls
The Login Control
LoginStatus Control
LoginName Control
ChangePassword Control
DisplayUserName Property
MailDefinition Property
PasswordHintText Property
PasswordRecoveryUrl
SuccessPageUrl Property
PasswordRecovery Control
CreateUserWizard
LoginView Control
Creating a Login Solution
Configuring the Web Site (IIS)
Configuring the Web Site (ASP.NET Development Server)
Creating the Web Pages
Troubleshooting
ASP.NET Tab Is Missing
Metabase Access Fails Browsing ASP.NET Page
Failed to Start Monitoring Changes Error
Access Denied Error
Lagniappe (lan yap’) n., a gift or bonus: Modifying Password Requirements
32. Implementing Form Validation Using ASP.NET
The Need for Form Validation
The ASP.NET Validation Controls
CompareValidator
RangeValidator
RegularExpressionValidator
RequiredFieldValidator
CustomValidator
ValidationSummary
Common Properties
ErrorMessage Property
ControlToValidate
Display
EnableClientScript
SetFocusOnError
ValidationGroup
Creating a Validated Form
Creating the Form
Adding Form Validation
Testing the Form
Troubleshooting
Validation Controls Don’t Work
Submit Button Does Nothing
Lagniappe (lan yap’) n., a gift or bonus: Validation Groups
33. Using ASP.NET Web Parts
An Introduction to Web Parts
Creating ASP.NET User Controls
Web Parts Controls in the Toolbox
Creating a Web Parts Page
Web Parts Page Display Modes
Creating a User Control that Sets the Display Mode
Adding Code to Change the Display Mode
The Web Parts Catalog
Troubleshooting
WebPartManager Error When Browsing Web Parts Page
Error Connecting to SQL Server
Null Value Message When Browsing Web Parts Page
Error When Browsing Page with User Controls
Lagniappe (lan yap’) n., a gift or bonus: Editing Web Parts Controls
VIII. Accessing Data in Expression Web
34. Primer on Data Access Technologies
A History of Data Access
Data Access Technologies in Expression Web
ASP.NET and Other Web Application Platforms
Lagniappe (lan yap’) n., a gift or bonus: Databases Aren’t Just for Online Spreadsheets
35. Accessing Data with ASP.NET 2.0
ASP.NET 2.0 Data Source Controls
AccessDataSource Control
SqlDataSource Control
SiteMapDataSource Control
XmlDataSource Control
Displaying Data with ASP.NET 2.0
Displaying Data in Tabular Form
Adding and Configuring a GridView Control
Sorting the GridView
Editing Data with ASP.NET 2.0
Configuring the Data Source
Configuring the GridView
Testing the Page
Troubleshooting
Unable to See Data Source Control
Toolbox Not Visible
Lagniappe (lan yap’) n., a gift or bonus: Creating a Master/Detail View
Creating the Master View
Creating the Detail View
IX. Appendices
A. Using Expression Web with Visual Web Developer Express Edition
Building Robust ASP.NET 2.0 Applications
Introduction to Visual Web Developer Express Edition
Working with Web Sites in Visual Web Developer Express Edition
Creating Pages in Visual Web Developer Express Edition
Working with Controls in Visual Web Developer Express Edition
Creating a Sample Site
Creating the Web Page
Adding ASP.NET Code
Adding Form Validation
Troubleshooting
Don’t See Add New Item Dialog
Click Event Not Added
Lagniappe (lan yap’) n., a gift or bonus: Debugging ASP.NET
B. Taking Advantage of E-Commerce
The Power of E-Commerce
E-Commerce Options
Digital River
Lulu
Payment Processing
PayPal
Banks
2CO
Putting It All Together In Expression Web
Security
Advertising and Affiliates
Lagniappe (lan yap’) n., a gift or bonus: Is It Worth the Risk?
C. The Future of Web Development
Changing Standards
Benefits of XHTML
Emerging Technologies
AJAX
Using AJAX on Your Site
Ruby on Rails
Other Emerging Technologies
Lagniappe (lan yap’) n., a gift or bonus: Understanding and Using RSS
The RSS Feed
The RSS Reader
D. Resources on Expression Web, Web Design, and ASP.NET
Online Resources on Expression Web
JimcoBooks.com
Expression Web Help
The Expression Designers: Graphic, Interactive, and Web
by-Expression
Online Resources on Web Design
InformIT
Webmonkey
O’Reilly Network
World Wide Web Consortium
Online Resources on ASP.NET
asp.netPRO
4GuysFromRolla.com
ASP.NET Official Web Site
DotNetJunkies
Appendix
What’s on the CD-ROM
Installation Instructions
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
33. Using ASP.NET Web Parts
Next
Next Chapter
34. Primer on Data Access Technologies
Part VIII. Accessing Data in Expression Web
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset