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.
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.
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
Perdedor1030
Posted Fri Jan 09 00:00:00 EST 2009
I Also Recommend:
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 NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Thu May 29 00:00:00 EDT 2008
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 NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Anonymous
Posted Sat Oct 03 00:00:00 EDT 2009
No text was provided for this review.
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...