- 1
- 2
- Main Page
- Main Page
- Table of content
- Copyright
- Preface
- Who This Book Is For
- How This Book Is Organized
- The Software Environment
- Keeping in Touch
- About the Authors
- About the Contributor
- About the Technical Reviewers
- Acknowledgments
- Chapter 1. Database Basics
- What Is a Database?
- Business Cases
- Tables and Fields
- Manipulating Data with Objects
- Data Types
- Creating a Database Schema
- Relationships
- Normalization
- Creating a User Interface in a Windows Forms Application
- Summary
- Chapter 2. Structured Query Language Queries and Commands
- What Is a Query?
- Testing Queries with the Server Explorer
- Retrieving Records with the SELECT Clause
- Designating a Record Source with the FROM Clause
- Specifying Criteria with the WHERE Clause
- Sorting Results with ORDER BY
- Displaying the Top or Bottom of a Range with TOP
- Joining Related Tables in a Query
- Performing Calculations in Queries
- Aliasing Field Names with AS
- Queries That Group and Summarize Data
- Union Queries
- Subqueries
- Manipulating Data with SQL
- Using Data Definition Language
- Summary
- Chapter 3. Getting Started with SQL Server 2000
- Setting Up and Running Microsoft SQL Server 2000
- Getting Started with SQL Server 2000: The Basics
- Summary
- Chapter 4. ADO.NETData Providers
- Overview of ADO.NET
- Overview of .NET Data Provider Objects
- The Connection Object
- The Command Object
- The DataReader Object
- Using the Connection and Command Design-Time Components
- Other Data Provider Objects
- Summary
- Chapter 5. ADO.NETThe DataSet
- Applications and Components of the DataSet
- Populating and Manipulating the DataSet
- Using the DataSet Component
- Summary
- Chapter 6. ADO.NETThe DataAdapter
- Populating a DataSet from a Data Source
- Updating the Data Source
- Summary
- Chapter 7. ADO.NETAdditional Features and Techniques
- Detecting Concurrency Conflicts
- Table and Column Mappings
- DataViews
- Strongly Typed DataSet s
- Summary
- Chapter 8. Visual Studio.NET Database Projects
- Creating a Database Project
- Database References
- Scripts
- Queries
- Summary
- Chapter 9. XML and .NET
- An Overview of XML
- XML Classes in .NET
- Extending SQL Server with SQLXML 3.0 and IIS
- Using XML, XSLT, and SQLXML to Create a Report
- 1
- 2
