Practical Database Programming With Visual C#.NET

Name: Practical Database Programming With Visual C#.NET
Brand: Wiley-IEEE Press
Price: 107.99 EUR
Availability: OnlineOnly

Ying Bai(Autor*in)

Wiley-IEEE Press

Erschienen am 5. Mai 2010

800 Seiten

E-Book

PDF mit Adobe-DRM

Systemvoraussetzungen

978-0-470-56783-8 (ISBN)

107,99 €inkl. 7% MwSt.

Systemvoraussetzungen

für PDF mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

A novel approach to developing and applying databases withVisual C#.NET
Practical Database Programming with Visual C#.NET clearlyexplains the considerations and applications in databaseprogramming with Visual C#.NET 2008 and in developing relationaldatabases such as Microsoft Access, SQL Server, and OracleDatabase. Sidestepping the traditional approach of using largeblocks of code, Ying Bai utilizes both Design Tools and Wizardsprovided by Visual Studio.NET and real-time object methods toincorporate over sixty real sample database programming projectsalong with detailed illustrations and explanations to help readersunderstand the key techniques and programming technologies indatabase programming. This invaluable resource features:
* Fundamental and advanced database programming techniques forbeginning 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 Database10g XE Release 2) used throughout the entire book
* Step-by-step details on designing and building a practicalrelational 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--andimplementation in actual projects with line-by-line explanation
* Homework and selected solutions for each chapter to strengthenand improve learning and understanding
* An Instructor's Manual (MS PPT), example codes and exercisequestions, homework/exercise solutions, and database projectsavailable for free download
* E-mail assistance from the author
Readers who will benefit highly from this reference areundergraduate or graduate students majoring in computer science andengineering, graduate students in all engineering departments, andsoftware engineers and researchers in academic and industrialfields.
To obtain instructor materials please send an email to pressbooks@ieee.org
Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.

Weitere Details

Weitere Ausgaben

Person

Inhalt

