Practical Database Programming with Visual Basic. NET

by Ying Bai

• ISBN13: 9780470567838
• ISBN10: 047056783X
• Additional ISBN(s): 9780470467275, 9780470567845
• Format: eBook
• Copyright: 2010-04-01
• Publisher: Wiley-IEEE Press
• More Book Details
• Purchase Benefits

Summary

A novel approach to developing and applying databases with Visual C#.NET Practical Database Programming with Visual C#.NET clearly explains the considerations and applications in database programming with Visual C#.NET 2008 and in developing relational databases such as Microsoft Access, SQL Server, and Oracle Database. Sidestepping the traditional approach of using large blocks of code, Ying Bai utilizes both Design Tools and Wizards provided by Visual Studio.NET and real-time object methods to incorporate over sixty real sample database programming projects along with detailed illustrations and explanations to help readers understand the key techniques and programming technologies in database programming. This invaluable resource features: Fundamental and advanced database programming techniques for beginning and experienced students as well as programmers A real completed sample database CSE_DEPT with three versions (Microsoft Access 2007, SQL Server 2005 SP2, and Oracle Database 10g XE Release 2) used throughout the entire book Step-by-step details on designing and building a practical relational database Discussion and analysis of the new database query technique, LINQ API-which includes LINQ to Objects, LINQ to DataSet, LINQ to SQL, LINQ to Entities, and LINQ to XML-and implementation in actual projects with line-by-line explanation Homework and selected solutions for each chapter to strengthen and improve learning and understanding An Instructor's Manual (MS PPT), example codes and exercise questions, homework/exercise solutions, and database projects available for free download E-mail assistance from the author Readers who will benefit highly from this reference are undergraduate or graduate students majoring in computer science and engineering, graduate students in all engineering departments, and software engineers and researchers in academic and industrial fields. To obtain instructor materials please send an email to [e-mail] Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of Contents

Preface

Acknowledgment

Introduction

Outstanding Features of the Book

Target Audience

Topics Covered

Organization of the Book and How to Use It

How to Use the Source Code and Sample Databases

Instructor and Customer Support

Homework Solutions

Introduction to Databases

What Are Databases and Database Programs?

Develop a Database

Sample Database

Identifying Keys

Defi ne Relationships

ER Notation

Data Normalization

Database Components in Some Popular Databases

Create Microsoft Access Sample Database

Create Microsoft SQL Server 2005 Sample Database

Create Oracle 10g XE Sample Database

Chapter Summary

Homework

Introduction to ADO.NET

ADO and ADO.NET

Overview of ADO.NET 2.0

Architecture of ADO.NET 2.0

Components of ADO.NET 2.0

Chapter Summary

Homework

Introduction to Language-Integrated Query (LINQ)

Overview of Language-Integrated Query

Introduction to LINQ Query

Architecture and Components of LINQ

LINQ to Objects

LINQ to DataSet

LINQ to SQL

LINQ to Entities

LINQ to XML

C# 3.0 Language Enhancement for LINQ

Chapter Summary

Homework

Data Selection Query with Visual C # .NET

Data Query with Visual Studio Design Tools and Wizards

Completed Sample Database Application Example

Visual Studio.NET 2008 Design Tools and Wizards

Build a Sample Database Project-SelectWizard with SQL Server Database

Add and Utilize Visual Studio.NET Wizards and Design Tools

Query and Display Data Using the DataGridView Control

Use DataSet Designer to Edit the Structure of DataSet

Bind Data to Associated Controls in LogIn Form

Develop Codes to Query Data Using Fill() Method

Use Return a Single Value to Query Data for LogIn Form

Coding for Selection Form

Bind Data to Associated Controls in Faculty Form

Develop Codes to Query Data from Faculty Table

Display Pictures for Faculty Form

Binding Data to Associated Controls in Course Form

Develop Codes to Query Data for Course Form

Build a Sample Database Project-SelectWizardOracle with Oracle Database

Data Query with Runtime Objects

Introduction to Runtime Objects

Query Data Using Runtime Objects to Microsoft Access 2007 Database

Query Data Using Runtime Objects to SQL Server Database

Query Data Using Runtime Objects to Oracle Database

Chapter Summary

Homework

Data Inserting with Visual C # .NET

Data Inserting with Visual Studio.NET Design Tools and Wizards

Insert New Data into a Database

Insert Data into Microsoft Access Database Using Sample Project InsertWizard

Insert Data into SQL Server Database Using Sample Project SQLInsertWizard

Insert Data into Oracle Database Using Sample Project OracleInsertWizard

Data Insertion with Runtime Objects

General Runtime Objects Method

Insert Data into SQL Server Database Using Runtime Objects Method

Insert Data into Microsoft Access Database Using Runtime Objects

Insert Data into Oracle Database Using Runtime Objects

Insert Data into Database Using LINQ Queries

Insert Data into Database Using Stored Procedures

Chapter Summary

Homework

Data Updating and Deleting with Visual C # .NET

Data Updating and Deleting with Visual Studio.NET Design Tools and Wizards

Update or Delete Data in Databases

Update and Delete Data for Microsoft Access Database

Update and Delete Data for SQL Server Database

Update and Delete Data for Oracle Database

Data Updating and Deleting with Runtime Objects

Runtime Objects Method

Update and Delete Data for SQL Server Database Using Runtime Objects

Update and Delete Data for Oracle Databases Using Runtime Objects

Update and Delete Data in Database Using Stored Procedures

Update and Delete Data in Databases Using LINQ to SQL Query

Chapter Summary

Homework

Accessing Data in ASP.NET

What Is .NET Framework?

What Is ASP.NET and ASP.NET 3.5?

Develop ASP.NET Web Application to Select Data from SQL Server Databases

Develop ASP.NET Web Application to Insert Data into SQL Server Databases

Develop Web Applications to Update and Delete Data in SQL Server Databases

Develop ASP.NET Web Applications with LINQ to SQL Query

Develop ASP.NET Web Application to Select Data from Oracle Databases

Develop ASP.NET Web Application to Insert Data into Oracle Databases

Develop ASP.NET Web Application to Update and Delete Data in Oracle Databases

Chapter Summary

Homework

ASP.NET Web Services

Web Services and Their Components

Procedures to Build a Web Service

Build ASP.NET Web Service Projects to Access SQL Server Database

Build ASP.NET Web Service Project to Insert Data into SQL Server Database

Build ASP.NET Web Service to Update and Delete Data for SQL Server Database

Build Windows-Based Web Service Clients to Use Web Services

Build Web-Based Web Service Clients to Use Web Services

Build ASP.NET Web Service Project to Access Oracle Database

Build Web Service Clients to Use the Web Service WebServiceOracleSelect

Build ASP.NET Web Service Project to Insert Data into Oracle Database

Build Web Service Clients to Use Web Service WebServiceOracleInsert

Build ASP.NET Web Service to Update and Delete Data for Oracle Database

Build Web Service Clients to Use Web Service

Chapter Summary

Homework

Index

About the Author

Table of Contents provided by Publisher. All Rights Reserved.