Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Table of content
Sams Teach Yourself ADO. NET in 24 Hours
Authors:
Lefebvre J.
,
Bertucci P.
Published year: 2002
Pages: 1/237
Buy this book on amazon.com >>
1
2
3
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?
1
2
3
Sams Teach Yourself ADO. NET in 24 Hours
Authors:
Lefebvre J.
,
Bertucci P.
Published year: 2002
Pages: 1/237
Buy this book on amazon.com >>
Book categories
Computers & Technology
Business & Culture
Programming
Software Design, Testing & Engineering
Object-Oriented Design (173)
Networking
Networks, Protocols & APIs (394)
Network Administration (121)
Microsoft
Networking (174)