Intro
Practical Database Programming With Visual C#.NET
Contents
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.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.5 Indexes
2.8.3.6 Initialization Parameter Files
2.8.3.7 Control Files
2.8.3.8 Redo Log Files
2.8.3.9 Password Files
2.9 Create Microsoft Access Sample Database
2.9.1 Create LogIn Table
2.9.2 Create Faculty Table
2.9.3 Create Other Tables
2.9.4 Create Relationships Among Tables
2.10 Create Microsoft SQL Server 2005 Sample Database
2.10.1 Create LogIn Table
2.10.2 Create Faculty Table
2.10.3 Create Other Tables
2.10.4 Create Relationships Among Tables
2.10.4.1 Create Relationship Between LogIn and Faculty Tables
2.10.4.2 Create Relationship Between LogIn and Student Tables
2.10.4.3 Create Relationship Between Faculty and Course Tables
2.10.4.4 Create Relationship Between Student and StudentCourse Tables
2.10.4.5 Create Relationship Between Course and StudentCourse Tables
2.11 Create Oracle 10g XE Sample Database
2.11.1 Create Oracle User Database
2.11.2 Add New Data Tables into Oracle User Database
2.11.2.1 Create LogIn Table
2.11.2.2 Create Faculty Table
2.11.2.3 Create Other Tables
2.11.3 Create Constraints Between Tables
2.11.3.1 Create Constraints Between LogIn and Faculty Tables
2.11.3.2 Create Constraints Between LogIn and Student Tables
2.11.3.3 Create Constraints Between Course and Faculty Tables
2.11.3.4 Create Constraints Between StudentCourse and Student Tables
2.11.3.5 Create Constraints Between StudentCourse and Course Tables
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.4.1 Data Provider
3.4.1.1 ODBC Data Provider
3.4.1.2 OLEDB Data Provider
3.4.1.3 SQL Server Data Provider
3.4.1.4 Oracle Data Provider
3.4.2 Connection Class
3.4.2.1 Open() Method of Connection Class
3.4.2.2 Close() Method of Connection Class
3.4.2.3 Dispose() Method of Connection Class
3.4.3 Command and Parameter Classes
3.4.3.1 Properties of Command Class
3.4.3.2 Constructors and Properties of Parameter Class
3.4.3.3 Parameter Mapping
3.4.3.4 Methods of ParameterCollection Class
3.4.3.5 Constructor of Command Class
3.4.3.6 Methods of Command Class
3.4.4 DataAdapter Class
3.4.4.1 Constructor of DataAdapter Class
3.4.4.2 Properties of DataAdapter Class
3.4.4.3 Methods of DataAdapter Class
3.4.4.4 Events of DataAdapter Class
3.4.5 DataReader Class
3.4.6 DataSet Component
3.4.6.1 DataSet Constructor
3.4.6.2 DataSet Properties
3.4.6.3 DataSet Methods
3.4.6.4 DataSet Events
3.4.7 DataTable Component
3.4.7.1 DataTable Constructor
3.4.7.2 DataTable Properties
3.4.7.3 DataTable Methods
3.4.7.4 DataTable Events
3.4.8 ADO.NET 3.5 Entity Framework
3.4.8.1 ADO.NET 3.5 Entity Data Model
3.4.8.2 Using ADO.NET 3.5 Entity Data Model Wizard
3.5 Chapter Summary
Homework
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 IEnumerable and IEnumerable&T& Interfaces
4.1.1.2 IQueryable and IQueryable&T& Interfaces
4.1.2 Standard Query Operators
4.1.3 Deferred Standard Query Operators
4.1.4 Nondeferred Standard Query Operators
4.2 Introduction to LINQ Query
4.3 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 Number of Numeric Digits
4.4.2.2 Sort Lines of Structured Text by Any Field in Line
4.4.3 LINQ and File Directories
4.4.3.1 Query 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 Extension Methods
4.5.3 Operations to DataTable Objects
4.6 LINQ to SQL
4.6.1 LINQ to SQL Entity Classes and DataContext Class
4.6.2 LINQ to SQL Database Operations
4.6.2.1 Data Selection Query
4.6.2.2 Data Insertion Query
4.6.2.3 Data Updating Query
4.6.2.4 Data Deletion Query
4.6.3 LINQ to SQL Implementations
4.7 LINQ to Entities
4.7.1 Object Services Component
4.7.2 ObjectContext Component
4.7.3 ObjectQuery Component
4.7.4 LINQ to Entities Flow of Execution
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.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
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.2.1 Data Design Tools in Toolbox Window
5.2.1.1 DataSet
5.2.1.2 DataGridView
5.2.1.3 BindingSource
5.2.1.4 BindingNavigator
5.2.1.5 TableAdapter
5.2.2 Data Design Wizards in Data Source Window
5.2.2.1 Add New Data Source
5.2.2.2 Data Source Configuration Wizard
5.2.2.3 DataSet Designer
5.3 Build a Sample Database Project-SelectWizard with SQL Server Database
5.3.1 Application User Interfaces
5.3.1.1 LogIn Form
5.3.1.2 Selection Form
5.3.1.3 Faculty Form
5.3.1.4 Course Form
5.3.1.5 Student Form
5.4 Add and Utilize Visual Studio.NET Wizards and Design Tools
5.4.1 Add and Configure a New Data Source
5.5 Query and Display Data Using the DataGridView Control
5.5.1 View Entire Table
5.5.2 View Each Record or Specified Columns
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.12.1 Develop Codes to Query Data Using SQL SELECT Method
5.12.2 Develop Codes to Query Data Using LINQ Method
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.15.1 Query Data from the Course Table Using TableAdapter Method
5.15.2 Query Data from the Course Table Using LINQ Method
5.16 Build a Sample Database Project-SelectWizardOracle with Oracle Database
5.16.1 Create a New Visual C# Project-SelectWizardOracle
5.16.2 Select and Add Oracle Database 10g XE as Data Source
PART II Data Query with Runtime Objects
5.17 Introduction to Runtime Objects
5.17.1 Procedure of Building a Data-Driven Application Using Runtime Objects
5.18 Query Data Using Runtime Objects to Microsoft Access 2007 Database
5.18.1 Query Data Using Runtime Objects for LogIn Form
5.18.1.1 Declare Runtime Objects
5.18.1.2 Connect to Data Source with Runtime Objects
5.18.1.3 Coding for Method 1: Using DataSet-DataAdapter to Query Data
5.18.1.4 Coding for Method 2: Using DataReader to Query Data
5.18.2 Coding for Selection Form
5.18.3 Query Data Using Runtime Objects for Faculty Form
5.18.4 Query Data Using Runtime Objects for Course Form
5.18.5 Query Data Using Runtime Objects for Student Form
5.18.5.1 Coding for Constructor of Student Form
5.18.5.2 Coding for Student Select Button Click Method
5.19 Query Data Using Runtime Objects to SQL Server Database
5.19.1 Migrating from Access to SQL Server and Oracle Databases
5.19.2 Query Data Using General Runtime Objects
5.19.2.1 Query Data Using the General Runtime Objects for LogIn Form
5.19.2.2 Coding for Selection Form
5.19.2.3 Query Data Using General Runtime Objects for Faculty Form
5.19.2.4 Query Data Using General Runtime Objects for Course Form
5.19.2.5 Retrieve Data from Multiple Tables Using Joined Tables Method
5.19.2.6 Query Data Using General Runtime Objects for Student Form
5.19.2.7 Query Data Using Stored Procedures
5.19.3 Query Data Using LINQ to SQL Technique
5.19.3.1 Create Entity Classes and Connect DataContext to Database
5.19.3.2 Query Data Using LINQ to SQL for LogIn Form
5.19.3.3 Coding for Selection Form
5.19.3.4 Query Data Using LINQ to SQL for Faculty Form
5.19.3.5 Query Data Using Joined LINQ to SQL for Course Form
5.19.3.6 Query Data Using LINQ to SQL Stored Procedures for Student Form
5.20 Query Data Using Runtime Objects to Oracle Database
5.20.1 Oracle Database 10g Express Edition Release 2
5.20.2 Configure Oracle Database Connection String
5.20.3 Query Data Using General Runtime Objects
5.20.3.1 Query Data Using General Runtime Objects for LogIn Form
5.20.3.2 Coding for Selection Form
5.20.3.3 Query Data Using Runtime Objects for Faculty Form
5.20.3.4 Query Data Using Runtime Objects for Course Form
5.20.3.5 Stored Procedures in Oracle Database Environment
5.20.3.6 Syntax of Creating a Stored Procedure in Oracle
5.20.3.7 Syntax of Creating a Package in Oracle
5.20.3.8 Create Faculty_Course Package for Course Form
5.20.3.9 Query Data Using Oracle Package for Course Form
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.1.1 Insert New Records into a Database Using TableAdapter.Insert Method
6.1.2 Insert New Records into a Database Using TableAdapter.Update Method
6.2 Insert Data into Microsoft Access Database Using Sample Project InsertWizard
6.2.1 Create New Project Based on SampleWizards Project
6.2.2 Application User Interfaces
6.2.3 Create Insert Faculty Form Window
6.2.4 Duplicate Visual C#.NET Projects with Installed DataSet
6.2.5 Validate Data Before Data Insertion
6.2.5.1 The .NET Framework Collection Classes
6.2.5.2 Validate Data Using Generic Collection
6.2.6 Initialization and Termination Coding for Data Insertion
6.2.7 Build Insert Query
6.2.7.1 Configure TableAdapter and Build Data Inserting Query
6.2.8 Develop Codes to Insert Data Using TableAdapter.Insert Method
6.2.9 Develop Codes to Insert Data Using TableAdapter.Update Method
6.2.10 Validate Data After Data Insertion
6.2.10.1 Modifications to Faculty Form Window
6.2.10.2 Modifications to Insert Faculty Form Window
6.3 Insert Data into SQL Server Database Using Sample Project SQLInsertWizard
6.3.1 Modify Existing Project to Get New Data Insertion Project
6.3.2 Create New Form Window to Insert Data for Course Form
6.3.3 Trigger and Connect to Visual Studio Design Tools
6.3.4 Project Initialization and Validate Data Before Data Insertion
6.3.5 Configure TableAdapter and Build Data Insertion Query
6.3.6 Develop Codes to Insert Data Using TableAdapter.Insert Method
6.3.7 Develop Codes to Insert Data Using TableAdapter.Update Method
6.3.8 Use Select Button in Course Form to Perform Data Validation
6.3.9 Insert Data into Database Using Stored Procedures
6.3.9.1 Create Stored Procedure Using TableAdapter Query Configuration Wizard
6.3.9.2 Modify Codes to Perform Data Insertion Using Stored Procedure
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.6.1 Add Inserting Data Form Window: Insert Faculty Form
6.6.2 Modify Codes to Copied Project
6.6.3 Startup Coding and Data Validation Before Data Insertion
6.6.4 Insert Data into Faculty Table
6.6.5 Validate Data After Data Insertion
6.6.5.1 Modifications to Faculty Form Window
6.6.5.2 Insert New Faculty Photo
6.6.5.3 Modifications to Insert Faculty Form Window
6.7 Insert Data into Microsoft Access Database Using Runtime Objects
6.7.1 Modifications to Namespaces
6.7.2 Remove SP Form and Student Form
6.7.3 Modify Database Connection String
6.7.4 Modify LogIn Query Strings
6.7.5 Modify Faculty Query String
6.7.6 Modifications to Other Forms
6.8 Insert Data into Oracle Database Using Runtime Objects
6.8.1 Add Oracle Reference and Oracle Namespace
6.8.2 Modify Project Namespaces
6.8.3 Modify Database Connection String
6.8.4 Modify LogIn Query Strings
6.8.5 Modify Faculty Query String
6.8.6 Modifications to Other Forms
6.9 Insert Data into Database Using LINQ Queries
6.9.1 Insert Data into SQL Server Database Using LINQ to SQL Queries
6.10 Insert Data into Database Using Stored Procedures
6.10.1 Insert Data into SQL Server Database Using Stored Procedures
6.10.1.1 Add an Inserting Data Form Window: Insert Course Form
6.10.1.2 Develop Stored Procedures of SQL Server Database
6.10.1.3 Develop Codes to Call Stored Procedures to Insert Data into Course Table
6.10.2 Insert Data into Oracle Database Using Stored Procedures
6.10.2.1 Develop Stored Procedures in Oracle Database
6.10.2.2 Develop Codes to Call Stored Procedures to Insert Data into Course Table
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.1.1 Updating and Deleting Data in Related Tables in DataSet
7.1.2 Update or Delete Data in Database Using TableAdapter DBDirect Methods-TableAdapter.Update and TableAdapter.Delete
7.1.3 Update or Delete Data in Database Using TableAdapter.Update Method
7.2 Update and Delete Data for Microsoft Access Database
7.2.1 Create New Project Based on InsertWizard Project
7.2.2 Application User Interfaces
7.2.2.1 Modify Faculty Form Window
7.2.2.2 Bind Data for All Textboxes of Faculty Form Window
7.2.3 Validate Data Before Data Updating and Deleting
7.2.4 Build Update and Delete Queries
7.2.4.1 Build Data Updating Query Function
7.2.4.2 Build Data Deleting Query Function
7.2.5 Develop Codes to Update Data Using TableAdapter DBDirect Method
7.2.5.1 Modifications of Coding
7.2.5.2 Updating Coding
7.2.6 Develop Codes to Update Data Using TableAdapter.Update Method
7.2.7 Develop Codes to Delete Data Using TableAdapter DBDirect Method
7.2.8 Develop Codes to Delete Data Using TableAdapter.Update Method
7.2.9 Validate Data After Data Updating and Deleting
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.6.1 Update Data in Faculty Table for SQL Server Database
7.6.1.1 Modify Faculty Form Window
7.6.1.2 Modify Original Coding in Faculty Form
7.6.1.3 Develop Codes to Update Data
7.6.1.4 Validate Data Updating
7.6.2 Delete Data from Faculty Table for SQL Server Database
7.6.2.1 Develop Codes to Delete Data
7.6.2.2 Validate Data Updating and Deleting
7.7 Update and Delete Data for Oracle Databases Using Runtime Objects
7.7.1 Add Oracle Namespace Reference
7.7.2 Modify Connection String and Query String for LogIn Form
7.7.2.1 Modify Connection String in Constructor of LogIn Class
7.7.2.2 Modify SELECT Query String in TabLogIn Button Click Method
7.7.2.3 Modify SELECT Query String in ReadLogIn Button Click Method
7.7.3 Modify Query Strings in Faculty Form
7.7.3.1 Modify SELECT Query String for Select Button Click Method
7.7.3.2 Modify UPDATE Query String for Update Button Click Method
7.7.3.3 Modify DELETE Query String for Delete Button Click Method
7.7.4 Modify Query Strings for Course Form
7.7.4.1 Modify SELECT Query String for Select Button Click Method
7.7.4.2 Modify SELECT Query String for CourseList Click Method
7.7.5 Other Modifications
7.8 Update and Delete Data in Database Using Stored Procedures
7.8.1 Update and Delete Data in Access Database Using Stored Procedures
7.8.1.1 Modify Existing Project
7.8.1.2 Create Stored Procedures in Microsoft Access Database
7.8.1.3 Call Stored Procedure to Update Faculty Information
7.8.1.4 Call Stored Procedure to Delete Faculty Information
7.8.2 Update and Delete Data in SQL Server Database Using Stored Procedures
7.8.2.1 Modify Existing Project to Create New Project
7.8.2.2 Develop Stored Procedure in SQL Server Database
7.8.2.3 Call Stored Procedure to Perform Data Updating and Deleting
7.8.3 Update and Delete Data in Oracle Database Using Stored Procedures
7.8.3.1 Modify Existing Project to Create New Project
7.8.3.2 Develop Stored Procedure in Oracle Database
7.8.3.3 Call Stored Procedures to Perform Data Updating and Deleting
7.9 Update and Delete Data in Databases Using LINQ to SQL Query
7.9.1 Create New Object of DataContext Class
7.9.2 Develop Codes for Select Button Click Method
7.9.3 Develop Codes for Update Button Click Method
7.9.4 Develop Codes for Delete Button Click Method
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.2.1 ASP.NET Web Application File Structure
8.2.2 ASP.NET Execution Model
8.2.3 What Really Happens When a Web Application Is Executed?
8.2.4 Requirements to Test and Run a Web Project
8.3 Develop ASP.NET Web Application to Select Data from SQL Server Databases
8.3.1 Create the User Interface-LogIn Form
8.3.2 Develop Codes to Access and Select Data from Database
8.3.3 Validate Data on Client Side
8.3.4 Create Second User Interface-Selection Page
8.3.5 Develop Codes to Open Other Page
8.3.6 Create Third User Interface-Faculty Page
8.3.7 Develop Codes to Select Desired Faculty Information
8.3.7.1 Develop Codes for Page_Load Method
8.3.7.2 Develop Codes for Select Button Method
8.3.7.3 Develop Codes for Other Methods
8.3.8 Create Fourth User Interface-Course Page
8.3.8.1 AutoPostBack Property of Listbox Control
8.3.9 Develop Codes to Select Desired Course Information
8.3.9.1 Coding for Course Page Loading and Ending Methods
8.3.9.2 Coding for Select Button Click Method
8.3.9.3 Coding for SelectedIndexChanged Method of Listbox Control
8.3.9.4 Coding for Other User-Defined Methods
8.4 Develop ASP.NET Web Application to Insert Data into SQL Server Databases
8.4.1 Create New Web Page Insert.aspx
8.4.2 Develop Codes to Perform Data Insertion Function
8.4.3 Develop Codes for Page_Load and Back Button Click Methods
8.4.4 Develop Codes for Insert Button Click Method
8.4.5 Develop Codes for Other Methods
8.4.6 Validate Data Insertion
8.5 Develop Web Applications to Update and Delete Data in SQL Server Databases
8.5.1 Application User Interfaces
8.5.2 Modify Coding for Faculty Page
8.5.3 Develop Codes for Update Button Click Method
8.5.4 Develop Codes for Delete Button Click Method
8.5.4.1 Relationships Between Five Tables in Our Sample Database
8.5.4.2 Data Deleting Order Sequence
8.5.4.3 Use Cascade Deleting Option to Simplify Data Deleting
8.5.4.4 Develop Codes to Perform Data Deleting
8.6 Develop ASP.NET Web Applications with LINQ to SQL Query
8.6.1 Create New Web Form Page
8.6.2 Create New Object of DataContext Class
8.6.3 Coding for Data Selection Query
8.6.4 Coding for Data Insertion Query
8.6.5 Coding for Data Updating and Deleting Queries
8.7 Develop ASP.NET Web Application to Select Data from Oracle Databases
8.7.1 Modify Connection String and Connection Object on LogIn Page
8.7.2 Modify Query String in LogIn Page
8.7.3 Modify Query String in Faculty Page
8.7.4 Modify Query Strings in Course Page
8.8 Develop ASP.NET Web Application to Insert Data into Oracle Databases
8.8.1 Add Two Controls to Faculty Page
8.8.2 Modify Codes to Some Methods on Faculty Page
8.8.3 Create Codes to Insert New Faculty on Faculty Page
8.9 Develop ASP.NET Web Application to Update and Delete Data in Oracle Databases
8.9.1 Modify Project to Perform Data Updating
8.9.1.1 Create Codes to Update Button Click Method
8.9.2 Develop Stored Procedures to Perform Data Deleting
8.9.2.1 Delete Existing Record from Faculty Table
8.9.2.2 Develop Codes for Delete Button Click Method
8.9.2.3 Validate Data Deleting Action
8.9.2.4 Constraint Property-On Delete Cascade in Data Table
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.2.1 Structure of a Typical Web Service Project
9.2.2 Real Considerations When Building a Web Service Project
9.2.3 Procedures to Build an ASP.NET Web Service
9.3 Build ASP.NET Web Service Projects to Access SQL Server Database
9.3.1 Files and Items Created in the New Web Service Project
9.3.2 Feeling of Hello World Web Service Project as It Runs
9.3.3 Modify Default Web Service Project
9.3.4 Create a Base Class to Handle Error Checking for Our Web Service
9.3.5 Create Real Web Service Class
9.3.6 Add Web Methods into Our Web Service Class
9.3.7 Develop the Codes for Web Methods to Perform the Web Services
9.3.7.1 Web Service Connection Strings
9.3.7.2 Modify Existing Web Method
9.3.7.3 Develop Codes to Perform Database Queries
9.3.7.4 Develop Codes for User-Defined Methods
9.3.8 Develop Stored Procedures to Perform the Data Query
9.3.8.1 Develop Stored Procedure WebSelectFacultySP
9.3.8.2 Add Another Web Method to Call the Stored Procedure
9.3.9 Use DataSet as Returning Object for Web Method
9.3.10 Build Windows-Based Web Service Clients to Use the Web Services
9.3.10.1 Create a Web Service Proxy Class
9.3.10.2 Develop Graphic User Interface for Windows-Based Client Project
9.3.10.3 Develop Code to Use the Web Service
9.3.11 Build Web-Based Web Service Clients to Use the Web Service
9.3.11.1 Create a New Website 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 Codes for Related Methods
9.3.12 Deploy the Completed Web Service to Production Servers
9.3.12.1 Copy Web Service Files to Virtual Directory
9.3.12.2 Publish Precompiled Web Service
9.4 Build ASP.NET Web Service Project to Insert Data into SQL Server Database
9.4.1 Modify Existing Web Service Project
9.4.2 Web Service Project Development Procedure
9.4.3 Develop and Modify Codes for Code-Behind Page
9.4.3.1 Develop and Modify First Web Method SetSQLInsertSP
9.4.3.2 Develop Second Web Method GetSQLInsert
9.4.3.3 Develop and Modify Third Web Method SQLInsertDataSet
9.4.3.4 Develop Fourth Web Method GetSQLInsertCourse
9.4.4 Build Windows-Based Web Service Clients to Use Web Services
9.4.5 Build Web-Based Web Service Clients to Use Web Services
9.4.5.1 Create a New Website Project and Add Existing Web Page
9.4.5.2 Add Web Service Reference and Modify Web Form Window
9.4.5.3 Modify Codes for Related Methods
9.5 Build ASP.NET Web Service to Update and Delete Data for SQL Server Database
9.5.1 Modify Existing Web Service Project
9.5.2 Modify Related Web Methods
9.5.2.1 Modify Web Method from SetSQLInsertSP to SQLUpdateSP
9.5.2.2 Modify Web Method GetSQLInsert to GetSQLCourse
9.5.2.3 Modify Web Method GetSQLInsertCourse to GetSQLCourseDetail
9.5.2.4 Add New Web Method SQLDeleteSP
9.5.3 Develop Two Stored Procedures WebUpdateCourseSP and WebDeleteCourseSP
9.5.3.1 Develop Stored Procedure WebUpdateCourseSP
9.5.3.2 Develop Stored Procedure WebDeleteCourseSP
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.7.1 Create New Website Project and Add Existing Web Page
9.7.2 Add Web Service Reference and Modify Web Form Window
9.7.3 Modify Codes for Related Methods
9.7.3.1 Modify Codes in Page_Load Method
9.7.3.2 Develop Codes for Update Button's Click Method
9.7.3.3 Develop Codes for Delete Button's Click Method
9.7.3.4 Modify Codes in Select Button's Click Method and Related Methods
9.7.3.5 Modify Codes in SelectedIndexChanged Method
9.8 Build ASP.NET Web Service Project to Access Oracle Database
9.8.1 Build Web Service Project WebServiceOracleSelect
9.8.2 Modify Connection String
9.8.3 Modify Namespace Directories
9.8.4 Modify Web Method GetSQLSelect and Related Methods
9.8.5 Modify Web Method GetSQLSelectSP and Related Methods
9.8.5.1 Modifications to Stored Procedure WebSelectFacultySP
9.8.5.2 Modifications to Codes in Web Method GetSQLSelectSP
9.8.6 Modify Web Method GetSQLSelectDataSet
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.10.1 Build Web Service Project WebServiceOracleInsert
9.10.2 Modify Connection String
9.10.3 Modify Namespace Directories
9.10.4 Modify Web Method SetSQLInsertSP and Related Methods
9.10.5 Modify Web Method GetSQLInsert and Related Methods
9.10.6 Modify Web Method SQLInsertDataSet
9.10.7 Modify Web Method GetSQLInsertCourse and Related Methods
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.12.1 Build Web Service Project WebServiceOracleUpdateDelete
9.12.2 Modify Connection String
9.12.3 Modify Namespace Directories
9.12.4 Modify Web Method SQLUpdateSP and Related Methods
9.12.4.1 Develop Stored Procedure UpdateCourse_SP
9.12.5 Modify Web Method GetSQLCourse and Related Methods
9.12.6 Modify Web Method GetSQLCourseDetail and Related Methods
9.12.7 Modify Web Method SQLDeleteSP
9.12.7.1 Develop Stored Procedure WebDeleteCourseSP
9.12.7.2 Implement and Test Web Service Project
9.13 Build Web Service Clients to Use Web Service
9.14 Chapter Summary
Homework
Index
About the Author

Systemvoraussetzungen

Als PDF speichern Als Link merken