Microsoft ADO.NET (Core Reference) (PRO-Developer)

ISBN: 0735614237
EAN: 2147483647

Year: 2002
Pages: 104

Authors: David Sceppa

BUY ON AMAZON

Microsoft ADO.NET (Core Reference)
LOC
Acknowledgments
Introduction
Part I: Getting Started with Microsoft ADO.NET
Chapter 1: Overview of ADO.NET
Why a New Object Model?
The ADO.NET Object Model
Questions That Should Be Asked More Frequently
Chapter 2: Building ADO.NET Applications with the DataForm Wizard
Everyone Loves a Demo
Using the Data Form Wizard to Build a Data-Bound Form
Using the New Data-Bound Form
The Data Form Wizard as a Starting Point
Questions That Should Be Asked More Frequently
Part II: Getting Connected: Using a .NET Data Provider
Chapter 3: Connecting to Your Database
Using Connection Objects
Visual Studio .NET Design-Time Features
OleDbConnection Object Reference
Questions That Should Be Asked More Frequently
Chapter 4: Querying Your Database
Using Command Objects in Code
Creating Commands in Visual Studio .NET
Command, DataReader, and Parameter Object Reference
Questions That Should Be Asked More Frequently
Chapter 5: Retrieving Data Using Objects
What Is a DataAdapter Object?
Creating and Using DataAdapter Objects
Creating DataAdapter Objects in Visual Studio .NET
DataAdapter Reference
Questions That Should Be Asked More Frequently
Part III: Working with Data Off Line--The ADO.NET
Chapter 6: Working with Objects
Features of the DataSet Object
Using DataSet Objects
Working with DataSet Objects in Visual Studio .NET
DataSet, DataTable, DataColumn, DataRow, UniqueConstraint, and ForeignKeyConstraint Object Reference
Questions That Should Be Asked More Frequently
Chapter 7: Working with Relational Data
A Brief Overview of Relational Data Access
Working with DataRelation Objects in Code
Creating DataRelation Objects in Visual Studio .NET
DataRelation Object Reference
Questions That Should Be Asked More Frequently
Chapter 8: Sorting, Searching, and Filtering
Using the DataTable Object s Searching and Filtering Features
What Is a DataView Object?
Working with DataView Objects in Code
Creating DataView Objects in Visual Studio .NET
DataView Object Reference
Questions That Should Be Asked More Frequently
Chapter 9: Working with Strongly Typed Objects
Creating Strongly Typed DataSet Objects
Using Strongly Typed DataSet Objects
When to Use Strongly Typed DataSet Objects
Questions That Should Be Asked More Frequently
Chapter 10: Submitting Updates to Your Database
A History Lesson
Using ADO.NET Command Objects to Submit Updates
Using ADO.NET DataAdapter Objects to Submit Updates
Manually Configuring Your DataAdapter Objects
Using the CommandBuilder Object to Generate Updating Logic
Using the Data Adapter Configuration Wizard to Generate Updating Logic
Other Updating Concerns
OleDbCommandBuilder Object Reference
Questions That Should Be Asked More Frequently
Chapter 11: Advanced Updating Scenarios
Refreshing a Row After Submitting an Update
Retrieving Newly Generated Autoincrement Values
Using SQL Server s NOCOUNT Setting
Submitting Hierarchical Changes
Isolating and Reintegrating Changes
Handling Failed Update Attempts Elegantly
Working with Distributed Transactions
Questions That Should Be Asked More Frequently
Chapter 12: Working with XML Data
Bridging the Gap Between XML and Data Access
Reading and Writing XML Data
DataSet XmlDocument XmlDataDocument
Retrieving XML Data from SQL Server 2000
The SQL XML .NET Data Provider
A Simple ADO.NET and XML Sample
Questions That Should Be Asked More Frequently
Part IV: Building Effective Applications with ADO.NET
Chapter 13: Building Effective Windows-Based Applications
Building a User Interface Quickly Using Data Binding
Application Design Considerations
Questions That Should Be Asked More Frequently
Chapter 14: Building Effective Web Applications
Brief Introduction to Web Applications
Connecting to Your Database
Displaying Data on Your Web Page
Caching Data Between Round-Trips
Paging
Editing Data on a Web Page
Questions That Should Be Asked More Frequently
Part V: Appendixes
Appendix A: Using Other .NET Data Providers
The SQL Client .NET Data Provider
The ODBC .NET Data Provider
The Oracle Client .NET Data Provider
Common Cross-Provider Concerns
Appendix B: Tools
ADO.NET Ad Hoc Query Tool
ADO.NET DataAdapter Builder
ADO.NET Navigation Control