Product Overview

Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition

Table Of Contents

- Here’s a look at the table of contents:

0. Preface
   • Who Should Read This Book?
   • What’s in This Book?
   • The Book’s Web Site
     • The Code Archive
     • Updates and Errata
   • The SitePoint Forums
   • The SitePoint Newsletters
   • Your Feedback
   • Conventions Used in This Book
     • Code Samples
     • Tips, Notes, and Warnings
   • Acknowledgments
1. Introducing ASP.NET and the .NET Platform
   • What is ASP.NET?
   • Installing the Required Software
     • Installing Visual Web Developer 2008 Express Edition
     • Installing SQL Server Management Studio Express
   • Writing Your First ASP.NET Page
   • Getting Help
   • Summary
2. ASP.NET Basics
   • ASP.NET Page Structure
     • Directives
     • Code Declaration Blocks
     • Code Render Blocks
     • ASP.NET Server Controls
     • Server-side Comments
     • Literal Text and HTML Tags
   • View State
   • Working with Directives
   • ASP.NET Languages
     • Visual Basic
     • C#
   • Summary
3. VB and C# Programming Basics
   • Programming Basics
     • Control Events and Subroutines
     • Page Events
     • Variables and Variable Declaration
     • Arrays
     • Functions
     • Operators
     • Conditional Logic
     • Loops
   • Object Oriented Programming Concepts
     • Objects and Classes
     • Properties
     • Methods
     • Classes
     • Constructors
     • Scope
     • Events
     • Understanding Inheritance
     • Objects in .NET
     • Namespaces
   • Using Code-behind Files
   • Summary
4. Constructing ASP.NET Web Pages
   • Web Forms
   • HTML Server Controls
     • Using the HTML Server Controls
   • Web Server Controls
     • Standard Web Server Controls
     • List Controls
     • Advanced Controls
   • Web User Controls
     • Creating a Web User Control
   • Master Pages
   • Using Cascading Style Sheets (CSS)
     • Types of Styles and Style Sheets
   • Summary
5. Building Web Applications
   • Introducing the Dorknozzle Project
   • Using Visual Web Developer
     • Meeting the Features
   • Executing Your Project
   • Core Web Application Features
     • Web.config
     • Global.asax
     • Using Application State
     • Working with User Sessions
     • Using the Cache Object
     • Using Cookies
   • Starting the Dorknozzle Project
     • Preparing the Sitemap
     • Using Themes, Skins, and Styles
     • Building the Master Page
     • Using the Master Page
   • Extending Dorknozzle
   • Debugging and Error Handling
     • Debugging with Visual Web Developer
     • Other Kinds of Errors
     • Custom Errors
     • Handling Exceptions Locally
   • Summary
6. Using the Validation Controls
   • Client-side Validation and Server-side Validation
   • Introducing the ASP.NET Validation Controls
     • Enforcing Validation on the Server
   • Using Validation Controls
     • RequiredFieldValidator
     • CompareValidator
     • RangeValidator
     • ValidationSummary
     • RegularExpressionValidator
     • CustomValidator
   • Validation Groups
   • Updating Dorknozzle
   • Summary
7. Database Design and Development
   • What Is a Database?
   • Creating Your First Database
     • Creating a New Database Using Visual Web Developer
     • Creating a New Database Using SQL Server Management Studio
   • Creating Database Tables
     • Data Types
     • Column Properties
     • Primary Keys
     • Creating the Employees Table
     • Creating the Remaining Tables
     • Populating the Data Tables
   • Relational Database Design Concepts
     • Foreign Keys
     • Using Database Diagrams
     • Implementing Relationships in the Dorknozzle Database
     • Diagrams and Table Relationships
   • Summary
8. Speaking SQL
   • Reading Data from a Single Table
     • Using the SELECT Statement
     • Selecting Certain Fields
     • Selecting Unique Data with DISTINCT
     • Row Filtering with WHERE
     • Selecting Ranges of Values with BETWEEN
     • Matching Patterns with LIKE
     • Using the IN Operator
     • Sorting Results Using ORDER BY
     • Limiting the Number of Results with TOP
   • Reading Data from Multiple Tables
     • Subqueries
     • Table Joins
   • Expressions and Operators
   • Transact-SQL Functions
     • Arithmetic Functions
     • String Functions
     • Date and Time Functions
   • Working with Groups of Values
     • The COUNT Function
     • Grouping Records Using GROUP BY
     • Filtering Groups Using HAVING
     • The SUM, AVG, MIN, and MAX Functions
   • Updating Existing Data
     • The INSERT Statement
     • The UPDATE Statement
     • The DELETE Statement
   • Stored Procedures
   • Summary
