Preface.
Acknowledgment.
1 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.
2 Introduction to Databases.
2.1 What Are Databases and Database Programs?
2.2 Develop a Database.
2.3 Sample Database.
2.4 Identifying Keys.
2.5 Defi ne Relationships.
2.6 ER Notation.
2.7 Data Normalization.
2.8 Database Components in Some Popular Databases.
2.9 Create Microsoft Access Sample Database.
2.10 Create Microsoft SQL Server 2005 Sample Database.
2.11 Create Oracle 10g XE Sample Database.
2.12 Chapter Summary.
Homework.
3 Introduction to ADO.NET.
3.1 ADO and ADO.NET.
3.2 Overview of ADO.NET 2.0.
3.3 Architecture of ADO.NET 2.0.
3.4 Components of ADO.NET 2.0.
3.5 Chapter Summary.
Homework.
4 Introduction to Language-Integrated Query (LINQ).
4.1 Overview of Language-Integrated Query.
4.2 Introduction to LINQ Query.
4.3 Architecture and Components of LINQ.
4.4 LINQ to Objects.
4.5 LINQ to DataSet.
4.6 LINQ to SQL.
4.7 LINQ to Entities.
4.8 LINQ to XML.
4.9 C# 3.0 Language Enhancement for LINQ.
4.10 Chapter Summary.
Homework.
5 Data Selection Query with Visual C#.NET.
PART I Data Query with Visual Studio Design Tools and
Wizards.
5.1 Completed Sample Database Application Example.
5.2 Visual Studio.NET 2008 Design Tools and Wizards.
5.3 Build a Sample Database Project?SelectWizard with SQL
Server Database.
5.4 Add and Utilize Visual Studio.NET Wizards and Design
Tools.
5.5 Query and Display Data Using the DataGridView Control.
5.6 Use DataSet Designer to Edit the Structure of DataSet.
5.7 Bind Data to Associated Controls in LogIn Form.
5.8 Develop Codes to Query Data Using Fill() Method.
5.9 Use Return a Single Value to Query Data for LogIn Form.
5.10 Coding for Selection Form.
5.11 Bind Data to Associated Controls in Faculty Form.
5.12 Develop Codes to Query Data from Faculty Table.
5.13 Display Pictures for Faculty Form.
5.14 Binding Data to Associated Controls in Course Form.
5.15 Develop Codes to Query Data for Course Form.
5.16 Build a Sample Database Project?SelectWizardOracle
with Oracle Database.
PART II Data Query with Runtime Objects.
5.17 Introduction to Runtime Objects.
5.18 Query Data Using Runtime Objects to Microsoft Access 2007
Database.
5.19 Query Data Using Runtime Objects to SQL Server
Database.
5.20 Query Data Using Runtime Objects to Oracle Database.
5.21 Chapter Summary.
Homework.
6 Data Inserting with Visual C#.NET.
PART I Data Inserting with Visual Studio.NET Design Tools and
Wizards.
6.1 Insert New Data into a Database.
6.2 Insert Data into Microsoft Access Database Using Sample
Project InsertWizard.
6.3 Insert Data into SQL Server Database Using Sample Project
SQLInsertWizard.
6.4 Insert Data into Oracle Database Using Sample Project
OracleInsertWizard.
PART II Data Insertion with Runtime Objects.
6.5 General Runtime Objects Method.
6.6 Insert Data into SQL Server Database Using Runtime Objects
Method.
6.7 Insert Data into Microsoft Access Database Using Runtime
Objects.
6.8 Insert Data into Oracle Database Using Runtime Objects.
6.9 Insert Data into Database Using LINQ Queries.
6.10 Insert Data into Database Using Stored Procedures.
6.11 Chapter Summary.
Homework.
7 Data Updating and Deleting with Visual
C#.NET.
PART I Data Updating and Deleting with Visual Studio.NET
Design Tools and Wizards.
7.1 Update or Delete Data in Databases.
7.2 Update and Delete Data for Microsoft Access Database.
7.3 Update and Delete Data for SQL Server Database.
7.4 Update and Delete Data for Oracle Database.
PART II Data Updating and Deleting with Runtime
Objects.
7.5 Runtime Objects Method.
7.6 Update and Delete Data for SQL Server Database Using Runtime
Objects.
7.7 Update and Delete Data for Oracle Databases Using Runtime
Objects.
7.8 Update and Delete Data in Database Using Stored
Procedures.
7.9 Update and Delete Data in Databases Using LINQ to SQL
Query.
7.10 Chapter Summary.
Homework.
8 Accessing Data in ASP.NET.
8.1 What Is .NET Framework?
8.2 What Is ASP.NET and ASP.NET 3.5?
8.3 Develop ASP.NET Web Application to Select Data from SQL
Server Databases.
8.4 Develop ASP.NET Web Application to Insert Data into SQL
Server Databases.
8.5 Develop Web Applications to Update and Delete Data in SQL
Server Databases.
8.6 Develop ASP.NET Web Applications with LINQ to SQL Query.
8.7 Develop ASP.NET Web Application to Select Data from Oracle
Databases.
8.8 Develop ASP.NET Web Application to Insert Data into Oracle
Databases.
8.9 Develop ASP.NET Web Application to Update and Delete Data in
Oracle Databases.
8.10 Chapter Summary.
Homework.
9 ASP.NET Web Services.
9.1 Web Services and Their Components.
9.2 Procedures to Build a Web Service.
9.3 Build ASP.NET Web Service Projects to Access SQL Server
Database.
9.4 Build ASP.NET Web Service Project to Insert Data into SQL
Server Database.
9.5 Build ASP.NET Web Service to Update and Delete Data for SQL
Server Database.
9.6 Build Windows-Based Web Service Clients to Use Web
Services.
9.7 Build Web-Based Web Service Clients to Use Web Services.
9.8 Build ASP.NET Web Service Project to Access Oracle
Database.
9.9 Build Web Service Clients to Use the Web Service
WebServiceOracleSelect.
9.10 Build ASP.NET Web Service Project to Insert Data into
Oracle Database.
9.11 Build Web Service Clients to Use Web Service
WebServiceOracleInsert.
9.12 Build ASP.NET Web Service to Update and Delete Data for
Oracle Database.
9.13 Build Web Service Clients to Use Web Service.
9.14 Chapter Summary.
Homework.
Index.
About the Author.
