Practical Database Programming with Visual Basic.NET
The most up-to-date Visual Basic.NET programming textbook--covering both fundamentals and advanced-level programming techniques--complete with examples and solutions
Visual Basic.NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of the classic Visual Basic (VB), which is implemented on the .NET Framework. Microsoft currently supplies two major implementations of Visual Basic: Microsoft Visual Studio (which is commercial software) and Microsoft Visual Studio Express (which is free of charge).
Forgoing the large amounts of programming codes found in most database programming books, Practical Database Programming with Visual Basic.NET shows students and professionals both how to develop professional and practical database programs in a Visual Basic.NET environment by using Visual Studio.NET Data Tools and Wizards related to ADO.NET 4.0, and how to apply codes that are auto-generated by solely using Wizards. The fully updated Second Edition:
* Covers both fundamentals and advanced database programming techniques
* Introduces three popular database systems with practical examples including MS Access, SQL Server 2008, and Oracle
* Features more than fifty sample projects with detailed illustrations and explanations to help students understand key techniques and programming technologies
* Includes downloadable programming codes and exercise questions
This book provides undergraduate and graduate students as well as database programmers and software engineers with the necessary tools to handle the database programming issues in the Visual Studio.NET environment.
Autorentext
YING BAI, PHD, is a Professor in the Department of Computer Science and Engineering at Johnson C. Smith University where he received the Grantsperson of the Year Award in 2009. A former senior software engineer in the field of automatic control and testing equipment, Dr. Bai is a Senior Member of IEEE and a member of ACM, and has published ten books and numerous papers on software engineering, interface programming, and fuzzy logic control.
Klappentext
The most up-to-date Visual Basic.NET programming textbookcovering both fundamentals and advanced-level programming techniquescomplete with examples and solutions
Visual Basic.NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of the classic Visual Basic (VB), which is implemented on the .NET Framework. Microsoft currently supplies two major implementations of Visual Basic: Microsoft Visual Studio (which is commercial software) and Microsoft Visual Studio Express (which is free of charge).
Forgoing the large amounts of programming codes found in most database programming books, Practical Database Programming with Visual Basic.NET shows students and professionals both how to develop professional and practical database programs in a Visual Basic.NET environment by using Visual Studio.NET Data Tools and Wizards related to ADO.NET 4.0, and how to apply codes that are auto-generated by solely using Wizards. The fully updated Second Edition:
- Covers both fundamentals and advanced database programming techniques
- Introduces three popular database systems with practical examples including MS Access, SQL Server 2008, and Oracle
- Features more than fifty sample projects with detailed illustrations and explanations to help students understand key techniques and programming technologies
- Includes downloadable programming codes and exercise questions
This book provides undergraduate and graduate students as well as database programmers and software engineers with the necessary tools to handle the database programming issues in the Visual Studio.NET environment.
Zusammenfassung
Practical Database Programming with Visual Basic.NET
The most up-to-date Visual Basic.NET programming textbookcovering both fundamentals and advanced-level programming techniquescomplete with examples and solutions
Visual Basic.NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of the classic Visual Basic (VB), which is implemented on the .NET Framework. Microsoft currently supplies two major implementations of Visual Basic: Microsoft Visual Studio (which is commercial software) and Microsoft Visual Studio Express (which is free of charge).
Forgoing the large amounts of programming codes found in most database programming books, Practical Database Programming with Visual Basic.NET shows students and professionals both how to develop professional and practical database programs in a Visual Basic.NET environment by using Visual Studio.NET Data Tools and Wizards related to ADO.NET 4.0, and how to apply codes that are auto-generated by solely using Wizards. The fully updated Second Edition:
- Covers both fundamentals and advanced database programming techniques
- Introduces three popular database systems with practical examples including MS Access, SQL Server 2008, and Oracle
- Features more than fifty sample projects with detailed illustrations and explanations to help students understand key techniques and programming technologies
- Includes downloadable programming codes and exercise questions
This book provides undergraduate and graduate students as well as database programmers and software engineers with the necessary tools to handle the database programming issues in the Visual Studio.NET environment.
Inhalt
Preface xxv
Acknowledgments xxvii
Chapter 1 Introduction 1
Outstanding Features about This Book 2
Who This Book Is For 2
What This Book Covers 2
How This Book Is Organized and How to Use This Book 5
How to Use the Source Code and Sample Databases 6
Instructors and Customers Supports 8
Chapter 2 Introduction to Databases 10
2.1 What Are Databases and Database Programs? 11
2.2 Develop a Database 13
2.3 Sample Database 14
2.4 Identifying Keys 17
2.5 Define Relationships 19
2.6 ER Notation 21
2.7 Data Normalization 22
2.8 Database Components in Some Popular Databases 26
2.9 Create Microsoft Access Sample Database 34
2.10 Create Microsoft SQL Server 2008 Sample Database 44
2.11 Create Oracle 11g XE Sample Database 61
2.12 Chapter Summary 87
Chapter 3 Introduction to ADO.NET 91
3.1 The ADO and ADO.NET 91
3.2 Overview of ADO.NET 93
3.3 The Architecture of ADO.NET 94
3.4 The Components of ADO.NET 95
3.5 Chapter Summary 145
Chapter 4 Introduction to Language Integrated Query (LINQ) 149
4.1 Overview of Language Integrated Query 149
4.2 Introduction to LINQ Query 161
4.3 The Architecture and Components of LINQ 164
4.4 LINQ to Objects 168
4.5 LINQ to DataSet 179
4.6 LINQ to SQL 197
4.7 LINQ to Entities 210
4.8 LINQ to XML 215
4.9 Visual Basic.NET Language Enhancement for LINQ 227
44.10 Chapter Summary 236
Chapter 5 Data Selection Query with Visual Basic.NET 241
Part I Data Query with Visual Studio.NET Design Tools and Wizards 242
5.1 A Completed Sample Database Application Example 242
5.2 Visual Studio.NET Design Tools and Wizards 245
5.3 Query Data from SQL Server Database Using Design Tools and Wizards 257
5.4 Add and Utilize Visual Studio Wizards and Design Tools 265
5.5 Query and Display Data using the DataGridView Control 268
5.6 Use DataSet Designer to Edit the Structure of the DataSet 272