Database Access with Visual Basic .NET (3rd Edition)
Database Access with Visual Basic .NET (3rd Edition)
ISBN: 0672323435
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 97
Pages: 97
Authors: Jeffrey P. McManus, Jackie Goldstein
- 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
Database Access with Visual Basic .NET (3rd Edition)
ISBN: 0672323435
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 97
Pages: 97
Authors: Jeffrey P. McManus, Jackie Goldstein