SQL Server Database Programming with C#: Desktop and Web Applications

Cover
Half Title
Title Page
Copyright Page
Dedication
Table of Contents
Copyrights and Trademarks
Preface
Acknowledgements
About the Author
Chapter 1: Introduction
1.1 Outstanding Features about this Book
1.2 Who This Book Is For
1.3 What This Book Covers
1.4 How This Book Is Organized and How to Use this Book
1.5 How to Use Source Codes and Sample Database
1.6 Instructors’ and Customers’ Support
Chapter 2: Introduction to Databases
2.1 What Are Databases and Database Programs?
2.1.1 File Processing System
2.1.2 Integrated Databases
2.2 Develop a Database
2.3 Sample Database
2.3.1 Relational Data Model
2.3.2 Entity-Relationship Model (ER)
2.4 Identifying Keys
2.4.1 Primary Key and Entity Integrity
2.4.2 Candidate Key
2.4.3 Foreign Keys and Referential Integrity
2.5 Define Relationships
2.5.1 Connectivity
2.6 ER Notation
2.7 Data Normalization
2.7.1 First Normal Form (1NF)
2.7.2 Second Normal Form (2NF)
2.7.3 Third Normal Form (3NF)
2.8 Database Components in Some Popular Databases
2.8.1 Microsoft Access Databases
2.8.1.1 Database File
2.8.1.2 Tables
2.8.1.3 Queries
2.8.2 SQL Server Databases
2.8.2.1 Data Files
2.8.2.2 Tables
2.8.2.3 Views
2.8.2.4 Stored Procedures
2.8.2.5 Keys and Relationships
2.8.2.6 Indexes
2.8.2.7 Transaction Log Files
2.8.3 Oracle Databases
2.8.3.1 Data Files
2.8.3.2 Tables
2.8.3.3 Views
2.8.3.4 Stored Procedures
2.8.3.4.1 Initialization Parameter Files
2.8.3.4.2 Control Files
2.8.3.4.3 Redo Log Files
2.8.3.4.4 Password Files
2.9 Create Microsoft SQL Server 2019 Express Sample Database
2.9.1 Create the LogIn Table
2.9.2 Create the Faculty Table
2.9.3 Create Other Tables
2.9.4 Create Relationships Among Tables
2.9.4.1 Create Relationship between the LogIn and the Faculty Tables
2.9.4.2 Create Relationship between the LogIn and the Student Tables
2.9.4.3 Create Relationship between the Faculty and the Course Tables
2.9.4.4 Create Relationship between the Student and the StudentCourse Tables
2.9.4.5 Create Relationship between the Course and the StudentCourse Tables
2.9.5 Store Images to the SQL Server 2019 Express Database
2.10 A Short-Cut: How to Use the Sample Database without Building It
2.11 Chapter Summary
Homework
I. True/False Selections
II. Multiple Choice Questions
III. Exercises
Chapter 3: Introduction to ADO.NET
3.1 The ADO and ADO.NET
3.2 Overview of the ADO.NET 2.0
3.3 The Architecture of the ADO.NET 2.0
3.4 The Components of ADO.NET 2.0
3.4.1 The Data Provider
3.4.1.1 The ODBC Data Provider
3.4.1.2 The OLEDB Data Provider
3.4.1.3 The SQL Server Data Provider
3.4.1.4 The Oracle Data Provider
3.4.2 The Connection Class
3.4.2.1 The Open() Method of the Connection Class
3.4.2.2 The Close() Method of the Connection Class
3.4.2.3 The Dispose() Method of the Connection Class
3.4.3 The Command and the Parameter Classes
3.4.3.1 The Properties of the Command Class
3.4.3.2 The Constructors and Properties of the Parameter Class
3.4.3.3 Parameter Mapping
3.4.3.4 The Methods of the ParameterCollection Class
3.4.3.5 The Constructor of the Command Class
3.4.3.6 The Methods of the Command Class
3.4.3.6.1 The ExecuteReader Method
3.4.3.6.2 The ExecuteScalar Method
3.4.3.6.3 The ExecuteNonQuery Method
3.4.4 The DataAdapter Class
3.4.4.1 The Constructor of the DataAdapter Class
3.4.4.2 The Properties of the DataAdapter Class
3.4.4.3 The Methods of the DataAdapter Class
3.4.4.4 The Events of the DataAdapter Class
3.4.5 The DataReader Class
3.4.6 The DataSet Component
3.4.6.1 The DataSet Constructor
3.4.6.2 The DataSet Properties
3.4.6.3 The DataSet Methods
3.4.6.4 The DataSet Events
3.4.7 The DataTable Component
3.4.7.1 The DataTable Constructor
3.4.7.2 The DataTable Properties
3.4.7.3 The DataTable Methods
3.4.7.4 The DataTable Events
3.4.8 ADO.NET 4.3 Entity Framework
3.4.8.1 The ADO.NET 3.5 Entity Data Model
3.4.8.1.1 Entity Data Model Item Template
3.4.8.1.2 Entity Data Model Wizard
3.4.8.1.3 Entity Data Model Designer
3.4.8.1.3.1 Opening the ADO.NET Entity Data Model Designer
3.4.8.1.3.2 Validating the EDM
3.4.8.1.4 Entity Model Browser
3.4.8.2 Using the ADO.NET 3.5 Entity Data Model Wizard
3.4.8.2.1 Create a New Visual C# Windows-Based Project
3.4.8.2.2 Generate the Entity Data Model Files
3.4.8.2.3 Use the ADO.NET 3.5 Entity Data Model Wizard
3.5 Chapter Summary
Homework
I. True/False Selections
II. Multiple Choices
III. Exercises
Chapter 4: Introduction to Language Integrated Query (LINQ)
4.1 Overview of Language Integrated Query
4.1.1 Some Special Interfaces Used in LINQ
4.1.1.1 The IEnumerable and IEnumerable Interfaces
4.1.1.2 The IQueryable and IQueryable Interfaces
4.1.2 Standard Query Operators
4.1.3 Deferred Standard Query Operators
4.1.4 Non-Deferred Standard Query Operators
4.2 Introduction to LINQ Query
4.3 The Architecture and Components of LINQ
4.3.1 Overview of LINQ to Objects
4.3.2 Overview of LINQ to DataSet
4.3.3 Overview of LINQ to SQL
4.3.4 Overview of LINQ to Entities
4.3.5 Overview of LINQ to XML
4.4 LINQ to Objects
4.4.1 LINQ and ArrayList
4.4.2 LINQ and Strings
4.4.2.1 Query a String to Determine the Number of Numeric Digits
4.4.2.2 Sort Lines of Structured Text by Any Field in the Line
4.4.3 LINQ and File Directories
4.4.3.1 Query the Contents of Files in a Folder
4.4.4 LINQ and Reflection
4.5 LINQ to DataSet
4.5.1 Operations to DataSet Objects
4.5.1.1 Query Expression Syntax
4.5.1.2 Method-Based Query Syntax
4.5.1.3 Query the Single Table
4.5.1.4 Query the Cross Tables
4.5.1.5 Query Typed DataSet
4.5.2 Operations to DataRow Objects Using the Extension Methods
4.5.3 Operations to DataTable Objects
4.6 LINQ to SQL
4.6.1 LINQ to SQL Implementations
4.7 LINQ to Entities
4.7.1 The Object Services Component
4.7.2 The ObjectContext Component
4.7.3 The ObjectQuery Component
4.7.4 LINQ to Entities Flow of Execution
4.7.4.1 Construct an ObjectQuery Instance
4.7.4.2 Compose a LINQ to Entities Query
4.7.4.3 Convert the Query to Command Trees
4.7.4.4 Execute the Query
4.7.4.5 Materialize the Query
4.7.5 Implementation of LINQ to Entities
4.8 LINQ to XML
4.8.1 LINQ to XML Class Hierarchy
4.8.2 Manipulate XML Elements
4.8.2.1 Creating XML from Scratch
4.8.2.2 Insert XML
4.8.2.3 Update XML
4.8.2.4 Delete XML
4.8.3 Manipulate XML Attributes
4.8.3.1 Add XML Attributes
4.8.3.2 Get XML Attributes
4.8.3.3 Delete XML Attributes
4.8.4 Query XML with LINQ to XML
4.8.4.1 Standard Query Operators and XML
4.8.4.2 XML Query Extensions
4.8.4.3 Using Query Expressions with XML
4.8.4.4 Using XPath and XSLT with LINQ to XML
4.8.4.5 Mixing XML and Other Data Models
4.8.4.5.1 Reading from a Database to XML
4.8.4.5.2 Reading XML and Updating a Database
4.9 C# 3.0 Language Enhancement for LINQ
4.9.1 Lambda Expressions
4.9.2 Extension Methods
4.9.3 Implicitly Typed Local Variables
4.9.4 Query Expressions
4.10 Chapter Summary
Homework
I. True/False Selections
II. Multiple Choice Questions
III. Exercises
Chapter 5: Data Selection Query with Visual C#.NET
Part I Data Query with Visual Studio Design Tools and Wizards
5.1 Visual Studio Design Tools and Wizards
5.1.1 Data Design Tools in the Toolbox Window
5.1.1.1 DataSet
5.1.1.2 DataGridView
5.1.1.3 BindingSource
5.1.1.4 BindingNavigator
5.1.1.5 TableAdapter
5.1.2 Data Design Wizards in the Data Source Window
5.1.2.1 Add New Data Source
5.1.2.2 Data Source Configuration Wizard
5.1.2.3 DataSet Designer
5.2 Build a Sample Database Project – SelectWizard with SQL Server Database
5.2.1 Application User Interfaces
5.2.1.1 The LogIn Form
5.2.1.2 The Selection Form
5.2.1.3 The Faculty Form
5.2.1.4 The Course Form
5.2.1.5 The Student Form
5.2.1.6 Using Five Windows Forms without Building Them
5.3 Add and Utilize Visual Studio.NET Wizards and Design Tools
5.3.1 Add and Configure a New Data Source
5.4 Query and Display Data using the DataGridView Control
5.4.1 View the Entire Table
5.4.2 View Each Record or Specified Columns
5.5 Use DataSet Designer to Edit the Structure of a DataSet
5.6 Bind Data to the Associated Controls in LogIn Form
5.7 Develop Codes to Query Data Using the Fill() Method
5.8 Use Return a Single Value to Query Data for LogIn Form
5.9 Coding for the Selection Form
5.10 Bind Data Column to the Associated Controls in Faculty Form
5.11 Develop Codes to Query Data From the Faculty Table
5.11.1 Develop Codes to Query Data Using the SQL SELECT Method
5.11.2 Develop Codes to Query Data Using the LINQ Method
5.12 Binding Data to Associated Controls in the Course Form
5.13 Develop Codes to Query Data for the Course Form
5.13.1 Query Data From the Course Table Using the TableAdapter Method
5.13.2 Query Data From the Course Table Using the LINQ Method
Part II Data Query with Runtime Objects
5.14 Introduction to Runtime Objects
5.14.1 Procedure for Building a Data-Driven Application Using Runtime Objects
5.15 Query Data Using Runtime Object to SQL Server Database
5.15.1 Connect to SQL Server 2019 Express Databases
5.15.2 Create a New Visual C# Project RTOSelect Project
5.15.3 Query Data Using the General Runtime Objects For the LogIn Form
5.15.3.1 Coding Method 1: Using the DataAdapter to Query Data
5.15.3.2 Coding for Method 2: Using the DataReader to Query Data
5.15.4 The Coding Process for the Selection Form
5.15.5 Query Data Using the General Runtime Objects for the Faculty Form
5.15.6 Query Data Using the General Runtime Objects for the Course Form
5.15.6.1 Retrieve Data From Multiple Tables Using the Joined Tables Method
5.15.6.2 Build the Codes for Two User-Defined Methods
5.16 Query Data Using Stored Procedures
5.16.1 Create the Stored Procedure
5.16.2 Call the Stored Procedure
5.16.3 Query Data Using Stored Procedures for Student Form
5.16.4 Create a New Visual C# Project SPSelect Project to Query Student Table
5.16.5 Query Data Using More Complicated Stored Procedures
5.16.6 Query Data Using Nested Stored Procedures
5.17 Query Data Using the LINQ to SQL Technique
5.17.1 Create a New Visual C# Project and Setup LINQ to SQL Environment
5.17.2 Create Entity Classes and Connect the DataContext to the Database
5.17.3 Perform LINQ to SQL Query to LogIn Table via LogIn Form
5.17.4 Coding for the Selection Form
5.17.5 Query Data Using the LINQ to SQL for the Faculty Form
5.17.6 Query Data Using the Joined LINQ to SQL For the Course Form
5.18 Query Data Using the LINQ to SQL Stored Procedures For the Student Form
5.19 Chapter Summary
Homework
I. True/False Selections
II. Multiple Choices
III. Exercises
Chapter 6: Data Inserting with Visual C#.NET
Part I Insert Data with Visual Studio.NET Design Tools and Wizards
6.1 Insert Data Into a Database
6.1.1 Insert New Records into a Database Using the TableAdapter.Insert Method
6.1.2 Insert New Records into a Database Using the TableAdapter.Update Method
6.2 Insert Data into the SQL Server Database Using the Project InsertWizard Project
6.2.1 Create a New Project Based on the SelectWizard Project
6.2.2 Application User Interfaces
6.2.3 Validate Data Before the Data Insertion
6.2.3.1 The .NET Framework Collection Classes
6.2.3.2 Validate Data Using the Generic Collection
6.2.4 Validate Data After the Data Insertion
6.2.5 Initialization Coding for the Data Insertion
6.2.6 Build the Insert Query
6.2.6.1 Configure the TableAdapter and Build the Data Insertion Query
6.2.7 Develop Codes to Insert Data Using the TableAdapter.Insert Method
6.2.7.1 Develop the Codes for Two User Defined Methods
6.2.8 Develop Codes to Insert Data Using the TableAdapter.Update Method
6.3 Insert Data into the Course Table with Three Methods
6.3.1 Add Class Variables and Modify the Codes in the Form_Load() Method
6.3.2 Build the Query Method InsertCourse()
6.3.3 Create the Stored Procedure Using the TableAdapter Query Configuration Wizard
6.3.4 Build the Codes for the Insert Button’s Click Method
6.3.5 Build the Codes for Four User-Defined Methods
Part II Data Insertion with Runtime Objects
6.4 The General Runtime Objects Method
6.5 Insert Data into the SQL Server Database Using the Run Time Object Method
6.5.1 The Coding Process for the Data Validation before the Data Insertion
6.5.2 The Coding Process for the Data Validation after the Data Insertion
6.5.3 The Coding Process for the Data Insertion Action
6.6 Insert Data into the SQL Server Database Using Stored Procedures
6.6.1 Develop Stored Procedures of SQL Server Database
6.6.2 Develop Codes to Call Stored Procedures to Insert Data into the Course Table
6.6.2.1 Validate Data before the Data Insertion
6.6.2.2 Build the Codes for the Insert Click Method to Perform Data Insertion
6.6.2.3 Validate Data Insertion after the Course Data Insertion
6.7 Chapter Summary
Homework
I. True/False Selections
II. Multiple Choice Questions
III. Exercises
Chapter 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 Against SQL Server Databases
7.1.1 Updating and Deleting Data against Related Tables in a DataSet
7.1.2 Update or Delete Data against Database Using TableAdapter DBDirect Methods
7.1.3 Update or Delete Data against Database Using TableAdapter.Update Method
7.2 Update and Delete Data for the Faculty Table in our SQL Server Database
7.2.1 Configure the TableAdapter and Build the Data Updating and Deleting Queries
7.2.2 Develop Codes to Update Data Using the TableAdapter DBDirect Method
7.2.2.1 The Codes Modifications
7.2.2.2 The Codes Creations
7.2.3 Develop Codes to Update Data Using the TableAdapter.Update Method
7.2.4 Develop Codes to Delete Data Using the TableAdapter DBDirect Method
7.2.5 Develop Codes to Delete Data Using the TableAdapter.Update Method
7.2.6 Run Project to Validate the Data after the Data Updating and Deleting
Part II Data Updating and Deleting with Runtime Objects
7.3 The Run Time Object Method
7.4 Update and Delete Data Using the Run Time Object Method
7.4.1 Update Data for the Faculty Table in the SQL Server Database
7.4.1.1 Develop Codes to Update Data
7.4.1.2 Validate the Data Updating
7.4.2 Delete Data From the Faculty Table for the SQL Server Database
7.4.2.1 Develop Codes to Delete Data
7.4.2.2 Validate the Data Updating and Deleting
7.4.3 Update Data for the Course Table in the SQL Server Database
7.4.3.1 Develop Codes to Update the Course Record
7.4.3.2 Validate the Course Data Updating
7.4.4 Delete Data for the Course Table in the SQL Server Database
7.4.4.1 Develop Codes to Delete the Course Record
7.4.4.2 Validate the Course Data Deleting
7.5 Update and Delete Data from the Database Using Stored Procedures
7.5.1 Update and Delete Data against SQL Server Database Using Stored Procedures
7.5.1.1 Modify an Existing Project to Create Our New Project
7.5.1.2 Develop Stored Procedures with the Server Explorer Window
7.5.1.3 Call the Stored Procedures to Perform Data Updating and Deleting Actions
7.6 Update and Delete Data against Databases Using the LINQ to SQL Query
7.6.1 Modify the Codes for the Faculty Form Constructor
7.6.2 Build the User-Defined Method CurrentFaculty() with SQO Method
7.6.3 Develop the Codes for the Update Button Click Method
7.6.4 Develop the Codes for the Delete Button Click Method
7.7 Chapter Summary
Homework
I. True/False Selections
II. Multiple Choice Questions
III. Exercises
Chapter 8: Accessing Data in ASP.NET
8.1 Historical Review for ASP.NET Framework
8.2 What is .NET Framework?
8.3 What is ASP.NET and ASP.NET 4.8?
8.3.1 ASP.NET Web Application File Structure
8.3.2 ASP.NET Execution Model
8.3.3 What Really Happens When a Web Application is Executed?
8.3.4 The Requirements to Test and Run a Web Project
8.3.5 Install Missed Component to Get ASP.NET Template for .NET Framework
8.4 Develop ASP.NET Web Application to Select Data from SQL Server Databases
8.4.1 Create the User Interface – LogIn Form
8.4.2 Develop the Codes to Access and Select Data from the Database
8.4.3 Validate the Data in the Client Side
8.4.4 Select a Desired Web Browser to Effectively Run Our Web Application Project
8.4.5 Create the Second User Interface – Selection Page
8.4.6 Develop the Codes for the Selection Page to Open the Other Page
8.4.7 Create the Third User Interface – Faculty Page
8.4.8 Develop the Codes to Select the Desired Faculty Information
8.4.8.1 Develop the Codes for the Page_Load Method
8.4.8.2 Develop the Codes for the Select Button Method
8.4.8.3 Develop the Codes for Other Methods
8.4.9 Create the Fourth User Interface – Course Page
8.4.9.1 The AutoPostBack Property of the List Box Control
8.4.9.2 Develop the Codes to Select the Desired Course Information
8.4.9.3 Coding for the Course Page Loading and Ending Methods
8.4.9.4 Coding for the Select Button Click Method
8.4.9.5 Coding for the SelectedIndexChanged Method of the List Box Control
8.4.9.6 Coding for the User-Defined Method FillCourseReaderTextBox()
8.5 Develop ASP.NET Web Application to Insert Data Into SQL Server Databases
8.5.1 Develop the Codes to Insert a New Record into the Faculty Table
8.5.2 Develop the Codes for the Page_Load Method
8.5.3 Develop the Codes for the Insert Button Click Method
8.5.4 Develop the Codes for Other Methods
8.5.5 Validate the Data Insertion
8.6 Develop Web Applications to Update and Delete Data in SQL Server Databases
8.6.1 Develop the Codes for the Update Button Click Method
8.6.2 Develop Codes for the Delete Button Click Method
8.6.2.1 Relationships between Five Tables in Our Sample Database
8.6.2.2 Data Deleting Order Sequence
8.6.2.3 Use the Cascade Deleting Option to Simplify the Data Deleting Actions
8.6.2.4 Develop the Codes to Perform the Data Deleting Action
8.7 Develop ASP.NET Web Applications with LINQ to SQL Query
8.7.1 Create Entity Classes and Connect the DataContext to the Database
8.7.2 Perform LINQ to SQL Query to LogIn Table via LogIn Page
8.7.2.1 Develop Codes for the LogIn and the Cancel Buttons Click Methods
8.7.3 Build the Codes for the Selection Page
8.7.4 Perform LINQ to SQL Query to Faculty Table via Faculty Page
8.7.4.1 Create a New Object of the DataContext Class
8.7.4.2 The Coding for the Data Selection Query
8.7.4.3 The DataContext Class and Its Implementations
8.7.4.4 The Coding for the Data Insertion Query
8.7.4.5 The Coding for the Data Updating Query
8.7.4.6 The Coding for the Data Deleting Query
8.7.4.7 The Coding for the Back Button Click Method
8.8 Develop Web Applications to Query Course Table with LINQ to SQL Method
8.8.1 Develop the Codes to Query Course Record from the Course Table
8.8.1.1 Create a New Object of the DataContext Class
8.8.1.2 The Coding for the Data Selection Query
8.8.1.3 The Coding for the SelectedIndexChanged Method of the CourseList Box
8.8.2 Develop the Codes to Insert a New Course Record into the Course Table
8.8.3 Develop the Codes to Update a Course Record in the Course Table
8.8.4 Develop the Codes to Delete a Course Record from the Course Table
8.8.5 Develop the Codes for the Back Button Click Method
8.9 Develop Web Applications to Query Student Table with Stored Procedure Method
8.9.1 Develop the Codes to Query Student Record from the Student Table
8.9.1.1 Create a New Object of the DataContext Class
8.9.1.2 Add Two Stored Procedures into the DataContext Class
8.9.1.3 The Coding for the Data Selection Query
8.9.2 Develop the Codes to Insert a Student Record into the Student Table
8.9.2.1 Create a User-Defined Stored Procedure dbo.InsertStudent
8.9.2.2 The Coding for the Data Insertion Query
8.9.2.3 The Coding for Two User Defined Methods
8.9.2.4 Validate the Student Data Insertion
8.9.3 Update and Delete a Student Record in the Student Table via Stored Procedures
8.9.3.1 Build Two Stored Procedures to Update and Delete Student Records
8.9.3.2 The Coding for the Data Updating Query
8.9.3.3 The Coding for the Data Deleting Query
8.10 Chapter Summary
Homework
I. True/False Selections
II. Multiple Choices
III. Exercises
Chapter 9: ASP.NET Web Services
9.1 What Are Web Services and Their Components?
9.2 Procedures to Build a Web Service
9.2.1 The Structure of a Typical Web Service Project
9.2.2 The Real Considerations When Building a Web Service Project
9.2.3 Introduction to the Windows Communication Foundation (WCF)
9.2.3.1 What is the WCF?
9.2.3.2 WCF Data Services
9.2.3.3 WCF Services
9.2.3.4 WCF Clients
9.2.3.5 WCF Hosting
9.2.3.6 WCF Visual Studio Templates
9.2.3.6.1 WCF Web Service Application Template
9.2.3.6.2 WCF Service Library Project Template
9.2.4 Download and Install WCF Component in the Visual Studio.NET Environment
9.2.5 Procedures to Build an ASP.NET Web Service
9.3 Build ASP.NET Web Service Project to Access SQL Server Database
9.3.1 Files and Items Created in the New Web Service Project
9.3.2 A Feeling of the Hello World Web Service Project as It Runs
9.3.3 Modify the Default Namespace
9.3.4 Create a Base Class to Handle Error Checking for Our Web Service
9.3.5 Create a Customer Returned Class to Hold All Retrieved Data
9.3.6 Add Web Methods into Our Web Service Class
9.3.7 Develop the Codes for the Modified Web Methods to Perform the Web Services
9.3.7.1 Web Service Connection Strings
9.3.7.2 Modify the Existing HelloWorld Web Method
9.3.7.3 Develop the Codes to Perform the Database Queries
9.3.7.4 Develop the Codes for Two Methods Used in the Web Method
9.3.8 Develop a Stored Procedure to Perform the Data Query in Web Service
9.3.8.1 Develop the Stored Procedure WebSelectFacultySP
9.3.8.2 Add Another Web Method to Call the Stored Procedure
9.3.9 Use DataSet as the Returning Object for the Web Method in Web Service
9.3.10 Build Windows-Based Client Project to Consume the Web Services
9.3.10.1 Create a Web Service Proxy Class
9.3.10.2 Develop the Graphic User Interface for the Windows-Based Client Project
9.3.10.3 Develop the Code to Consume the Web Service
9.3.10.3.1 Develop the Codes for the Constructor of the FacultyForm Class
9.3.10.3.2 Develop Codes for the Back Button Click Method
9.3.10.3.3 Develop the Codes for the Select Button Click Event Procedure
9.3.10.3.4 Develop the Codes for All User-Defined Methods
9.3.11 Build Web-Based Client Project to Consume the Web Service
9.3.11.1 Create a New Web Site Project and Add an Existing Web Page
9.3.11.2 Add a Web Service Reference and Modify the Web Form Window
9.3.11.3 Modify the Codes in the Page_Load Event Method
9.3.11.4 Modify the Codes in the Select Button Click Method
9.3.11.5 Add Three User-Defined Methods
9.3.11.6 Modify the Codes for the Back Button Click Method
9.3.12 Deploy the Completed Web Service to Production Servers
9.3.12.1 Publish the Desired Web Service
9.4 Build ASP.NET Web Service Project to Insert Data Into SQL Server Database
9.4.1 Create a New Web Service Project WebServiceInsert Project
9.4.2 Develop Four Web Service Methods
9.4.2.1 Develop Codes for the First Web Method SetInsertSP()
9.4.2.2 Develop Codes for the User Defined Methods
9.4.2.3 Develop the Second Web Method GetInsert()
9.4.2.4 Develop the Third Web Method InsertDataSet()
9.4.2.5 Develop the Fourth Web Method GetInsertCourse()
9.4.2.5.1 Create the Stored Procedure WebSelectCourseSP()
9.4.2.5.2 Develop the Codes to Call this Stored Procedure
9.4.3 Build Windows-Based Clients to Consume the Web Services
9.4.3.1 Create a Windows-Based Consume Project and a Web Service Proxy Class
9.4.3.2 Develop the Graphic User Interface for the Client Project
9.4.3.3 Develop the Code to Consume the Web Service
9.4.3.3.1 Develop the Codes to Initialize and Terminate the Client Project
9.4.3.3.2 Develop the Codes to Insert a New Course Record into the Database
9.4.3.3.3 Develop the Codes to Perform the Inserted Data Validation
9.4.3.3.4 Develop the Codes to Get the Detailed Information for a Specific Course
9.4.4 Build Web-Based Client Project to Consume the Web Services
9.4.4.1 Create a New Web Application Project and Add a New Web Page
9.4.4.2 Add a Web Service Reference and Modify the Web Form Window
9.4.4.3 Build the Codes for the Related Methods
9.4.4.3.1 Build the Codes for the Page_Load() Method
9.4.4.3.2 Develop Codes for the Insert Button Click Method
9.4.4.3.3 Develop Codes for the TextChanged Method of the CourseID Textbox
9.4.4.3.4 Build the Codes in the Select Button’s Click Method
9.4.4.3.5 Build the Codes in the SelectedIndexChanged Method
9.4.4.3.6 Build the Codes for the Back Button’s Click Method
9.5 Build ASP.NET Web Service to Update and Delete Data for SQL Server Database
9.5.1 Modify the Default Namespace and Add Database Connection String
9.5.2 Create Our Customer-Built Base and Returned Classes
9.5.3 Create a Web Method to Call Stored Procedure to Update Student Records
9.5.4 Create a Web Method to Call Stored Procedure to Delete Student Records
9.5.5 Develop Two Stored Procedures WebUpdateStudentSP and WebDeleteStudentSP
9.5.5.1 Develop the Stored Procedure WebUpdateStudentSP()
9.5.5.2 Develop the Stored Procedure WebDeleteStudentSP()
9.6 Build Windows-Based Client Project to Consume the Web Services
9.6.1 Add a New Web Reference to Our Client Project
9.6.2 Build the Codes to the Update Button Click Method
9.6.3 Build the Codes to the Delete Button Click Method
9.7 Build Web-Based Client Project to Consume the Web Services
9.7.1 Create a New ASP.NET Web Application Project and Add an Existing Web Page
9.7.2 Add a Web Service Reference and Modify the Web Form Window
9.7.3 Build the Codes inside the Back Button Click Method
9.7.4 Add the Codes to the Update Button Click Method
9.7.5 Develop Codes for the Delete Button Click Method
9.8 Chapter Summary
Homework
I. True/False Selections
II. Multiple Choices
III. Exercises
Index