Database Access With Visual Basic .Net, 3e

DESCRIPTION

Whether 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 authors provide real-world solutions to the data-access issues Visual Basic .NET developers face every day and share their secrets for becoming a more effective database programmer using .NET technologies. 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 Visual Basic .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. A companion Web site provides the code used in the book's myriad examples, all of which is compatible with Visual Basic .NET 2003. 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 Database Access with Visual Basic? .NET, Third Edition, equips VB developers with the knowledge and skills needed to build a powerful new generation of database applications in less time using .NET technologies. Written for programmers familiar with Visual Basic .NET, this guide explains how to develop database applications for SQL server 2000 with ADO.NET. The author defines the properties and methods of the major ADO.NET objects, and demonstrates the use of Visual Studio database projects for managing SQL scripts, and the integration of XML with ADO.NET. The second edition was published as Database access with Visual Basic 6 in 1999 by Sams. Annotation ?2003 Book News, Inc., Portland, OR TABLE OF CONTENTS Preface Ch. 1 Database Basics 1 Ch. 2 Structured Query Language Queries and Commands 49 Ch. 3 Getting Started with SQL Server 2000 83 Ch. 4 ADO.NET - Data Providers 155 Ch. 5 ADO.NET - The DataSet 195 Ch. 6 ADO.NET - The DataAdapter 233 Ch. 7 ADO.NET - Additional Features and Techniques 265 Ch. 8 Visual Studio.NET Database Projects 293 Ch. 9 XML and .NET 317 Ch. 10 ADO.NET and XML 343 Ch. 11 WebForms: Database Applications with ASP.NET 389 Ch. 12 Web Services and Middle-Tier Technologies 411 Index 431