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

…  See more details below

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.

    Read More

  • 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
    Ch. 1Ado.Net9
    Ch. 2The SqlClient Namespace27
    Ch. 3HR Sample Application89
    Ch. 4Handling Streams of Data with ADO.NET125
    Ch. 5Writing Good Stored Procedures145
    Ch. 6Using Stored Procedures in VB.NET203
    Ch. 7Data Binding239
    Ch. 8Transactions and Locking269
    Ch. 9Component Services313
    Ch. 10SQL Server and XML335
    Ch. 11Effective Administration for Developers387
    Ch. 12Case Study: IBankAdventure441
    App. AADO.NET Object Model509
    Index545

    Read More

    Customer Reviews

    Average Review:

    Write a Review

    and post it to your social network

         

    Most Helpful Customer Reviews

    See all customer reviews >