Mastering Visual Basic .NET Database Programming (Paperback)

by Evangelos Petroutsos (Author), Asli Bilgin (Author) "THE FIRST CHAPTER IN a typical computer book is an introduction to the book's topic..." (more)
Key Phrases: shers table, visual database tools, thread delegate, End Sub, Server Explorer, Query Designer (more...)

Editorial Reviews

Product Description
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.

From the Publisher
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

See all Editorial Reviews

Product Details

• Paperback: 960 pages
• Publisher: Sybex (January 11, 2002)
• Language: English
• ISBN-10: 0782128785
• ISBN-13: 978-0782128789
• Product Dimensions: 9.1 x 7.5 x 1.5 inches
• Shipping Weight: 2.6 pounds
• Average Customer Review: 4.2 out of 5 stars See all reviews (19 customer reviews)
• Amazon.com Sales Rank: #479,865 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #47 in	Books > Computers & Internet > Programming > Languages & Tools > Visual Basic Introduction
  #94 in	Books > Computers & Internet > Microsoft > Development > Visual Basic > .Net

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

5.0 out of 5 stars Buy it for the XML chapters alone, April 2, 2002

By	Patricia Martins (South Boston, MA United States) - See all my reviews

When I picked up the book, I thought I would just be learning about how to design a database. As a seasoned programmer, I am not interested in information I can grab off the web. I was delighted to find so much un-documented information in this book. Instead of a dry, design your database manual, you get an around the world tour of almost every flavor of technology that surrounds data access. Chapters 10 and 12 are my all-around favorites - X/Path, XSL/T XML and the related technologies. I would like the authors to write a book just on XML alone. Another favorite topic of mine (which was again, very clearly explained): SQL Server access over HTTP. This was great information that I can definitely use in my systems today. A terrific book overall.

7 of 8 people found the following review helpful:

5.0 out of 5 stars One of the best books on .NET, April 2, 2002

By	Kimberly Musierowicz "Martymoose" (Atlanta, GA USA) - See all my reviews (REAL NAME)

Although the title indicates that this is a book purely about database programming, don't let it fool you. This book is filled with much more information than just database programming. You learn how to build ASP.NET applications, work with customized user controls in VB.NET. XML also gets a lot of coverage in this book and you learn, step-by-step how to build a custom XSL stylesheet. The authors walk you through building the template and XPath queries. XPath isn't an easy language, by any means, but the examples step you through from the simple to the complex, giving you indepth information along the way. Another thing that I was really surprised with was the fact that all the examples I've tried so far work. This is really surprising in a programming book, especially one that's written in time to be published right when .NET launched. I'm very impressed with the quality of the code, as well as the way this book is written.

16 of 21 people found the following review helpful:

3.0 out of 5 stars Mastering? What, exactly?, July 26, 2002

By	Stephen Oriold "Stephen Lone Wolf" (Baldwin Park, CA) - See all my reviews (REAL NAME)

First of all, the title is a bit pretentious.
Going through this book, you won't find much about as much as connecting to an Oracle, Sybase or db2 database. I guess, they are minor players in the eyes of the authors/publisher.

Secondly, coverage of development for the "Windows Forms" environment is very limited, compared to development for the browser and, generally, Net. You might not find out, how to map and bind fields in an Access database to a textbox on a "Windows Forms" form, but you will be able to create a shopping cart application.

Thirdly, a lot of space is dedicated to general notions, database theory and normalization (which, by the way, is much better covered in books dedicated to relational database theory), while a lot of info dedicated to XML was squeezed out of the book, to the CD only, or just completely missing (like hardcore info on working with Access).

If your database is SQL Server, and your playground is the Net, buy the book. Otherwise, check it out in the bookstore, and JUDGE FOR YOURSELF ...

The book itself, in material and workmanship, is somewhat flimsy, has a cheap feel to it, and is falling apart after about a month of casual use on a programmer's desk.