Book Excerpt: Database Access with Visual Basic.NET, 3rd Edition

hether you are using WinForms, WebForms, or Web services, Database Access with Visual Basic.NET, Third Edition, is your practical guide to developing database applications with Visual Basic.NET and ADO.NET. The book begins by reviewing the fundamentals of database development, Structured Query Language (SQL), and Microsoft SQL Server 2000. It then examines how to use the major ADO.NET objects to access data stored in relational databases.

Through detailed examples, readers learn how to use properties and methods, as well as more advanced features and techniques. Extensive code listings in VB.NET illustrate each concept, while business cases apply concepts to real-world applications. The final chapters provide a solid examination of how XML and ASP.NET integrate with ADO.NET to create various types of database applications.

Key topic coverage includes:

  • SQL queries and commands
  • Using SQL Server 2000
  • ADO.NET objects
  • Advanced ADO.NET features and techniques
  • SQL Server and OLEDB, as well as ODBC .NET Data Providers
  • Using Visual Studio.NET Data Projects for managing SQL Scripts
  • Integrating XML with ADO.NET
  • Developing Web-based database applications with ASP.NET
  • Web services and middle-tier objects
  • Chapter 8: “Visual Studio.NET Database Projects” discusses creating a database project, database references, creating, changing, and running scripts, command files, and queries.

    Download the PDF of Chapter 8: “Visual Studio.NET Database Projects”

    Reproduced from Database Access with Visual Basic.NET, 3rd Edition by permission of Addison-Wesley. ISBN 0672323435, copyright 2003. All rights reserved.

    Share the Post:
    Share on facebook
    Share on twitter
    Share on linkedin

    Overview

    The Latest

    microsoft careers

    Top Careers at Microsoft

    Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

    your company's audio

    4 Areas of Your Company Where Your Audio Really Matters

    Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

    chrome os developer mode

    How to Turn on Chrome OS Developer Mode

    Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS