Mastering Visual Basic .NET Database Programming

Regardless of your level of experience with database programming, you will gain insight into the world of .NET by reading Mastering Visual Basic.NET Database Programming. This book is a hands-on guide that provides you with both the architecture and code for writing applications that work with SQL Server 2000 systems. You will learn best practices at constructing a distributed system using VB.NET.This book will help you understand the .NET database technologies and show you how they all fit together in a way that will enable you to architect .NET WebServices, Windows, and ASP.NET applications. There are also many satellite technologies that surround database systems. This book delves into working with all these languages and tools, such as XSL Transformations, XPath Queries, accessing SQL Server 2000 using HTTP and XML, the VS .NET XML Designer, ADO.NET and the .NET data providers. By taking an around-the-world tour of all these technologies, you will better be able to design your systems to take full advantage of the leading-edge technologies and tools. The information provided in this book will enable you to reduce the cost of delivery and increase your productivity using the .NET Framework.The explanations provided in this book are very crisp and concise. You'll get a clear understanding of how to build your own VB.NET database systems by following step-by-step walkthroughs or loading the actual Visual Studio .NET solutions from the accompanying CD. Enter a New World of Database Programming Visual Basic.NET and ADO.NET facilitate the development of a new generation of database applications, including disconnected applications that run on the Web. Mastering Visual Basic.NET Database Programming is the resource you need to thrive in this new world. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle-tier implementation. If you're familiar with earlier versions of ADO, you'll master the many new features of ADO.NET all the more quickly. You'll also learn the importance of XML within the new.NET paradigm. Coverage includes: Getting familiar with the ADO.NET object model Using the data access wizards Taking advantage of new SQL Server 2000 features Carrying out XSL Transformations and XPath queries Generating XML using the T-SQL FOR XML statement Binding controls to ADO.NET result sets Arriving at a sound database design Tuning your SQL Server 2000 database Using the XML Designer in Visual Studio.NET Leveraging the data access tools available in the Visual Studio.NET IDE Working with.NET data providers Choosing between streaming data and caching data Working with the Data Form Wizard in Visual Studio.NET Using advanced ADO.NET techniques Building a threaded application Using.NET's advanced exception handling capabilities Using the.NET Deployment Project Template Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. Enter a New World of Database Programming Visual Basic .NET and ADO.NET facilitate the development of a new generation of database applications, including disconnected applications that run on the Web. Mastering Visual Basic .NET Database Programming is the resource you need to thrive in this new world. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle-tier implementation. If you're familiar with earlier versions of ADO, you'll master the many new features of ADO.NET all the more quickly. You'll also learn the importance of XML within the new .NET paradigm. Coverage includes: Getting familiar with the ADO.NET object model
Using the data access wizards
Taking advantage of new SQL Server 2000 features
Carrying out XSL Transformations and XPath queries
Generating XML using the T-SQL FOR XML statement
Binding controls to ADO.NET result sets
Arriving at a sound database design
Tuning your SQL Server 2000 database
Using the XML Designer in Visual Studio .NET
Leveraging the data access tools available in the Visual Studio .NET IDE
Working with .NET data providers
Choosing between streaming data and caching dataWorking with the Data Form Wizard in Visual Studio .NET
Using advanced ADO.NET techniques
Building a threaded application
Using .NET's advanced exception handling capabilities
Using the .NET Deployment Project Template
Enter a New World of Database Programming Visual Basic .NET and ADO.NET facilitate the development of a new generation of database applications, including disconnected applications that run on the Web. Mastering Visual Basic .NET Database Programming is the resource you need to thrive in this new world. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle-tier implementation. If you're familiar with earlier versions of ADO, you'll master the many new features of ADO.NET all the more quickly. You'll also learn the importance of XML within the new .NET paradigm. Coverage CD-ROM/DVD and other supplementary materials are not included as part of eBook file. Annotation A special "essential skills" section at the front of this book gives readers a visual reference to core VB.NET database programming tasks. The CD-ROM contains all sample code from the book with a collection of sample database applications reader for users to implement in their own .NET applications Explains how to use the programming language to create interfaces, automate programming, develop applications, and manipulate records and reports within the Web-based Microsoft.Net framework.