Practical Database Programming with Visual Basic.NET

How to develop database programs for undergraduate level students.

Avoiding overly large blocks of code used in most other database programming books, this book shows a simple and easy way to create database programs and explains how to build professional and practical databases more efficiently. In addition to Design Tools and Wizards, the runtime object method is also discussed and analyzed to let users design and implement more sophisticated data-driven applications with complicated coding techniques. Three popular database systems – Microsoft Access, SQL Server 2005, and Oracle Database 10g Express Edition (XE) – are discussed in detail, with practical examples and sample projects. This book will appeal to college students, programmers, and software engineers alike. Sample code and additional exercise questions for students, as well as solutions and lecture slides for instructors, are available via the Web (www.cambridge.org/9780521712354).

1. Introduction; 2. Introduction to databases; 3. Introduction to ADO.NET; 4. Data selection query with Visual Basic.NET; 5. Data inserting with Visual Basic.NET; 6. Data updating and deleting with Visual Basic.NET; 7. Accessing data in ASP.NET; 8. ASP.NET web services.

This book explains how to develop professional and practical database programs in Visual Basic 2005 by using two methods: Visual Basic.NET 2005 Design Tools and Wizards, and runtime object methods. Both methods are discussed and analyzed with practical sample projects to allow users to design and implement data-driven applications with three different databases.

Dr Ying Bai is an Associate Professor in the Department of Computer Science and Engineering at Johnson C. Smith University in Charlotte, North Carolina. His special interests include computer architecture, software engineering, programming languages, fuzzy logic controls, automatic and robot controls, and robot calibrations. His industrial experience includes positions at Motorola MMS, Schlumberger ATE Technology, Immix TeleCom, and Lam Research. He is a senior member of the IEEE and a member of the ACM. Dr. Bai has published numerous research articles and five previous books on programming in the Windows environment and fuzzy logic controls.