Beginning ASP.NET 2.0 and Databases (Wrox Beginning Guides) - page 1
- Beginning ASP.NET Databases using VB.NET
- Beginning ASP.NET Databases using VB.NET
- New in Beginning ASP.NET Databases Using VB.NET: Written and Tested or Final Release of .NET v1.0
- Table of Content
- Introduction
- Who Is This Book For?
- What You Need to Use This Book
- Conventions
- Customer Support
- Chapter 1: Displaying Data on the Web
- Pros and Cons of Data-Driven Web Sites
- Data Sources
- Retrieving Data from a Database
- Introduction to ADO.NET
- Data-driven Application Architecture
- The Microsoft SQL Server Desktop Engine
- Summary
- Chapter 2: Relational Databases
- Data and Entities
- Relational Databases
- An SQL Primer
- Normalization
- SQL Server vs. Access
- Summary
- Chapter 3: Connecting to a Data Source
- What is a Connection?
- Connection Syntax
- Getting Schema Information (OLE DB)
- A Better Connection String
- Common Mistakes
- Summary
- Chapter 4: Data Readers, Command Objects, and Web Server Controls
- Handling and Displaying Data in ADO.NET and ASP.NET
- Using a Data Reader
- Using Data-based Controls in ASP.NET
- List Box and Drop-down List Controls
- Using the Radio Button List
- Multiple Selections with Check Boxes and List Boxes
- Data Grids
- Common Mistakes
- Summary
- Chapter 5: Reading Data using the Dataset Object
- DataSet Objects
- DataGrid Column Properties
- DataGrid Sorting
- DataGrid Paging
- Calendar Control and Data Sources
- Filtering from a Drop-down List
- Common Mistakes
- Summary
- Chapter 6: Creating and Inserting Records
- Inserting Data with ASP.NET and ADO.NET
- Using ADO.NET to Insert a New Record
- ASP.NET Validation Controls
- Inserting Records Using a DataSet Object
- Summary
- Chapter 7: Updating and Deleting Records
- Updating a Database
- Deleting Data
- Validating Data
- Summary
- Chapter 8: Using Stored Procedures
- Advantages of Stored Procedures
- Calling a Stored Procedure
- Creating Stored Procedures
- Passing Parameters to a Stored Procedure
- Stored Procedure Output Parameters
- Summary
- Chapter 9: Data-Driven ASP.NET Applications in the Real World
- Handling Database Errors
- Transactions
- Code Organization
- Data Security Tips
- Summary
- Chapter 10: Componentization
- What is Componentization?
- Why Use Class Libraries?
- Writing a Class Library
- Writing a Class Library for Database Access
- What Else Do We Need to Know?
