---

Database Access with Visual Basic .NET (3rd Edition)

ISBN: 0672323435
EAN: 2147483647

Year: 2003
Pages: 97

Authors: Jeffrey P. McManus, Jackie Goldstein

BUY ON AMAZON

• 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
• Summary
• Chapter 10. ADO.NET and XML
• Basic Reading and Writing of XML
• Creating an XmlReader from a Command Object
• The XmlDataDocument Object
• Summary
• Chapter 11. WebForms: Database Applications with ASP.NET
• An Overview of ASP.NET
• Accessing a Database Through ASP.NET
• Improving the Performance of ASP.NET Database Applications Through Stored Procedures
• Summary
• Chapter 12. Web Services and Middle-Tier Technologies
• Using the Middle Tier to Provide Presentation Logic
• Using Data in the Middle Tier
• Exposing Objects Through Web Services
• Putting It All Together
• Summary