VB.NET and SQL Server 2000 : Building an Effective Data Layer

by Gosnell, Denise Et Al

• ISBN13: 9781861007056
• ISBN10: 1861007051
• Edition: 1st
• Format: Trade Paper
• Copyright: 2002-06-01
• Publisher: Springer-Verlag New York Inc

Summary

Offers updated information that concentrates on using these two technologies together. Provides efficient, specific application knowledge giving developers the skills they need to get the job in front of them done. Softcover.

Table of Contents

Introduction	p. 1
Who Is This Book For?	p. 3
What You Need To Use This Book	p. 4
Conventions	p. 4
Customer Support	p. 5
ADO.NET	p. 9
History of Universal Data Access and ADO	p. 9
ADO.NET The New World of Data Access	p. 11
Summary	p. 24
The SqlClient Namespace	p. 27
SqlConnection Object	p. 27
SqlCommand Object	p. 38
SqlDataReader Object	p. 44
SqlDataAdapter Object	p. 47
DataSet Object	p. 56
DataTable Object	p. 60
DataRow Object	p. 67
DataColumn Object	p. 72
DataRelation	p. 79
Summary	p. 87
HR Sample Application	p. 89
The HumanResources Database	p. 89
HumanResources Project	p. 99
Summary	p. 123
Handling Streams of Data with ADO.NET	p. 125
Introduction	p. 125
Using a DataReader To Retrieve Data	p. 126
Using a DataReader To Update Data	p. 137
Populating Controls Using a DataReader	p. 139
Summary	p. 142
Writing Good Stored Procedures	p. 145
Stored Procedures and Performance	p. 146
Security	p. 146
Executing Stored Procedures	p. 148
Parameters in Stored Procedures	p. 151
SELECT * Statements	p. 153
Deferred Name Resolution	p. 153
Joins	p. 155
Temporary Tables	p. 162
Cursors	p. 166
Decision Making In-Line	p. 168
Control of Flow	p. 172
Passing Resultsets	p. 177
Navigating Trees	p. 184
Nesting Procedures	p. 186
User-Defined Functions	p. 187
Global Variables	p. 190
Handling Errors	p. 193
Summary	p. 200
Using Stored Procedures in VB.NET	p. 203
Creating Stored Procedures in VS.NET	p. 204
DataReader	p. 207
Multiple Resultsets	p. 209
Passing Parameters	p. 212
Return Parameters	p. 220
Retrieving XML	p. 222
Passing in XML	p. 224
SQLXML	p. 226
Summary	p. 236
Data Binding	p. 239
Introduction	p. 239
Data Binding with Windows Forms	p. 240
Data Binding with Web Forms	p. 256
Summary	p. 267
Transactions and Locking	p. 269
The ACID Test	p. 270
Implicit & Explicit Transactions	p. 271
Using Transactions	p. 271
Commands within Transactions	p. 282
Transactions and Locks	p. 286
Transaction Best Practices	p. 304
Summary	p. 311
Component Services	p. 313
Serviced Components	p. 313
Building Serviced Components	p. 314
Object Pooling and Other COM+ Features	p. 330
Summary	p. 332
SQL Server and XML	p. 335
For Xml Explicit	p. 336
Transforming with Style	p. 357
Stored Procedures As Web Services	p. 369
Summary	p. 384
Effective Administration for Developers	p. 387
Managing Security	p. 388
Monitoring SQL Server	p. 413
Moving a Database	p. 431
Generating Scripts	p. 436
Summary	p. 439
Case Study: IBankAdventure	p. 441
Introduction	p. 441
The IBankAdventure Database	p. 442
IBankAdventure Business Objects	p. 456
IBankAdventure User Interface	p. 472
Where To Go From Here	p. 506
Summary	p. 507
ADO.NET Object Model	p. 509
Command Classes	p. 509
Connection Classes	p. 511
DataAdapter Classes	p. 513
DataColumn Class	p. 515
DataColumnMapping Class	p. 517
DataReader Classes	p. 518
DataRelation Class	p. 521
DataRow Class	p. 523
DataSet Class	p. 525
DataTable Class	p. 529
DataTableMapping Class	p. 532
DataView Class	p. 533
DataViewManager Class	p. 535
DataViewSetting Class	p. 536
OleDbError Class	p. 537
OleDbException Class	p. 538
Parameter Classes	p. 539
SqlError Class	p. 540
SqlException Class	p. 541
Transaction Classes	p. 542
Index	p. 545
Table of Contents provided by Syndetics. All Rights Reserved.