Table of content
|
Sams Teach Yourself ADO. NET in 24 Hours Authors: Lefebvre J., Bertucci P. Published year: 2002 Pages: 1/237 |
 |
- Table of Content
- 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?
|
Sams Teach Yourself ADO. NET in 24 Hours Authors: Lefebvre J., Bertucci P. Published year: 2002 Pages: 1/237 |
|