VB.NET and SQL Server 2000 Building an Effective Data Layer / Edition 1

VB.NET and SQL Server 2000 Building an Effective Data Layer / Edition 1

by GOSNELL, Jonathan A. Walsh, Denise M. Gosnell
     
 

ISBN-10: 1861007051

ISBN-13: 9781861007056

Pub. Date: 06/27/2002

Publisher: Apress

Many VB developers choose SQL Server 2000, a robust enterprise-level database system, to provide the data layer in their applications. The introduction of Microsoft's .NET Framework brings us ADO.NET, the latest means of connecting to that data source.

This book will teach the experienced VB developer, with a working knowledge of Visual Basic .NET, how to integrate

Overview

Many VB developers choose SQL Server 2000, a robust enterprise-level database system, to provide the data layer in their applications. The introduction of Microsoft's .NET Framework brings us ADO.NET, the latest means of connecting to that data source.

This book will teach the experienced VB developer, with a working knowledge of Visual Basic .NET, how to integrate SQL Server 2000 with VB .NET applications using ADO.NET.

ADO.NET introduces .NET classes for:

  • Efficient access to multiple data sources
  • Data sorting
  • Data manipulation
  • Improved inter-application communication

    "Building an effective data layer" illustrates how to take advantage of the new features available in the .NET Framework when working with data-centric applications. It covers:

  • The key classes and objects in ADO.NET and how to utilize them to access and manipulate data from SQL Server 2000
  • How to write and utilize efficient stored procedures, to reduce middle-tier code
  • Databinding methods for use in both Windows Forms and Web Form applications
  • Transactions and locking management
  • Transactions and object pooling

    If you are an experienced VB developer, capable of writing complex applications and comfortable with the use of T-SQL and stored procedures to manage data in SQL Server (version 7 or above), then this book will provide the practical knowledge you need to develop effective .NET data-centric applications.

  • Product Details

    ISBN-13:
    9781861007056
    Publisher:
    Apress
    Publication date:
    06/27/2002
    Edition description:
    2002
    Pages:
    564
    Product dimensions:
    0.00(w) x 0.00(h) x 0.05(d)

    Table of Contents

    Introduction1
    Who Is This Book For?3
    What You Need To Use This Book4
    Conventions4
    Customer Support5
    Chapter 1ADO.NET9
    History of Universal Data Access and ADO9
    ADO.NET The New World of Data Access11
    Summary24
    Chapter 2The SqlClient Namespace27
    SqlConnection Object27
    SqlCommand Object38
    SqlDataReader Object44
    SqlDataAdapter Object47
    DataSet Object56
    DataTable Object60
    DataRow Object67
    DataColumn Object72
    DataRelation79
    Summary87
    Chapter 3HR Sample Application89
    The HumanResources Database89
    HumanResources Project99
    Summary123
    Chapter 4Handling Streams of Data with ADO.NET125
    Introduction125
    Using a DataReader To Retrieve Data126
    Using a DataReader To Update Data137
    Populating Controls Using a DataReader139
    Summary142
    Chapter 5Writing Good Stored Procedures145
    Stored Procedures and Performance146
    Security146
    Executing Stored Procedures148
    Parameters in Stored Procedures151
    SELECT * Statements153
    Deferred Name Resolution153
    Joins155
    Temporary Tables162
    Cursors166
    Decision Making In-Line168
    Control of Flow172
    Passing Resultsets177
    Navigating Trees184
    Nesting Procedures186
    User-Defined Functions187
    Global Variables190
    Handling Errors193
    Summary200
    Chapter 6Using Stored Procedures in VB.NET203
    Creating Stored Procedures in VS.NET204
    DataReader207
    Multiple Resultsets209
    Passing Parameters212
    Return Parameters220
    Retrieving XML222
    Passing in XML224
    SQLXML226
    Summary236
    Chapter 7Data Binding239
    Introduction239
    Data Binding with Windows Forms240
    Data Binding with Web Forms256
    Summary267
    Chapter 8Transactions and Locking269
    The ACID Test270
    Implicit & Explicit Transactions271
    Using Transactions271
    Commands within Transactions282
    Transactions and Locks286
    Transaction Best Practices304
    Summary311
    Chapter 9Component Services313
    Serviced Components313
    Building Serviced Components314
    Object Pooling and Other COM+ Features330
    Summary332
    Chapter 10SQL Server and XML335
    For Xml Explicit336
    Transforming with Style357
    Stored Procedures As Web Services369
    Summary384
    Chapter 11Effective Administration for Developers387
    Managing Security388
    Monitoring SQL Server413
    Moving a Database431
    Generating Scripts436
    Summary439
    Chapter 12Case Study: IBankAdventure441
    Introduction441
    The IBankAdventure Database442
    IBankAdventure Business Objects456
    IBankAdventure User Interface472
    Where To Go From Here506
    Summary507
    Appendix AADO.NET Object Model509
    Command Classes509
    Connection Classes511
    DataAdapter Classes513
    DataColumn Class515
    DataColumnMapping Class517
    DataReader Classes518
    DataRelation Class521
    DataRow Class523
    DataSet Class525
    DataTable Class529
    DataTableMapping Class532
    DataView Class533
    DataViewManager Class535
    DataViewSetting Class536
    OleDbError Class537
    OleDbException Class538
    Parameter Classes539
    SqlError Class540
    SqlException Class541
    Transaction Classes542
    Index545

    Customer Reviews

    Average Review:

    Write a Review

    and post it to your social network

         

    Most Helpful Customer Reviews

    See all customer reviews >