Beginning VB 2008 Databases: From Novice to Professional

Overview

Beginning VB 2008 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 SQL Server XML data type and the 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...

See more details below
Other sellers (Paperback)
  • All (12) from $1.99   
  • New (6) from $12.95   
  • Used (6) from $1.99   
Sending request ...

Overview

Beginning VB 2008 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 SQL Server XML data type and the 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 Visual Basic 2008 across a range of coding situations. Code-heavy and full of practical detail, this book has been fully revised and upgraded for .NET 3.5 and offers you the best contemporary practice in this core programming area, so that you’ll find yourself using it in nearly all your .NET projects.

  • Provides step-by-step instructions on how to install and configure necessary tools
  • Presents all essential SQL query and update concepts and syntax, so you don’t need prior familiarity with relational databases or SQL
  • Describes how to use ADO.NET transactions, exceptions, and events
  • Covers ADO.NET features for handling XML, text, and binary data within a Visual Basic 2008 context
  • Explains all concepts through straightforward code examples

What you’ll learn

  • How relational databases work and how to use them
  • How Visual Basic uses ADO.NET to access databases
  • How to write stored procedures in T-SQL and call them from Visual Basic programs
  • How to use XML in database applications
  • How to use LINQ to simplify VB database programming
  • How to install SQL Server 2005 Express and use it to teach yourself databases by doing databases

Who this book is for

Beginning VB 2008 Databases is for every VB programmer. Database programming requires relatively little knowledge of VB but a lot of knowledge about relational database concepts and the database language SQL. This book assumes no prior database experience and teaches you, always through hands-on examples, how to create and use relational databases with SQL and how to access them with VB. Almost every application needs to access a database, and this book teaches all the fundamentals you may ever need to develop professional database applications.

Read More Show Less

Product Details

Meet the Author

Vidya Vrat Agarwal, a Microsoft .NET purist and an MCT, MCPD, MCTS, MCSD.NET, MCAD.NET, and MCSD, works with Lionbridge Technologies (NASDAQ: LIOX), and his business card reads "Subject Matter Expert" (SME). He is also a lifetime member of the Computer Society of India (CSI). He started working on Microsoft .NET with its beta release. He has been involved in software development, evangelism, consultation, corporate training, and T3 programs on Microsoft .NET for various employers and corporate clients. His articles can be read at ProgrammersHeaven.com, and he also reviews .NET preparation kits, available at UCertify.com. He has contributed as technical reviewer to many books published by Apress, including Beginning VB 2008 Databases: From Novice to Professional.

He lives with his beloved wife, Rupali, and lovely daughter, Vamika ("Pearly"). He believes that nothing will turn into a reality without them. He is the follower of the concept "No pain, no gain" and believes that his wife is his greatest strength. He is a bibliophile; when he is not working on technical stuff, he likes to be with his family and also likes reading spiritual and occult science books. He blogs at http://Dotnetpassion.blogspot.com. You can reach him at Vidya_mct@yahoo.com.

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.

Read More Show Less

Table of Contents

Ch. 1 Getting Your Tools 1

Ch. 2 Getting to Know Your Tools 15

Ch. 3 Getting to Know Relational Databases 25

Ch. 4 Writing Database Queries 35

Ch. 5 Manipulating Database Data 67

Ch. 6 Using Stored Procedures 89

Ch. 7 Using XML 109

Ch. 8 Understanding Transactions 123

Ch. 9 Getting to Know ADO.NET 143

Ch. 10 Making Connections 169

Ch. 11 Execllting Commands 185

Ch. 12 Using Data Readers 203

Ch. 13 Using Datasets and Data Adapters 225

Ch. 15 Building ASP.NET Applications 293

Ch. 14 Building Windows Forms Applications 267

Ch. 16 Handling Exceptions 313

Ch. 17 Working with Events 331

Ch. 18 Working with Text and Binary Data 343

Ch. 19 Using LINQ 365

Ch. 20 Using ADO.NET 3.5 379

Index 395

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 3 Customer Reviews
  • Posted January 9, 2009

    I Also Recommend:

    Ironically, Beginning VB 2008 Databases is not for beginners!

    I have been reading computer programming books daily for six months. This book is by far the worst. The first two chapters walk you through obtaining Visual Studio Express and SQL Server Express, and installing the sample databases. The authors have you run all these complicated commands, but never explain them. Also, installing the one sample database just gives an error. <BR/><BR/>The next two chapters are ridiculously confusing. Chapter 3 rambles on and on about advanced database topics and uses acronyms and words it has not defined. I read an entire T-SQL book before this one (Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes). That book was very well written and comprehensive. Beginning VB 2008 Databases covers complicated T-SQL syntax in the first (real) chapter that did not even appear in the other book. That is quite intimidating! <BR/><BR/>By Chapter 5, the book becomes easier to read, as if the earlier chapters are in the wrong place (or wrong book), but there are Visual Basic code samples that do not work. <BR/><BR/>The book uses Visual Basic console (command prompt), and does not get to Windows Forms programming until Chapter 14. Who uses console applications anymore? Perhaps they were trying to make it simple in the beginning. But console applications are boring, and the code did not work which made it difficult to fix (due to my limited knowledge of creating console applications. <BR/><BR/>I noticed quite a few English mistakes, and many parts are poorly worded and confusing. The one author has a foreign-sounding name, so perhaps English is not his first language. <BR/><BR/>Overall, I am very disappointed in this book. Luckily, I already have some T-SQL under my belt so I am making my way through it. I find myself reading and re-reading parts of this book trying to make sense of it. I have not found another current book that is dedicated to VB.NET and T-SQL which is why I bought this one. <BR/><BR/>There is one other review posted about this book, and the reviewer praises it. I have to disagree with him. I am very intelligent, and this book went right over my head. Perhaps someone with more database experience would get more out of it, but the book is called "Beginning" VB 2008 Databases.

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

    Posted May 29, 2008

    A reviewer

    In my reading of the book Beginning VB 2008 Databases: From Novice to Professional By Vidya Vrat Agarwal I was pleasantly surprised at the ease of understanding. I also appreciated the Try it Out exercises. Though it may lack some detail, it is a perfect book to get a novice programmer started in the right direction. It touches on the more important topics of database programming with VB and covers the new technologies from the latest release of Visual Studio and the .NET Framework to ADO, LINQ etc. The book also gets one acquainted with SQL, Windows Forms, ASP and Console applications. At around 400 pages it is not a major task to finish the book in a short period of time. I recommend this book as a getting started approach for any one new to development. D.D. Hamilton

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

    Posted October 3, 2009

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews

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