9. ADO.NET
   • Introducing ADO.NET
     • Importing the SqlClient Namespace
     • Defining the Database Connection
     • Preparing the Command
     • Executing the Command
     • Setting Up Database Authentication
     • Reading the Data
     • Using Parameters with Queries
     • Bulletproofing Data Access Code
     • Using the Repeater Control
   • Creating the Dorknozzle Employee Directory
     • More Data Binding
     • Inserting Records
     • Updating Records
     • Deleting Records
     • Using Stored Procedures
   • Summary
10. Displaying Content Using Data Lists
    • DataList Basics
    • Handling DataList Events
    • Editing DataList Items and Using Templates
    • DataList and Visual Web Developer
    • Styling the DataList
    • Summary
11. Managing Content Using Grid View and Details View
    • Using the GridView Control
      • Customizing the GridView Columns
      • Styling the GridView with Templates, Skins, and CSS
      • Selecting Grid Records
    • Using the DetailsView Control
      • Styling the DetailsView
    • GridView and DetailsView Events
      • Entering Edit Mode
      • Using Templates
      • Updating DetailsView Records
    • Summary
12. Advanced Data Access
    • Using Data Source Controls
      • Binding the GridView to a SqlDataSource
      • Binding the DetailsView to a SqlDataSource
      • Displaying Lists in DetailsView
      • More on SqlDataSource
    • Working with Data Sets and Data Tables
      • What Is a Data Set Made From?
      • Binding DataSets to Controls
      • Implementing Paging
      • Storing Data Sets in View State
      • Implementing Sorting
      • Filtering Data
    • Updating a Database from a Modified DataSet
    • Summary
13. Security and User Authentication
    • Basic Security Guidelines
    • Securing ASP.NET Applications
      • Working with Forms Authentication
    • ASP.NET Memberships and Roles
      • Creating the Membership Data Structures
      • Using Your Database to Store Membership Data
      • Using the ASP.NET Web Site Configuration Tool
      • Creating Users and Roles
      • Changing Password Strength Requirements
      • Securing Your Web Application
      • Using the ASP.NET Login Controls
    • Summary
14. Working with Files and Email
    • Writing and Reading Text Files
      • Setting Up Permissions
      • Writing Content to a Text File
      • Reading Content from a Text File
    • Accessing Directories and Directory Information
      • Working with Directory and File Paths
    • Uploading Files
    • Sending Email with ASP.NET
      • Sending a Test Email
      • Creating the Company Newsletters Page
    • Summary
15. . ASP.NET AJAX
    • What is Ajax?
    • ASP.NET AJAX
    • Using the UpdatePanel Control
      • Managing the ScriptManager Control
    • Using Triggers to Update an UpdatePanel
    • The ASP.NET AJAX Control Toolkit
      • The ValidatorCalloutExtender Control Extender
      • Getting Started with Animation
    • Summary

1. Web Control Reference
   • The WebControl Class
     • Properties
     • Methods
   • Standard Web Controls
     • AdRotator
     • BulletedList
     • Button
     • Calendar
     • CheckBox
     • CheckBoxList
     • DropDownList
     • FileUpload
     • HiddenField
     • HyperLink
     • Image
     • ImageButton
     • ImageMap
     • Label
     • LinkButton
     • ListBox
     • Literal
     • MultiView
     • Panel
     • PlaceHolder
     • RadioButton
     • RadioButtonList
     • TextBox
     • Wizard
     • Xml
   • Validation Controls
     • CompareValidator
     • CustomValidator
     • RangeValidator
     • RegularExpressionValidator
     • RequiredFieldValidator
     • ValidationSummary
   • Navigation Web Controls
     • SiteMapPath
     • Menu
     • TreeView
   • Ajax Web Extensions
     • ScriptManager
     • Timer
     • UpdatePanel
     • UpdateProgress
2. Deploying ASP.NET Web Sites
   • ASP.NET Hosting Considerations
   • Using Visual Web Developer Express to Deploy ASP.NET Applications
   • ASP.NET Deployment “Gotchas”
   • Using the SQL Server Hosting Toolkit
   • Dealing with SQL Security
3. Index