Share
Create bookmark
Programming Microsoft® ADO.NET 2.0 Core Reference
Do you like this document?
Notes
Please login to add notes
- + Cover
- Contents at a Glance
- Table of Contents
- Acknowledgments
- + Introduction
-
+
Part I: Getting Started with Microsoft ADO.NET 2.0
-
+
Part II: Getting Connected: Using a .NET Data Provider
-
+
Chapter 3: Connecting to Your Database
- Creating SqlConnection Objects
- Opening SqlConnection Objects
- Closing SqlConnection Objects
- Cleaning Up After Yourself
- + Connection Strings
-
+
Connection Pooling
- Connection Handles and Physical Connections
- What Is Connection Pooling?
- How Connection Pooling Can Improve Your Code
- Enabling Connection Pooling
- When Will My Pooled Connection Be Closed?
- Disabling Connection Pooling
- Answering Your Own Questions About Connection Pooling
- How ADO.NET Determines Whether to Use a Pooled Connection
- Forcing ADO.NET to Use a New Pool
- Manually Releasing Pooled Connections
- What Other Pooling Options Do I Have?
- + Using the SqlConnection as a Starting Point
- + Visual Studio Design-Time Features
- + SqlConnection Object Reference
- Questions That Should Be Asked More Frequently
-
+
Chapter 4: Querying Your Database
-
+
Using SqlCommand Objects in Code
- Creating a SqlCommand Object
- Using a SqlCommand to Execute Queries
- Executing a Row-Returning Query
- Retrieving a Single Value
- Executing a Query That Does Not Return a Resultset
- Executing Batches of Action Queries
- Executing a Query to Retrieve XML Data
- Executing a Query in a Transaction
- Executing a Query Asynchronously
- + Working with the SqlDataReader
- + Working with Parameterized Queries
- + Microsoft Visual Studio Design-Time Features
- + Object Reference for SqlCommand, SqlDataReader, and SqlParameter
- Questions That Should Be Asked More Frequently
-
+
Using SqlCommand Objects in Code
-
+
Chapter 5: Retrieving Data Using SqlDataAdapter Objects
-
+
Chapter 3: Connecting to Your Database
-
+
Part III: Working with Data Offline—The ADO.NET DataSet
-
+
Chapter 6: Working with DataSet Objects
- + Features of the DataSet Class
-
+
Using DataSet Objects
- Creating a DataSet Object
- Examining the Structure Created by Calling SqlDataAdapter.Fill
- Examining the Data Returned by a SqlDataAdapter
- Validating Data in Your DataSet
- Creating DataTable Objects in Code
- Autoincrement Do’s and Don’ts
- Modifying the Contents of a DataTable
- ADO.NET 2.0 DataSet Serialization and Remoting Options
- + Working with DataSet Objects in Visual Studio
-
+
DataSet, DataTable, DataColumn, DataRow, UniqueConstraint, and ForeignKeyConstraint Class Reference
- Properties of the DataSet Class
- Methods of the DataSet Class
- DataSet, DataTables, and the ISupportInitializeNotification Interface
- Events of the DataSet Class
- Properties of the DataTable Class
- Methods of the DataTable Class
- Events of the DataTable Class
- Properties of the DataColumn Class
- Properties of the DataRow Class
- Methods of the DataRow Class
- Properties of the UniqueConstraint Class
- Properties of the ForeignKeyConstraint Class
- Questions That Should Be Asked More Frequently
-
+
Chapter 7: Working with Relational Data
-
+
Chapter 8: Sorting, Searching, and Filtering
- + Chapter 9: Working with Strongly Typed DataSet Objects and TableAdapters
-
+
Chapter 10: Submitting Updates to Your Database
- + Submitting Updates Using Parameterized SqlCommands
- Submitting Updates Using a SqlDataAdapter
- Using SqlDataAdapter Objects to Submit Updates
- + Manually Configuring Your SqlDataAdapter Objects
- + Using a SqlCommandBuilder to Generate Updating Logic
- + Using the Visual Studio TableAdapter Configuration Wizard to Generate Updating Logic
- + Return of the DataAdapters!
- + Submitting Updates in SqlTransactions
- + SqlCommandBuilder Object Reference
- Questions That Should Be Asked More Frequently
-
+
Chapter 11: Advanced Updating Scenarios
- + Refreshing a Row After Submitting an Update
- + Retrieving Newly Generated Auto-Increment Values
- + Submitting Hierarchical Changes
- + Isolating and Reintegrating Changes
- + Handling Failed Update Attempts
- + Working with Distributed Transactions
- + Batch Queries
- + SQL Bulk Copy
- + DataSet Objects and Transactions
- When Handling Advanced Updating Scenarios, Use ADO.NET
- 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
- + Using SQL Server 2005’s XML Features
- Retrieving XML Data from SQL Server 2000 via SELECT...FOR XML
- + The SQL XML .NET Data Provider
- + A Simple ADO.NET and XML Sample
- Questions That Should Be Asked More Frequently
-
+
Chapter 6: Working with DataSet Objects
-
+
Part IV: Building Effective Applications with ADO.NET 2.0
-
+
Chapter 13: Building Effective Microsoft Windows-Based Applications
-
+
Building a User Interface Quickly by Using Data Binding
- Step 1: Creating Your Strongly Typed DataSet
- Step 2: Adding Simple Bound Controls to the Form
- Step 3: Retrieving Data
- Step 4: Navigating Through the Results
- Step 5: Adding and Deleting Items
- Step 6: Submitting Changes
- Step 7: Adding Edit, Accept, and Reject Buttons
- Step 8: Viewing Child Data
- Step 9: Binding a Second Form to the Same Data Source
- Step 10: Improving the User Interface
- Step 11: If You Want Something Done (Just) Right...
- Data Binding Summary
- + Application Design Considerations
- Questions That Should Be Asked More Frequently
-
+
Building a User Interface Quickly by Using Data Binding
- + Chapter 14: Building Effective Web Applications
-
+
Chapter 15: SQL Server 2005 Common Language Runtime Integration
-
+
Chapter 13: Building Effective Microsoft Windows-Based Applications
-
+
Part V: Appendixes
- Index
- About the Author
Build your expertise as you move beyond the basics—and delve into the essential topics of programming with ADO.NET 2.0. This comprehensive reference offers expert guidance, hands-on instruction, and code samples in Microsoft Visual C# and Visual Basic to help advance your mastery of developing database applications for Microsoft Windows and the Web.
Discover how to:
Work with design-time data access features in Microsoft Visual Studio 2005
Use Microsoft .NET Framework 2.0 data providers to connect to databases
Build connection strings and enable connection pooling
Execute queries, including parameterized and asynchronous queries, and retrieve their results
Create DataSet objects to work with offline data and explore common usage scenarios
Use the new Common Language Runtime features and XML data type in Microsoft SQL Server 2005
Generate logic and use stored procedures for simple to advanced updating scenarios
Design Web applications with new data access features in ASP.NET 2.0—including code-free data-binding capabilities
PLUS—Get Visual Basic and C# code samples, and a Microsoft .NET Data Provider on the Web
Your free to read time expires in minutes. After that you have to pause for an hour.
Test the closed alpha on paperc.com
Book Details
Authors
Categories
Computers > Software development & engineering > General
Publishers
Publication year : 2009
License: All rights reserved ©
Times read: 17
