Applied ADO.NET: Building Data-Driven Solutions
Applied ADO.NET: Building Data-Driven Solutions
ISBN: 1590590732
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 214
Pages: 214
Authors: David Talbot, Mahesh Chand
- Table of Contents
- BackCover
- Applied ADO.NET - Building Data-Driven Solutions
- Introduction
- Chapter 2: Data Components in Visual Studio .NET
- Chapter 3: ADO.NET in Disconnected Environments
- Chapter 4: ADO.NET in Connected Environments
- Chapter 5: Handling ADO.NET Events
- Chapter 6: Integrating XML with ADO.NET
- Chapter 7: Data Binding and Windows Forms Data-Bound Controls
- Chapter 8: Constraints and Data Relations
- Chapter 9: ADO.NET Exception Handling
- Chapter 10: Working with the ODBC .NET Data Provider
- Chapter 11: Stored Procedures and Views
- Chapter 12: Oracle, SQLXML, and Other .NET Data Providers
- Chapter 13: Developing a Custom Data Provider
- Chapter 14: Developing Database Applications Using ASP.NET
- Chapter 15: Using ADO.NET in XML Web Services
- Chapter 16: ASP.NET Server Controls and Data Binding
- Chapter 17: Building Real-World Web Applications
- Chapter 18: Object-Relational Mapping in .NET
- Chapter 19: Mapped Objects: Performance Considerations and Data Binding
- Chapter 20: COM Interoperability with ADO.NET
- Chapter 21: Messaging
- Chapter 22: SQL Server and ADO.NET: Notes on Performance
- Appendix A: Relational Databases:Some Basic Concepts
- Appendix B: Commonly Used SQL Statements
- Appendix C: ADO.NET Frequently Asked Questions
- Chapter 1: ADO.NET Basics
- Overview of Microsoft Data Access Technologies
- What Is ADO.NET?
- Why ADO.NET Was Designed
- Advantages of ADO.NET
- Comparing ADO.NET and ADO
- Overview of ADO.NET Namespaces and Classes
- Understanding ADO.NET Components
- Writing ADO.NET Applications
- Creating a Simple ADO.NET Application
- Using a DataSet to Read Data
- Summary
- Chapter 2: Data Components in Visual Studio .NET
- Using the Server Explorer
- Using Visual Data Components
- Using DataSet and DataView Components
- Using the Data Form Wizard
- Summary
- Chapter 3: ADO.NET in Disconnected Environments
- Understanding the ADO.NET Architecture
- Exploring the ADO.NET Class Hierarchy
- Choosing a Data Provider
- Understanding ADO.NET Disconnected Classes
- Working with DataTables
- Using DataSet, DataView, and DataViewManager
- Summary
- Chapter 4: ADO.NET in Connected Environments
- Understanding the Generic Data Provider Model
- Importing a Namespace
- Exploring the System.SqlClient Namespace
- The Connection: Connecting to a Data Source
- The Command: Executing SQL Statements
- The DataReader: Walking through the Data
- The DataAdapter: Adapting to Your Environment
- CommandBuilder: Easing the Work of Programmers
- Staying within the Parameters
- The DataSet in Connected Environments
- The DataView in Connected Environments
- Summary
- Chapter 5: Handling ADO.NET Events
- Working with Connection Events
- Working with DataAdapter Events
- Working with DataSet Events
- Working with DataTable Events
- Working with XmlDataDocument Events
- Working with DataView and DataViewManager Events
- Summary
- Chapter 6: Integrating XML with ADO.NET
- Reading XML
- Understanding the XmlWriter Classes
- Using the XmlConvert Class
- Understanding the DOM Implementation
- Understanding Transformation and XSLT
- Using ADO.NET and XML Together
- Navigating in XML
- Working with Schemas
- Summary
- Chapter 7: Data Binding and Windows Forms Data-Bound Controls
- Working with Complex Data-Bound Controls
- The DataGrid: Super Data-Bound Control
- Summary
- Chapter 8: Constraints and Data Relations
- Understanding Data Relations
- Understanding the DataRelation and DataRelationCollection Objects
- Summary
- Chapter 9: ADO.NET Exception Handling
- Why Use Exception Handling?
- Understanding the Exception Classes
- Exception Handling in ADO.NET
- Summary
- Chapter 10: Working with the ODBC .NET Data Provider
- Accessing Access Databases
- Accessing MySQL Databases
- Accessing MySQL Databases
- Accessing Text File Databases
- Accessing Excel Databases
- Implementing Two .NET 1.1 Updates
- Summary
- Chapter 11: Stored Procedures and Views
- Understanding SQL Injection
- Working with Views
- Summary
- Chapter 12: Oracle, SQLXML, and Other .NET Data Providers
- Using the SQLXML and SQL XML .NET Data Providers
- Using a MySQL Database and the .NET Data Provider
- Summary
- Chapter 13: Developing a Custom Data Provider
- Overview of the Data Provider Interfaces
- Building a Custom Data Provider
- Debugging Your Custom Data Provider
- Summary
- Chapter 14: Developing Database Web Applications using ASP.NET
- Developing Your First ASP.NET Web Application
- Creating Your First ADO.NET Web Application
- Using ASP.NET Server-Side Controls
- Understanding Data Binding in ASP.NET
- Creating a Guest Book in ASP.NET
- Summary
- Chapter 15: Using ADO.NET in Xml Web Services
- Exploring Web Services and the .NET Framework Library
- Creating a Web Service in VS .NET
- Testing Your Web Service
- Creating the Web Service Consumer
- Summary
- Chapter 16: ASP.NET Server Controls and Data Binding
- Data Binding in Simple Web Forms Controls
- Data Binding in Complex Web Forms Controls
- Summary
- Chapter 17: Building Real-World Web Applications
- Understanding the Database Schema
- Developing the Online Job Board Application
- Improving and Modifying the Application
- Summary
- Chapter 18: Object-Relational Mapping in .NET
- Why Not Just Use a DataSet?
- Understanding Object Databases
- Why Object Relational Mapping?
- Creating the Basic Design of the Video Store Application
- Making Design Tradeoffs
- Summary
- Chapter 19: Mapped Objects: Performance Considerations and Data Binding
- Using Data Binding and Mapped Objects
- Understanding Problematic Master-Detail Relationships
- Working with Large Master-Detail Relationships
- Using a Near-Zero-Impact Caching Mechanism
- Summary
- Chapter 20: COM Interoperability and ADO.NET
- Exploring the .NET Interop Tools
- Using the ADO Recordset in ADO.NET
- Using ADOX with ADO.NET
- Accessing OLAP Server Data with ADO.NET
- Summary
- Chapter 21: Messaging
- Introducing Types of Queues
- Installing Message Queuing
- Using the System.Messaging Namespace
- Working with Message Queues
- Creating a Sample Application
- Working with Messages
- Understanding Transactional Messaging
- Encrypting Messages
- Summary
- Chapter 22: SQL Server and ADO.NET: Notes on Performance
- Understanding ADO.NET Performance Issues and Using Best Practices
- Summary
- Appendix A: Relational Databases: Some Basic Concepts
- Understanding Normalization
- Introducing Sets, Cursors, and ADO.NET
- Using Locking
- Summary
- Appendix B: Commonly Used SQL Statements
- Understanding Views
- Using SQL Server s SELECT...FOR XML Clause
- Summary
- Appendix C: ADO.NET Frequently Asked Questions
- Summary
- Index
- Index_A
- Index_B
- Index_C
- Index_D
- Index_E
- Index_F
- Index_G
- Index_H
- Index_I
- Index_J
- Index_K
- Index_L
- Index_M
- Index_N
- Index_O
- Index_P
- Index_Q
- Index_R
- Index_S
- Index_T
- Index_U
- Index_V
- Index_W
- Index_X
- List of Figures
- List of Tables
- List of Listings
- List of Sidebars
Applied ADO.NET: Building Data-Driven Solutions
ISBN: 1590590732
EAN: 2147483647
EAN: 2147483647
Year: 2006
Pages: 214
Pages: 214
Authors: David Talbot, Mahesh Chand
- Using SQL Data Definition Language (DDL) to Create Data Tables and Other Database Objects
- Using SQL Data Manipulation Language (DML) to Insert and Manipulate Data Within SQL Tables
- Using Keys and Constraints to Maintain Database Integrity
- Working with Functions, Parameters, and Data Types
- Understanding Transaction Isolation Levels and Concurrent Processing