Practical Database Programming With Visual C#.NET

by Bai, Ying

• ISBN13: 9780470467275
• ISBN10: 0470467274
• Edition: 1st
• Format: Paperback
• Copyright: 2010-04-05
• Publisher: Wiley-IEEE Press

Summary

This book is mainly designed for college students who take the database programming course in the Visual Studio.NET environment and want to learn both fundamental knowledge and practical techniques in designing and building of professional database program applied in real commercial and industrial applications in Visual C#.NET. The proposed book provides a detailed description about the practical considerations and applications in database programming with Visual C#.NET 2008 with authentic examples and detailed explanations. More important, a new writing style is developed and implemented in this book, combined with real examples, to provide readers with a clear picture as how to handle the database programming issues in Visual C#.NET 2008 environment.Unlike most other Visual C# database programming books in the current market, which discuss and present the database programming techniques with huge blocks of programming codes from the first page to the last page, this proposed book tries to use a new writing style to show readers, especially to the college students, how to develop professional and practical database programs in Visual C#.NET 2008 environment by using Visual Studio.NET 2008 Design Tools and Wizards related to ADO.NET 3.5, and to apply and manage codes that are auto-generated by using Wizards. By using this new style, the over headache caused by using those huge blocks of programming codes can be removed. Instead, a simple and easy way to create database programs using the wizards can be developed to attract students' learning interest, reducing the learning curve and furthermore to enable students to build professional and practical database programming in more efficient and interesting ways.

Author Biography

Dr. Ying Bai is an Associate Professor in the Department of Computer Science and Engineering at Johnson C. Smith University (JCSU). Before joining JCSU, Dr. Bai worked as a senior software engineer in the field of automatic control and testing equipment in Silicon Valley, California, and Columbus, Ohio. He has a great deal of experience in robotics control, robot calibrations, and related software programming, as well as accurate measurements in industrial and academic fields. Dr. Bai is a Senior Member of IEEE and a member of ACM. In recent years, he has published six books in multi-language interface programming, serial port programming, electronics, fuzzy logic technology, and database programming with Visual Basic.NET.

Table of Contents

Preface

Acknowledgement

Introduction

Introduction to Databases

What are databases and database programs

Develop a Database

Sample Database

Identifying Keys

Define 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

Homework

Introduction to ADO.NET

The ADO and ADO.NET

Overview of the ADO.NET 2.0

The Architecture of the ADO.NET 2.0

The Components of ADO.NET 2.0

Homework

Introduction to Language Integrated Query (LINQ)

Overview of Language Integrated Query

Introduction to LINQ Query

The 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

Homework

Data Selection Query with Visual C#.NET

Data Query with Visual Studio Design Tools and Wizards

A 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 the DataSet

Bind Data to Associated Controls in LogIn Form

Develop Codes to Query Data Using the Fill() Method

Use Return a Single Value to Query Data for LogIn Form

Coding for the Selection Form

Bind Data to the Associated Controls in Faculty Form

Develop Codes to Query Data From the 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 Object to Microsoft Access 2007 Database

Query Data Using Runtime Object to SQL Server Database

Query Data Using Runtime Object to Oracle Database

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 the Microsoft Access Database Using a Sample Project InsertWizard

Insert Data into the SQL Server Database Using a Sample Project SQLInsertWizard

Insert Data into the Oracle Database Using a Sample Project OracleInsertWizard

Data Insertion with Runtime Objects

The General Run Time Objects Method

Insert Data into the SQL Server Database Using the Run Time Object Method

Insert Data into the Microsoft Access Database Using the Run Time Objects

Insert Data into the Oracle Database Using the Run Time Objects

Insert Data into the Database Using the LINQ Queries

Insert Data into the Database Using Stored Procedures

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 Against 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

The Run Time Objects Method

Update and Delete Data For SQL Server Database Using the Run Time Objects

Update and Delete Data for Oracle Databases Using the Run Time Objects

Update and Delete Data Against Database Using Stored Procedures

Update and Delete Data against Databases Using the LINQ to SQL Query

Homework

Accessing Data in ASP.NET

What is .NET Framework

What is ASP.NET and ASP.NET 3.5: 636

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 Database

Develop ASP.NET Web Application to Insert Data Into Oracle Database

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

Homework

ASP.NET Web Services

What Are 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 Consume the Web Services

Build Web-Based Web Service Clients to Consume the Web Services

Build ASP.NET Web Service Project to Access Oracle Database

Build Web Service Clients to Consume the Web Service - WebServiceOracleSelect

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

Build Web Service Clients to Consume the Web Service - WebServiceOracleInsert

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

Build Web Service Clients to Consume the Web Service

Homework

Table of Contents provided by Publisher. All Rights Reserved.