Beginning VB .NET 1.1 Databases

This is a book for beginning and intermediate VB.NET students who want to learn the core of VB.NET: database programming, and they want to learn by going on a journey with Peter Wright at the height of his powers.Using the same iconoclastic drive that launched Peter Wright to a best selling author with his 'Beginning VB6' book from Wrox, Peter is back in business with a return to his best form. There are an array of VB.NET database books on the market, but Peter offers more than just a technical walkthrough: he takes the reader through a personal journey to expertise in VB.NET database programming.Following the classical formula of a fast-paced tutorial, and the classical formula of mythological legend, this is a programming book that will stand out from the crowd in this busy space.VB.NET is a powerful programming .NET programming language that is often considered the 'workhorse' of programming - and database programming in VB.NET accounts for a huge amount of the total programming effort taking place today. To understand VB.NET, and VB.NET database programming, is to be able to meet the every-day challenges faced in most programming projects today. Peter Wright enlivens this 'workhorse' topic with his own special style to bring learner and student programmers where they need to be on their way to expertise in today's VB.NET programming jobs. TOC:Installing MSDE.- A simple Data-driven Sample App.- Introduction to SQL.- What's ADO.NET? - Basic Rules.- Connecting to a Database.- Acquiring Data.- Using DataReader.- The DataSet and DataAdapter.- Data within Windows Applications.- Using Data in ASP.NET Pages.- Validating User Input.- Tables and Relationships.- More about SQL.- Views and Stored Procedures.- Indexes and Constraints.- Database Security.- ADO.NET and XML.- Handling ADO.NET Errors.- Transactions.- ADO.NET Events.- Irregular Data.