| Database Access with Visual Basic® .NET, Third Edition |
| By Jeffrey P. McManus, Jackie Goldstein |
| | |
| Publisher | : Addison Wesley |
| Pub Date | : February 14, 2003 |
| ISBN | : 0-672-32343-5 |
| Pages | : 464 |
| 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.NET Data 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.NET The DataSet |
| | | | Applications and Components of the DataSet |
| | | | Populating and Manipulating the DataSet |
| | | | Using the DataSet Component |
| | | | Summary |
| |
| | | Chapter 6. ADO.NET The DataAdapter |
| | | | Populating a DataSet from a Data Source |
| | | | Updating the Data Source |
| | | | Summary |
| |
| | | Chapter 7. ADO.NET Additional Features and Techniques |
| | | | Detecting Concurrency Conflicts |
| | | | Table and Column Mappings |
| | | | DataViews |
| | | | Strongly Typed DataSets |
| | | | 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 |
| |