Sams Teach Yourself ADO.NET in 24 Hours
Sams Teach Yourself ADO.NET in 24 Hours
ISBN: 0672323834
EAN: 2147483647
EAN: 2147483647
Year: 2002
Pages: 237
Pages: 237
Authors: Jason Lefebvre, Paul T. Bertucci
- 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
EAN: 2147483647
Year: 2002
Pages: 237
Pages: 237
Authors: Jason Lefebvre, Paul T. Bertucci