Beginning VB 2005 Databases: From Novice to Professional

Overview

Beginning Visual Basic 2005 Databases teaches you everything you need to know about relational databases, SQL, and ADO.NET 2.0, giving you a sound start in developing console and Windows database applications. The book also includes chapters on the new SQL Server XML data type and the forthcoming LINQ enhancements to the next version of Visual Basic.

In addition to teaching you database basics like using SQL to communicate with databases, this book provides you with detailed, ...

See more details below
Paperback
$30.80
BN.com price
(Save 22%)$39.99 List Price
Other sellers (Paperback)
  • All (9) from $22.00   
  • New (5) from $25.25   
  • Used (4) from $22.00   
Sending request ...

Overview

Beginning Visual Basic 2005 Databases teaches you everything you need to know about relational databases, SQL, and ADO.NET 2.0, giving you a sound start in developing console and Windows database applications. The book also includes chapters on the new SQL Server XML data type and the forthcoming LINQ enhancements to the next version of Visual Basic.

In addition to teaching you database basics like using SQL to communicate with databases, this book provides you with detailed, code-practical techniques to access data in VB 2005 across a range of coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 2.0 and offers you the best contemporary practice in this core programming area, so that youll find yourself using it in nearly all your .NET projects.

Read More Show Less

Product Details

Meet the Author

Jacob Hammer Pedersen started programming in the early 1990s, moving gradually from Pascal to C++ to Visual Basic. In the summer of 2000, he discovered C# and has explored it happily ever since.

Ranga Raghuram has a bachelor's degree in engineering from Birla Institute of Technology and Science in Pilani, India, and a master's degree from Virginia Tech.

Jon Reid was editor for the C++ and Object Query Language components of the Object Data Management Group standard, and has co-authored several C# books.

James Huddleston has worked with computers since 1974, specializing in database design and development since 1980. He has a bachelor's degree in Latin and Greek from the University of Pennsylvania and a juris doctor degree from the University of Pittsburgh. A technical reviewer of dozens of computer books, including Beginning C# Objects: From Concepts to Code, he finds databases an endlessly fascinating area of work and almost as intellectually rewarding as his hobby: translating Homer's Iliad and Odyssey from the original Greek.

Syed Fahad Gilani has more than 15 years of experience in computing. He sold his first program at the age of 10.

Scott Allen has a master's degree in computer science from Shippensburg University of Pennsylvania. He's a Microsoft Certified Solution Developer, and�regularly serves as an adjunct faculty member at various colleges in Maryland and Pennsylvania.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted April 17, 2007

    Beginning VB2005 Databases from Novice to Professional - a review by James L Szatkowski, PE, NSPE

    I am very impressed with the detail in the first two chapters. This is the area where a lot of beginning texts leave out. What are the tools 'exactly' and where to get them, how to install them and how to configure them to work with the examples in subsequent chapters. The text does an excellent job of pointing the reader to the correct 'for now' Microsoft web sites to download and install the applications and even uses good screen shots to add clarity. I had one issue with a MSXML section not being included, however that was quickly remedied on the Microsoft website. I'd recommend that readers keep the Feature Pack for MSSQL Server 2005 page at [URL REMOVED PER B&N - GOTO MICROSOFT] handy for future reference. Some of these features don't work with the Express versions, but others do and it's a pretty complete resource. Another note for the reader is that each 'instance' of installation for these packages should be 'needs to be' separately registered. So even though they're free 'for now', if you install on multiple machines you should do multiple registrations. One step in the Chapter 2 on connecting to a database offers several warnings, but it's not clear to me what the warnings mean - see step 10 on page 26. Subsequent experiments with the examples made it clear - it's Step 11. Selecting the Initial Catalog property is the important point here. Another quick point is that if you mess up the database, the recovery is described in the Summary of the second Chapter. However, it neglects to tell you that you have to delete 'or move or rename' the existing database with the problems before you can put it back in - I figured out by trial and error. Chapter 3 on Basic SQL commands is an excellent course in itself. A perfect work-through, with the provided examples, using SSMSE tool. I enjoyed the development of the statement vs query terminology. It might have been helpful though, to add an example of a statement, such as 'USE NORTHWIND'. This is also where I noted that the only place the USE command is issued is in Chapter 1 where we were working with SQLCMD. I little development of why we're not using it with SSMSE might help the beginner understand when one has to use USE. Obviously, in SSMSE, we've 'selected' the database we're using by the connection to it. In a VB project though, a reader might actually connect to multiple databases - beyond the scope of this text, but addressing it would be appropriate with the USE command. Chapter 4 is a good review of ODBC, OleDB and ADO as used within ADO.NET API. The repetitive way the authors demonstrate the basic sample code against the database not only helps drive home the similarities, but without saying it - pounds in the fundamental concepts of importing workspaces, creating or using connection and query strings, declaring variables explicitly while clearing them, using the 'try' feature of VB.NET including catching the exception if thrown 'although the text sample uses the variable 'e' for this exception vs the default 'ex'!' and how to close a project's connections and readers. This exercise is perfect for those who will ultimately use these techniques for connecting to other databases such as Oracle, SQL Anywhere, MySQL and others which carries into Chap 5 on Data Connections! This Chapter on connections is extremely thorough and, through well thought out examples with detailed explainations make learning a very confusing subject rather painless. Commands and the intracacies of connecting a command to a connection and to command text is well covered. I learned the nuances of setting the properties expicitly and implicitly. This is often glossed over in other texts on the subject but clearly illustrated here with good examples particularly emphasizing the differences between readers 'multiple objects returned', scalars 'single object returned' and non-query commands 'no objects returned'. The Chapter addresses the myraid of uses of the no

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted March 10, 2010

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)