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