Programming Microsoft® SQL Server™ 2000 with Microsoft Visual Basic® .NET

Author Rick Dobson Pages 704 Disk 1 Companion CD(s) Level Int/Adv Published 05/29/2002 ISBN 9780735615359 ISBN-10 0-7356-1535-7 Price(USD) $59.99 To see this book's discounted price, select a reseller below.	More Information About the Book Table of Contents Sample Chapter Index Companion Content Related Series Related Books About the Author Support: Book & CD Rate this book

Chapter 10: Programming Windows Solutions with ADO.NET

• An Overview of ADO.NET Objects
• The Connection Class
• The Command Class
• The DataReader Class
• The DataAdapter Class
• The DataSet Class
• The DataView Class
• Making Connections
• Logging In with Integrated Security
• Logging In with SQL Server Security
• Catching SqlConnection Exceptions
• Connecting from a Windows Form
• Working with Command and DataReader Objects
• Displaying Results in a Message Box or the Output Window
• Displaying Rows in Blocks from a DataReader
• Invoking a Stored Procedure with a Parameter by a SQL String
• Invoking a Stored Procedure with a Parameter by Its Name
• Creating a Database Object with a Command Object
• DataAdapters, Data Sets, Forms, and Form Controls
• Adding a Data Set to a Form
• Binding Controls on a Form to Data
• Reporting DataBindings
• Using a Data Set with Tables in a Parent-Child Relationship
• Creating Data-Aware Forms
• Modifying, Inserting, and Deleting Rows
• The Data Manipulation Sample in Action
• Code Associated with the Form Load Event
• Code for the Navigation Buttons
• Code for the Modify Button
• Code for the Clear and Insert Buttons
• Code for the Delete Button

10   Programming Windows Solutions with ADO.NET

The chapter has five major sections.

• The chapter begins with a brief overview of ADO.NET design issues. This section drills down into the data set object model. This material will help you to programmatically coordinate data set objects with SQL Server database objects.
• Next the chapter presents programming samples for making a connection to a SQL Server database. This presentation also demonstrates how to secure access to your SQL Server databases. (See Chapter 7 for more on SQL Server security.)
• Coverage moves from making a connection to forward-only, read-only data access. Several samples reveal the flexibility you can achieve with this form of data access for displaying data. In addition, you learn how to dynamically configure the source that a DataReader object contains at run time.
• The next section introduces how to display data set objects with Windows Forms. It covers how to programmatically bind Windows Forms controls—such as text boxes, combo boxes, and data grids—to data set objects. You'll also learn how to display parent-child data relationships so that users can control the display of child data by manipulating a control for the parent data.
• The chapter concludes with a section that demonstrates how to update, insert, and delete rows in a SQL Server database from a Windows form.

All the samples throughout this chapter use the MyADODOTNETSamples solution. You can open the solution file (MyADODOTNETSamples.sln) in Visual Studio .NET. This chapter provides specific instructions for launching each sample from the solution. By following the instructions, you'll gain familiarity with how to start a Windows application from an element within a solution other than Form1— the default startup object.

Last Updated: May 31, 2002

Top of Page