Ying Bai (Johnson C. Smith University, Charlotte, NC)

SQL Server Database Programming with Visual Basic.NET

Concepts, Designs and Implementations

• Broschiertes Buch

Produktbeschreibung

A guide to the practical issues and applications in database programming with updated Visual Basic.NET

SQL Server Database Programming with Visual Basic.NET offers a guide to the fundamental knowledge and practical techniques for the design and creation of professional database programs that can be used for real-world commercial and industrial applications. The author--a noted expert on the topic--uses the most current version of Visual Basic.NET, Visual Basic.NET 2017 with Visual Studio.NET 2017. In addition, he introduces the updated SQL Server database and Microsoft SQL Server 2017 Express. All sample program projects can be run in the most updated version, Visual Basic.NET 2019 with Visual Studio.NET 2019.

Written in an accessible, down-to-earth style, the author explains how to build a sample database using the SQL Server management system and Microsoft SQL Server Management Studio 2018. The latest version of ASP.NET, ASP.NET 4.7, is also discussed to providethe most up-to-date Web database programming technologies. This important book:
_ Offers illustrative practical examples and detailed descriptions to aid in comprehension of the material presented
_ Includes both fundamental and advanced database programming techniques
_ Integrates images into associated database tables using a DevExpress UI tools -WindowsUI

Written for graduate and senior undergraduate students studying database implementations and programming courses, SQL Server Database Programming with Visual Basic.NET shows how to develop professional and practical database programs in Visual Basic.NET 2017/Visual Basic.NET 2019.

Produktdetails

• Verlag: Wiley & Sons / Wiley-IEEE Press
• Artikelnr. des Verlages: 1W119608500
• 1. Auflage
• Seitenzahl: 688
• Erscheinungstermin: 17. Juli 2020
• Englisch
• Abmessung: 191mm x 234mm x 41mm
• Gewicht: 1248g
• ISBN-13: 9781119608509
• ISBN-10: 1119608503
• Artikelnr.: 57825206

Autorenporträt

Ying Bai, PhD, is a Professor in the Department of Computer Science and Engineering at Johnson C. Smith University (JCSU). He has published multiple books with Wiley-IEEE Press including Practical Microcontroller Engineering with ARM Technology, Practical Database Programming with Visual C#.NET and Practical Database Programming with Java.

Inhaltsangabe

About the Author xix

Preface xxi

Acknowledgment xxiii

About the Companion Website xxiv

Chapter 1 Introduction 1

1.1 Outstanding Features About This Book 2

1.2 This Book is For 2

1.3 What This Book Covers 2

1.4 How This Book is Organized and How to Use This Book 5

1.5 How to Use Source Codes and Sample Database 6

1.6 Instructors and Customers Supports 8

Chapter 2 Introduction to Databases 9
Ying Bai and Satish Bhalla

2.1 What are Databases and Database Programs? 10

2.1.1 File Processing System 10

2.1.2 Integrated Databases 11

2.2 Develop a Database 12

2.3 Sample Database 13

2.3.1 Relational Data Model 13

2.3.2 Entity-Relationship Model (ER) 17

2.4 Identifying Keys 18

2.5 Define Relationships 18

2.6 ER Notation 22

2.7 Data Normalization 23

2.7.1 First Normal Form (1NF) 23

2.7.2 Second Normal Form (2NF) 24

2.7.3 Third Normal Form (3NF) 26

2.8 Database Components in Some Popular Databases 28

2.8.1 Microsoft Access Databases 28

2.8.2 SQL Server Databases 29

2.8.3 Oracle Databases 32

2.9 Create Microsoft SQL Server 2017 Express Sample Database 35

2.9.1 Create the LogIn Table 36

2.9.2 Create the Faculty Table 37

2.9.3 Create Other Tables 39

2.9.4 Create Relationships Among Tables 45

2.9.4.1 Create Relationship Between the LogIn and the Faculty Tables 46

2.9.4.2 Create Relationship Between the LogIn and the Student Tables 49

2.9.4.3 Create Relationship Between the Faculty and the Course Tables 50

2.9.4.4 Create Relationship Between the Student and the StudentCourse Tables 50

2.9.4.5 Create Relationship Between the Course and the StudentCourse Tables 51

2.9.5 Store Images to the SQL Server 2017 Express Database 53

2.10 Chapter Summary 61

Homework 63

Chapter 3 Introduction to ADO.NET 67

3.1 The ADO and ADO.NET 67

3.2 Overview of the ADO.NET 69

3.3 The Architecture of the ADO.NET 70

3.4 The Components of ADO.NET 71

3.4.1 The Data Provider 72

3.4.1.1 The ODBC Data Provider 73

3.4.1.2 The OLEDB Data Provider 73

3.4.1.3 The SQL Server Data Provider 74

3.4.1.4 The Oracle Data Provider 74

3.4.2 The Connection Class 74

3.4.2.1 The Open() Method of the Connection Class 77

3.4.2.2 The Close() Method of the Connection Class 77

3.4.2.3 The Dispose() Method of the Connection Class 78

3.4.3 The Command and the Parameter Classes 78

3.4.3.1 The Properties of the Command Class 79

3.4.3.2 The Constructors and Properties of the Parameter Class 79

3.4.3.3 Parameter Mapping 80

3.4.3.4 The Methods of the ParameterCollection Class 82

3.4.3.5 The Constructor of the Command Class 83

3.4.3.6 The Methods of the Command Class 84

3.4.4 The DataAdapter Class 87

3.4.4.1 The Constructor of the DataAdapter Class 87

3.4.4.2 The Properties of the DataAdapter Class 87

3.4.4.3 The Methods of the DataAdapter Class 88

3.4.4.4 The Events of the DataAdapter Class 88

3.4.5 The DataReader Class 90

3.4.6 The DataSet Component 92

3.4.6.1 The DataSet Constructor 94

3.4.6.2 The DataSet Properties 94

3.4.6.3 The DataSet Methods 94

3.4.6.4 The DataSet Events 94

3.4.7 The DataTable Component 97

3.4.7.1 The DataTa