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. |
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.