Flylib.com
Sams Teach Yourself ADO.NET in 24 Hours
Sams Teach Yourself ADO.NET in 24 Hours
ISBN: 0672323834
EAN: 2147483647
Year: 2002
Pages: 237
Authors:
Jason Lefebvre
,
Paul T. Bertucci
BUY ON AMAZON
Table of Content
Starting Page
Copyright
About the Authors
Acknowledgments
Tell Us What You Think
Introduction
Conventions Used in This Book
Hour 1. Introducing the Microsoft .NET Framework and ADO.NET
The Microsoft .NET Framework Class Library
What Is ADO.NET?
ADO.NET Versus ADO
The System.Data Namespace
The System.Data.SqlClient and System.Data.OleDb Namespaces
Installing the Microsoft .NET Framework
Summary
QA
Workshop
Hour 2. Working with DataSets and DataTables
Crash Course on Database Schema
DataSet Overview
Creating DataSet Schema
Adding and Removing Data
Summary
QA
Workshop
Hour 3. Using T-SQL: A Crash Course
Retrieving Data with SELECT
Adding New Data with INSERT
Modifying Data with UPDATE and DELETE
Using the Built-in SQL Functions
Summary
QA
Workshop
Hour 4. Adding Relationships to DataSets
Database Relationships and Constraints
The DataRelation Object
The DataSet Relations Collection
Summary
QA
Workshop
Hour 5. Connecting to a Data Source
The Connection Object
Connecting to Various Data Sources
ODBC (Open Database Connectivity)
Connection Pooling
Summary
QA
Workshop
Hour 6. Retrieving Data from the Data Source
The Command Object
Filling a DataSet with the DataAdapter
Retrieving a Single Value from the Database
Summary
QA
Workshop
Hour 7. Modifying Database Data
Using ExecuteNonQuery()
Summary
QA
Workshop
Hour 8. Using the DataReader and DataAdapter
DataReader Versus DataAdapter
Instantiating the DataReader
Binding DataReader Results to a Web Control
Stepping Through Data with the DataReader
Limitations of the DataReader
Summary
QA
Workshop
Hour 9. Binding Data to List Controls
Binding Data to Controls
Simple Data Binding in Windows Forms
Complex Data Binding in Windows Forms
Summary
QA
Workshop
Hour 10. Working with XML
What Is XML?
Reading XML
Creating a DataSet from an XML File
Serializing DataSets to XML
Using XmlReader
Summary
QA
Workshop
Hour 11. Using the Built-In ASP.NET List Controls
Some General Notes About List Controls
Working with the Repeater
Working with the DataGrid
Working with the DataList
Summary
QA
Workshop
Hour 12. Formatting ASP.NET List Controls
A Quick Overview of CSS
Formatting the Repeater
Formatting the DataList
Formatting the DataGrid
Summary
QA
Workshop
Hour 13. Handling ADO.NET Errors
Using Formal Error Handling (Ready,
Typical Errors to Handle
Using RowError of the DataSet
Summary
QA
Workshop
Hour 14. Managing ADO.NET Concurrency
Optimistic Versus Pessimistic Concurrency
Coding for Optimistic Concurrency
Comparing DataSet Values Against the Database for Optimistic Concurrency
Using a Timestamp for Optimistic Concurrency
XML and Optimistic Concurrency
Summary
QA
Workshop
Hour 15. Working with Stored Procedures
What Are Stored Procedures?
Executing a Stored Procedure
Using Parameters
Summary
QA
Workshop
Hour 16. ADO Upgrade Concerns
General Upgrade Issues from ADO to ADO.NET
Accessing an ADO Recordset from ADO.NET
Summary
Workshop
Hour 17. Using Connection Pooling
What Is Connection Pooling?
OLE DB .NET Data Provider
Summary
QA
Workshop
Hour 18. Working with Transactions
What Is a Transaction?
Transactions and ADO.NET
Transactions with Stored Procedures
Summary
QA
Workshop
Hour 19. Using Automatically Generated Commands
Automatically Generated Commands
Using the CommandBuilder
Summary
QA
Workshop
Hour 20. Working with Typed DataSets
The Typed DataSet
Generating a Typed DataSet
Typed DataSets in Visual Studio .NET
Summary
QA
Workshop
Hour 21. Optimizing Data Access Using Tiered Development
What Is Tiered Development?
Implementing Tiered Development
Creating Your Own Assembly
Summary
QA
Workshop
Hour 22. Modifying Data in an N-Tier Application
Updating Product Data
Adding Product Data
Summary
QA
Workshop
Hour 23. Optimizing Data Access
Optimizing ADO.NET Code
ASP.NET Tracing
Improving Your Queries with the SQL Query Analyzer
Simulating Application Traffic
Data Caching
Summary
QA
Workshop
Hour 24. Transmitting DataSets Using Web Services
Sending a DataSet Using Web Services
Consuming a DataSet from a Web Service
Summary
QA
Workshop
Appendix A.
Hour 1
Hour 2
Hour 3
Hour 4
Hour 5
Hour 6
Hour 7
Hour 8
Hour 9
Hour 10
Hour 11
Hour 12
Hour 13
Hour 14
Hour 15
Hour 16
Hour 17
Hour 18
Hour 19
Hour 20
Hour 21
Hour 22
Hour 23
Hour 24
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_Index
Y_Index
Sams Teach Yourself ADO.NET in 24 Hours
ISBN: 0672323834
EAN: 2147483647
Year: 2002
Pages: 237
Authors:
Jason Lefebvre
,
Paul T. Bertucci
BUY ON AMAZON
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Media Resource Management
Operating System Hardening
Hash Functions
Real-Time Monitoring Tool Overview
Report Scheduling
Visual C# 2005 How to Program (2nd Edition)
Connection-Oriented vs. Connectionless Communication
.NET Remoting
Generic Method Implementation
F.10. Nested and Ordered Lists
J.1. ATM Case Study Implementation
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Who this book is for
Case #1 background: RailCo Ltd.
Common tangible benefits of SOA
Web Services and Contemporary SOA (Part I: Activity Management and Composition)
Considerations for choosing service layers
Programming Microsoft ASP.NET 3.5
The ADO.NET Object Model
ASP.NET Mobile Controls
ASP.NET Security
Design-Time Support for Custom Controls
HTTP Handlers and Modules
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Fashion Logistics and Quick Response
Logistics in Tesco: Past, Present and Future
Temperature-Controlled Supply Chains
Transforming Technologies: Retail Exchanges and RFID
Enterprise Resource Planning (ERP) Systems: Issues in Implementation
Python Standard Library (Nutshell Handbooks) with
The _ _builtin_ _ Module
The traceback Module
The code Module
The xmllib Module
Overview
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