book

Microsoft® ADO.NET 2.0 Step by Step, 2nd Edition

Name: Microsoft® ADO.NET 2.0 Step by Step, 2nd Edition
Author: Rebecca M. Riordan
ISBN: 9780735621640

by Rebecca M. Riordan

December 2005

Beginner

528 pages

13h 10m

English

Microsoft Press

Read now

Unlock full access

Microsoft® ADO.NET 2.0 Step by Step
A Note Regarding Supplemental Files
Introduction
Who Is This Book For?The Organization of This BookFinding Your Best Starting Point in This BookConventions and Features in This BookSystem RequirementsCode SamplesInstalling the Code SamplesAttaching the AdoStepByStep DatabaseUsing the Code SamplesUninstalling the Code Samples—Read!Prerelease SoftwareOnline Companion ContentSupport for This BookQuestions and Comments
I. Getting Started with ADO.NET
1. Getting Started with ADO.NET
On the Fundamental Interconnectedness of All ThingsA margin note like this points you to the discussion of a property or method that hasn't yet been introduced.A margin note like this points you to the discussion of a property or method that hasn't yet been introduced.A margin note like this points you to the discussion of a property or method that hasn't yet been introduced.The ADO.NET Object ModelData ProvidersConnections are discussed in detail in Chapter 2.Connections are discussed in detail in Chapter 2.We'll discuss Command objects in detail in Chapter 3.DataReaders are the subject of Chapter 4.We'll discuss adapters in Chapters Chapters 5 and 8.DataSetsDataSets and their component collections are the subject of Chapters 7 and 8DataSets and their component collections are the subject of Chapters 7 and 8.The DataTableCollection ObjectWe'll discuss DataColumns in Chapter 7.We'll discuss DataRows in Chapter 8.We'll discuss Constraints in Chapter 7.The DataRelationCollection ObjectWe'll discuss DataRelations in Chapter 7.Creating a Simple Data-Bound FormConfiguring a Data SourceUsing the Data Sources WindowWe'll discuss the BindingNavigator in Chapter 13.Summary
II. Data Provider Objects
2. Using Connections
Understanding ConnectionsCreating ConnectionsCreating Connections at Design TimeCreating Connections at Run TimeConfiguring ConnectionsThe ConnectionString PropertyStoring the ConnectionString in the Application Configuration FileUsing Other Connection PropertiesBinding Connection Properties to Form ControlsConnection MethodsWe'll examine transaction processing in Chapter 6.We'll examine transaction processing in Chapter 6.We'll examine transaction processing in Chapter 6.We'll examine Data Commands in Chapter 3.Opening and Closing ConnectionsWe'll examine the DataAdapter in Chapter 4 and the TableAdapter in Chapter 8.Controlling Connection PoolingConnection EventsStateChange EventsInfoMessage EventsSummary
3. Using Data Commands and DataReaders
Understanding Data CommandsWe'll discuss DataAdapters in Chapter 4 and TableAdapters in Chapter 8.We'll discuss DataAdapters in Chapter 4 and TableAdapters in Chapter 8.We'll discuss DataAdapters in Chapter 4 and TableAdapters in Chapter 8.Creating Data CommandsCreating Data Commands at Design TimeCreating Connections at Run TimeWe'll discuss the version of the Data Command constructor that supports transactions in Chapter 7.We'll discuss the version of the Data Command constructor that supports transactions in Chapter 7.Configuring Data CommandsWe'll discuss the Transaction property in Chapter 7.We'll discuss the Transaction property in Chapter 7.We'll discuss the Transaction property in Chapter 7.See Chapter 7 for more information.We'll examine the DataAdapter in Chapter 5 and the DataRow in Chapter 7.Setting Command Properties at Design TimeSetting Command Properties at Run TimeUsing the Parameters CollectionConfiguring the Parameters Collection at Design TimeAdding and Configuring Parameters at Run TimeSetting Parameter ValuesCommand MethodsWe'll discuss DataReaders in Chapter 4 and XMLReaders in Chapter 18.We'll discuss DataReaders in Chapter 4 and XMLReaders in Chapter 18.We'll discuss DataReaders in Chapter 4 and XMLReaders in Chapter 18.Executing CommandsUnderstanding DataReadersWe'll discuss DataSets in Chapter 6.We'll discuss DataSets in Chapter 6.We'll discuss DataSets in Chapter 6.Creating DataReadersCreating DataReaders at Run TimeDataReader PropertiesRetrieving DataReader PropertiesDataReader MethodsThe Read MethodSummary
4. Using DataAdapters
Understanding DataAdaptersWe'll discuss DataSets in detail in Chapter 6.We'll discuss DataSets in detail in Chapter 6.We'll discuss DataSets in detail in Chapter 6.We'll discuss TableAdapters in Chapter 8.Creating DataAdaptersCreating DataAdapters at Design TimeCreating DataAdapters at Run TimePreviewing ResultsConfiguring DataAdaptersWe'll examine the AcceptChanges method in Chapter 10.We'll examine the AcceptChanges method in Chapter 10.We'll examine the AcceptChanges method in Chapter 10.We'll examine DataRows in Chapter 7 and the RowError property in Chapter 10.We'll examine DataRows in Chapter 7 and the FillLoadOption in Chapter 10.DataAdapter CommandsThe DataTableMappingCollectionUsing DataAdapter MethodsThe Fill MethodThe Update MethodResponding to DataAdapter EventsThe RowUpdating EventThe RowUpdated EventSummary
5. Transaction Processing in ADO.NET
Understanding TransactionsUsing TransactionsCreating TransactionsCreating Transactions at Run TimeCreating Nested TransactionsCommitting and Rolling Back TransactionsSummary

III. Data Provider Objects
6. Modeling a Database by Using DataSets and DataRelations
Understanding DataSetsWe'll discuss DataTables, DataRows and DataColumns in detail in Chapter 7.We'll discuss DataTables, DataRows and DataColumns in detail in Chapter 7.We'll discuss DataTables, DataRows and DataColumns in detail in Chapter 7.Creating DataSetsWe'll discuss TableAdapters in detail in Chapter 8.We'll discuss TableAdapters in detail in Chapter 8.We'll discuss TableAdapters in detail in Chapter 8.Creating Typed DataSetsCreating Untyped DataSetsConfiguring DataSetsWe'll examine the DataSet's XML-related methods in Chapter 19.We'll examine the DataSet's XML-related methods in Chapter 19.We'll examine the DataSet's XML-related methods in Chapter 19.The DataSet Tables CollectionUsing DataSet MethodsWe'll examine the methods used to up-date data in Chapter 10.We'll examine the methods used to up-date data in Chapter 10.We'll examine the methods used to up-date data in Chapter 10.Cloning a DataSetCreating DataTableReadersUnderstanding DataRelationsCreating DataRelationsConfiguring DataRelationsWe'll discuss XML in Chapters 18 and 19.We'll discuss XML in Chapters 18 and 19.We'll discuss XML in Chapters 18 and 19.Summary
7. Using DataTables
Understanding DataTablesCreating DataTablesCreating DataTables by Using the DataSet DesignerWe'll examine TableAdapters in Chapter 8.We'll examine TableAdapters in Chapter 8.Creating Independent DataTables at Run TimeCreating DataSet DataTables at Run TimeCreating DataTables by Using a DataAdapterConfiguring DataTablesWe'll discuss DataViews in Chapter 9.We'll discuss DataViews in Chapter 9.We'll discuss DataViews in Chapter 9.Primary Key ConstraintsCreating DataColumnsCreating DataColumns by Using the DataSet DesignerCreating DataColumns at Run TimeConfiguring DataColumnsCreating Calculated ColumnsAdding ConstraintsForeignKeyConstraintsUniqueConstraintsCreating DataRowsConfiguring DataRowsWe'll discuss the RowState property in detail in Chapter 10.We'll discuss the RowState property in detail in Chapter 10.We'll discuss the RowState property in detail in Chapter 10.Using DataTable MethodsThe Select MethodUsing DataRow MethodsResponding to DataTable EventsSummary
8. Using TableAdapters
Understanding TableAdaptersCreating TableAdaptersCreating TableAdapter ClassesCreating TableAdapter ObjectsConfiguring TableAdaptersConfiguring TableAdapter ClassesConfiguring TableAdapter ObjectsUsing TableAdapter MethodsExecuting Query MethodsSummary
9. Using DataViews
Understanding DataViewsWe'll examine Data Binding in Chapters 12 and 14.We'll examine Data Binding in Chapters 12 and 14.We'll examine Data Binding in Chapters 12 and 14.Creating DataViewsCreating DataViews at Design TimeCreating DataViews at Run TimeConfiguring DataViewsDataColumn ExpressionsSort ExpressionsThe RowState FilterUsing DataView MethodsThe Find MethodSummary
IV. Manipulating Data
10. Editing and Updating Data
Understanding the Editing and Updating ProcessWe'll examine data binding later in Part IV.We'll examine data binding later in Part IV.We'll examine data binding later in Part IV.Understanding DataRowStates and VersionsThe RowState PropertyRow VersionsEditing Data in a DataSet Under Program ControlWe'll discuss editing using data-bound controls later in Part IV.We'll discuss editing using data-bound controls later in Part IV.We'll discuss editing using data-bound controls later in Part IV.Adding a DataRowDeleting a DataRowChanging DataRow ValuesDeferring Changes to DataRow ValuesUpdating Data SourcesUpdating the Data Source by Using an AdapterUpdating the Data Source by Using a Data CommandAccepting and Rejecting DataSet ChangesThe AcceptChanges MethodThe RejectChanges MethodSummary
11. Manual Data Binding in Windows Forms
Understanding Data Binding in Windows FormsBinding Controls to an ADO.NET Data SourceSimple-Binding Control Properties in Visual StudioSimple-Binding Control Properties at Run TimeWe'll examine the code that implements these buttons later in this chapter.We'll examine the code that implements these buttons later in this chapter.We'll examine the code that implements these buttons later in this chapter.Complex-Binding Control PropertiesWe'll examine the use of the ValueMember property to create look-up tables in Chapter 13.We'll examine the use of the ValueMember property to create look-up tables in Chapter 13.We'll examine the code that implements these buttons later in this chapter.Understanding the BindingContext ObjectUnderstanding the CurrencyManager ObjectThe Position PropertyCurrencyManager MethodsWe'll examine the SuspendBinding and ResumeBinding methods in Chapter 13.We'll examine the SuspendBinding and ResumeBinding methods in Chapter 13.Responding to CurrencyManager EventsThe ItemChanged EventUnderstanding the Binding ObjectConfiguring the Binding ObjectThe BindingMemberInfo PropertyUsing Binding Object MethodsResponding to Binding Object EventsWe'll examine the Format and Parse events in Chapter 13.We'll examine the Format and Parse events in Chapter 13.We'll examine the Format and Parse events in Chapter 13.Summary
12. Data Binding in Windows Forms by Using the BindingSource Component
Understanding the BindingSourceCreating BindingSource ComponentsCreating BindingSource Components at Design TimeCreating BindingSource Components at Run TimeConfiguring BindingSource ComponentsDataSource and DataMember PropertiesSort and Filter PropertiesUsing BindingSource MethodsPosition MethodsAdd and AddNew MethodsResponding to BindingSource EventsThe PositionChanged EventSummary
13. Using ADO.NET in Windows Forms
Using the BindingNavigator to Navigate Through DataDisplaying Data in Windows ControlsSimplifying Data EntryDisplaying User-Comprehensible ValuesWorking with DataRelationsFormatting DataCustom Format StringsThe Format and Parse EventsUsing the Format EventUsing the Parse EventFinding DataFinding Data by Using the Add Query Dialog BoxFinding Data by Using the BindingSourceFinding a Row in a DataViewFinding a Row in a DataTableValidating Data in Windows FormsData Change EventsColumn Change EventsControl Validation EventsUsing the ErrorProvider ComponentBinding an ErrorProvider to a Form ControlBinding an ErrorProvider to a Data SourceSummary
14. Basic Data Binding in Web Forms
Understanding Data Binding in Web FormsWe'll examine Data Source controls and the Web server controls designed to work with them in Chapter 15.We'll examine Data Source controls and the Web server controls designed to work with them in Chapter 15.We'll examine Data Source controls and the Web server controls designed to work with them in Chapter 15.Simple-Binding Web Controls to an ADO.NET Data SourceWe'll discuss data-bound controls in detail in Chapter 15.We'll discuss data-bound controls in detail in Chapter 15.We'll discuss data-bound controls in detail in Chapter 15.Setting Control Properties ExplicitlySetting Control Properties by Using DataBinder.EvalUsing Data-Binding ExpressionsComplex-Binding Web ControlsMaintaining ADO.NET Object StateMaintaining ADO.NET Objects on the ServerMaintaining ADO.NET Objects on the PageImplementing NavigationUpdating an Underlying Data SourceUsing a Command ObjectUsing an AdapterSummary
15. Data Binding in Web Forms by Using the Data Source Component
Understanding the Data Source ComponentCreating Data Source ComponentsCreating Data Source Components at Design TimeCreating Data Source Components at Run TimeConfiguring Data Source ControlsConnection PropertiesCommand PropertiesCommand ParametersSetting Connection and Command Properties at Design TimeConfiguration PropertiesCaching PropertiesUsing Data Source MethodsResponding to Data Source EventsSummary
16. Data-Bound and Validation Controls
Understanding Data-Bound ControlsData-Binding PropertiesUnderstanding List ControlsCreating List ControlsConfiguring List ControlsUsing List Control MethodsResponding to List Control EventsUnderstanding Template-Based ControlsTemplate TypesAdding Templates to Template-Based ControlsBinding Controls Within a TemplateUnderstanding DataControlFieldsConfiguring DataControlFieldsThe CommandField DataControlFieldThe TemplateField DataControlFieldUnderstanding Validation ControlsSummary
V. ADO.NET and Other Types of Data
17. Reading and Writing XML
Understanding XML SchemasUnderstanding ADO.NET and XMLWe'll examine the XmlDataDocument in Chapter 18.We'll examine the XmlDataDocument in Chapter 18.We'll examine the XmlDataDocument in Chapter 18.Using the DataSet XML MethodsThe GetXml and GetXmlSchema MethodsThe ReadXmlSchema MethodThe InferXmlSchema MethodThe ReadXml MethodThe WriteXmlSchema MethodThe WriteXml MethodControlling How XML Is WrittenThe Nested Property of the DataRelationControlling Column MappingSummary
18. The XmlDataDocument
Understanding the XmlDataDocumentCreating XmlDataDocumentsNavigating an XML DocumentNavigating a DataSet by Using the DOMNavigating a DataSet by Using XPathUsing XmlDataDocument MethodsManipulating DataRows by Using XMLCoordinating DataRows and XmlDataDocument ElementsSummary
19. Using ADO and ADOX in the .NET Framework
Understanding COM InteroperabilityUnderstanding ADO in the .NET FrameworkEstablishing a Reference to ADOCreating ADO ObjectsThe ADO Connection ObjectUsing ADO RecordsetsFilling ADO RecordsetsUpdating ADO RecordsetsUnderstanding ADOX in the .NET FrameworkCreating Database Objects by Using ADOXSummary
Index
About the Author
Copyright

Overview

The popular, learn-by-doing tutorial-rewritten for the latest version of Microsoft ADO.NET. Teach yourself core capabilities and essential techniques, and build working components and applications for Microsoft Windows®.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

Publisher Resources

ISBN: 0735621640Errata

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills