---

Beginning ASP.NET 2.0 and Databases (Wrox Beginning Guides)

ISBN: 0471781347
EAN: 2147483647

Year: 2004
Pages: 263

Authors: John Kauffman, Bradley Millington

BUY ON AMAZON

• 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?
• Summary
• Chapter 11: Performance
• Performance Measurement
• Connection Pooling
• Performance Counters
• DataSets, Data Readers, and Recordsets
• Typed DataSets vs Late Bound DataSets
• Fine Tuning Datasets and Data Readers
• Summary
• Chapter 12: Writing an Application
• Introducing the Wrox Auction Site
• Flow of ASP.NET Pages
• Creating our Application
• Coding the Application
• Adding to this Application
• Summary
• Index
• Number
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• K
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• U
• V
• W
• X
• List of Try It Out