Flylib.com
Applied ADO.NET: Building Data-Driven Solutions
Applied ADO.NET: Building Data-Driven Solutions
ISBN: 1590590732
EAN: 2147483647
Year: 2006
Pages: 214
Authors:
David Talbot
,
Mahesh Chand
BUY ON AMAZON
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
Year: 2006
Pages: 214
Authors:
David Talbot
,
Mahesh Chand
BUY ON AMAZON
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Testing for No Records
Implementing Pessimistic Concurrency Without Using Database Locks
Using XSD Schema Files to Load and Save a DataSet Structure
Using a Single Stored Procedure to Update Multiple Changes to a SQL Server Database
Retrieving a Single Value from a Query
Software Configuration Management
Configuration Verification and Audit
CM Automation
Appendix D Problem Change Report
Appendix G Sample Inspection Plan
Appendix L Software Requirements Changes
An Introduction to Design Patterns in C++ with Qt 4
Part III: C++ Language Reference
Review Questions
public, protected, and private Derivation
Source Selector
Qt References
GO! with Microsoft Office 2003 Brief (2nd Edition)
Concepts Assessments
GO! with Help
Problem Solving
Objective 7. Create Table Relationships
Project 1A. Expansion
Comparing, Designing, and Deploying VPNs
Deploying Site-to-Site IPsec VPNs
MTU and Fragmentation Considerations in an IPsec VPN
Understanding IKE in an IPsec Remote Access VPN Environment
Designing and Building SSL Remote Access VPNs (WebVPN)
Microsoft Visual Basic .NET Programmers Cookbook (Pro-Developer)
Files and Directories
Multithreading
Reflection
Web Services
Useful COM Interop
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies