9781861007056

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

by
  • ISBN13:

    9781861007056

  • ISBN10:

    1861007051

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

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $49.99 Save up to $12.50
  • Buy Used
    $37.49
    Add to Cart Free Shipping Icon Free Shipping

    USUALLY SHIPS IN 2-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

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

Introductionp. 1
Who Is This Book For?p. 3
What You Need To Use This Bookp. 4
Conventionsp. 4
Customer Supportp. 5
ADO.NETp. 9
History of Universal Data Access and ADOp. 9
ADO.NET The New World of Data Accessp. 11
Summaryp. 24
The SqlClient Namespacep. 27
SqlConnection Objectp. 27
SqlCommand Objectp. 38
SqlDataReader Objectp. 44
SqlDataAdapter Objectp. 47
DataSet Objectp. 56
DataTable Objectp. 60
DataRow Objectp. 67
DataColumn Objectp. 72
DataRelationp. 79
Summaryp. 87
HR Sample Applicationp. 89
The HumanResources Databasep. 89
HumanResources Projectp. 99
Summaryp. 123
Handling Streams of Data with ADO.NETp. 125
Introductionp. 125
Using a DataReader To Retrieve Datap. 126
Using a DataReader To Update Datap. 137
Populating Controls Using a DataReaderp. 139
Summaryp. 142
Writing Good Stored Proceduresp. 145
Stored Procedures and Performancep. 146
Securityp. 146
Executing Stored Proceduresp. 148
Parameters in Stored Proceduresp. 151
SELECT * Statementsp. 153
Deferred Name Resolutionp. 153
Joinsp. 155
Temporary Tablesp. 162
Cursorsp. 166
Decision Making In-Linep. 168
Control of Flowp. 172
Passing Resultsetsp. 177
Navigating Treesp. 184
Nesting Proceduresp. 186
User-Defined Functionsp. 187
Global Variablesp. 190
Handling Errorsp. 193
Summaryp. 200
Using Stored Procedures in VB.NETp. 203
Creating Stored Procedures in VS.NETp. 204
DataReaderp. 207
Multiple Resultsetsp. 209
Passing Parametersp. 212
Return Parametersp. 220
Retrieving XMLp. 222
Passing in XMLp. 224
SQLXMLp. 226
Summaryp. 236
Data Bindingp. 239
Introductionp. 239
Data Binding with Windows Formsp. 240
Data Binding with Web Formsp. 256
Summaryp. 267
Transactions and Lockingp. 269
The ACID Testp. 270
Implicit & Explicit Transactionsp. 271
Using Transactionsp. 271
Commands within Transactionsp. 282
Transactions and Locksp. 286
Transaction Best Practicesp. 304
Summaryp. 311
Component Servicesp. 313
Serviced Componentsp. 313
Building Serviced Componentsp. 314
Object Pooling and Other COM+ Featuresp. 330
Summaryp. 332
SQL Server and XMLp. 335
For Xml Explicitp. 336
Transforming with Stylep. 357
Stored Procedures As Web Servicesp. 369
Summaryp. 384
Effective Administration for Developersp. 387
Managing Securityp. 388
Monitoring SQL Serverp. 413
Moving a Databasep. 431
Generating Scriptsp. 436
Summaryp. 439
Case Study: IBankAdventurep. 441
Introductionp. 441
The IBankAdventure Databasep. 442
IBankAdventure Business Objectsp. 456
IBankAdventure User Interfacep. 472
Where To Go From Herep. 506
Summaryp. 507
ADO.NET Object Modelp. 509
Command Classesp. 509
Connection Classesp. 511
DataAdapter Classesp. 513
DataColumn Classp. 515
DataColumnMapping Classp. 517
DataReader Classesp. 518
DataRelation Classp. 521
DataRow Classp. 523
DataSet Classp. 525
DataTable Classp. 529
DataTableMapping Classp. 532
DataView Classp. 533
DataViewManager Classp. 535
DataViewSetting Classp. 536
OleDbError Classp. 537
OleDbException Classp. 538
Parameter Classesp. 539
SqlError Classp. 540
SqlException Classp. 541
Transaction Classesp. 542
Indexp. 545
Table of Contents provided by Syndetics. All Rights Reserved.

Supplemental Materials

What is included with this book?

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.

Rewards Program