Murach’s ADO.NET 4 Database Programming with VB 2010

Now in its 4th Edition, this book shows Visual Basic developers how to use Visual Studio and ADO.NET to develop database applications the way the best professionals do. You’ll learn how to:

• quickly create Windows and web applications by dragging-and-dropping data controls in Visual Studio 2010
• code your own presentation, business, and database classes with ADO.NET 4 to build 3-layer applications…the route the professionals take for flexibility and control
• display and manipulate data in web applications by using ASP.NET data controls designed specifically for that purpose, like GridView and DetailsView
• work with XML-specific features of ADO.NET and SQL Server to read, write, and manipulate XML data in your applications
• create local reports using Visual Studio’s Report Designer and Report Viewer to display data easily…and clearly!…in tables, matrices, lists, and charts
• Use the Entity Framework to create an entity data model that maps business objects to database objects, then retrieve and maintain data through that model
• Use LINQ to query datasets, SQL Server databases, and entity data

Practice exercises at the end of every chapter and complete database applications throughout help you master every skill along the way. And Murach’s distinctive “paired-pages” format…where each skill is presented with examples and advice in a single 2-page spread…is great for both targeted learning and reference.

Table of Contents

Section 1 An introduction to ADO.NET programming
Chapter 1 An introduction to database programming
Chapter 2 An introduction to ADO.NET 4

Section 2 How to use data sources and datasets for Rapid Application Development
Chapter 3 How to work with data sources and datasets
Chapter 4 How to work with bound controls and parameterized queries
Chapter 5 How to use the Dataset Designer

Section 3 Three-layer Windows Forms applications
Chapter 6 How to work with connections, commands, and data readers
Chapter 7 How to work with parameters and stored procedures
Chapter 8 How to work with transactions
Chapter 9 How to work with object data sources
Chapter 10 A complete Payable Entry application

Section 4 How to use ADO.NET with web applications
Chapter 11 How to use SQL data sources
Chapter 12 How to use the GridView control
Chapter 13 How to use the DetailsView control
Chapter 14 How to use object data sources

Section 5 Advanced database programming skills
Chapter 15 How to work with XML data
Chapter 16 How to use the reporting features of Visual Studio
Chapter 17 How to use LINQ
Chapter 18 How to use the Entity Framework
Appendix A How to install and use the software and files for this book