- •About the Authors
- •Contents at a Glance
- •Contents
- •Introduction
- •Goal of the Book
- •How to Use this Book
- •Introduction to the .NET Framework
- •Common Language Runtime (CLR)
- •Class Library
- •Assembly
- •Versioning
- •Exceptions
- •Threads
- •Delegates
- •Summary
- •Introduction to C#
- •Variables
- •Initializing Variables
- •Variable Modifiers
- •Variable Data Types
- •Types of Variables
- •Variable Scope
- •Types of Data Type Casting
- •Arrays
- •Strings
- •Initializing Strings
- •Working with Strings
- •Statements and Expressions
- •Types of Statements
- •Expressions
- •Summary
- •Classes
- •Declaring Classes
- •Inheritance
- •Constructors
- •Destructors
- •Methods
- •Declaring a Method
- •Calling a Method
- •Passing Parameters to Methods
- •Method Modifiers
- •Overloading a Method
- •Namespaces
- •Declaring Namespaces
- •Aliases
- •Structs
- •Enumerations
- •Interfaces
- •Writing, Compiling, and Executing
- •Writing a C# Program
- •Compiling a C# Program
- •Executing a C# Program
- •Summary
- •Arrays
- •Single-Dimensional Arrays
- •Multidimensional Arrays
- •Methods in Arrays
- •Collections
- •Creating Collections
- •Working with Collections
- •Indexers
- •Boxing and Unboxing
- •Preprocessor Directives
- •Summary
- •Attributes
- •Declaring Attributes
- •Attribute Class
- •Attribute Parameters
- •Default Attributes
- •Properties
- •Declaring Properties
- •Accessors
- •Types of Properties
- •Summary
- •Introduction to Threads
- •Creating Threads
- •Aborting Threads
- •Joining Threads
- •Suspending Threads
- •Making Threads Sleep
- •Thread States
- •Thread Priorities
- •Synchronization
- •Summary
- •Case Study
- •Project Life Cycle
- •Analyzing Requirements
- •High-Level Design
- •Primary and Foreign Keys
- •Referential Integrity
- •Normalization
- •Designing a Database
- •Low-Level Design
- •Construction
- •Integration and Testing
- •User Acceptance Testing
- •Implementation
- •Operations and Maintenance
- •Summary
- •Creating a New Project
- •Console Application
- •Windows Applications
- •Creating a Windows Application for the Customer Maintenance Project
- •Creating an Interface for Form1
- •Creating an Interface for WorkerForm
- •Creating an Interface for CustomerForm
- •Creating an Interface for ReportsForm
- •Creating an Interface for JobDetailsForm
- •Summary
- •Performing Validations
- •Identifying the Validation Mechanism
- •Using the ErrorProvider Control
- •Handling Exceptions
- •Using the try and catch Statements
- •Using the Debug and Trace Classes
- •Using the Debugging Features of Visual Studio .NET
- •Using the Task List
- •Summary
- •Creating Form1
- •Connecting WorkerForm to the Workers Table
- •Connecting CustomerForm to the tblCustomer Table
- •Connecting the JobDetails Form
- •to the tblJobDetails Table
- •Summary
- •Introduction to the Crystal Reports Designer Tool
- •Creating the Reports Form
- •Creating Crystal Reports
- •Creating the Windows Forms Viewer Control
- •Creating the Monthly Worker Report
- •Summary
- •Introduction to Deploying a Windows Application
- •Deployment Projects Available in Visual Studio .NET
- •Deployment Project Editors
- •Summary
- •Case Study
- •Project Life Cycle
- •Analyzing Requirements
- •High-Level Design
- •Low-Level Design
- •Summary
- •Populating the TreeView Control
- •Displaying Employee Codes in the TreeView Control
- •Event Handling
- •Displaying Employee Details in the ListView Control
- •Summary
- •Case Study
- •Project Life Cycle
- •Analyzing Requirements
- •High-Level Design
- •Low-Level Design
- •Summary
- •Adding the Programming Logic to the Application
- •Adding Code to the Form Load() Method
- •Adding Code to the OK Button
- •Adding Code to the Exit Button
- •Summary
- •The Created Event
- •Adding Code to the Created Event
- •Overview of XML
- •The XmlReader Class
- •The XmlWriter Class
- •Displaying Data in an XML Document
- •Displaying an Error Message in the Event Log
- •Displaying Event Entries from Event Viewer
- •Displaying Data from the Summary.xml Document in a Message Box
- •Summary
- •Airline Profile
- •Role of a Business Manager
- •Role of a Network Administrator
- •Role of a Line-of-Business Executive
- •Project Requirements
- •Creation and Deletion of User Accounts
- •Addition of Flight Details
- •Reservations
- •Cancellations
- •Query of Status
- •Confirmation of Tickets
- •Creation of Reports
- •Launch of Frequent Flier Programs
- •Summarizing the Tasks
- •Project Design
- •Database Design
- •Web Forms Design
- •Enabling Security with the Directory Structure
- •Summary
- •Getting Started with ASP.NET
- •Prerequisites for ASP.NET Applications
- •New Features in ASP.NET
- •Types of ASP.NET Applications
- •Exploring ASP.NET Web Applications
- •Introducing Web Forms
- •Web Form Server Controls
- •Configuring ASP.NET Applications
- •Configuring Security for ASP.NET Applications
- •Deploying ASP.NET Applications
- •Creating a Sample ASP.NET Application
- •Creating a New Project
- •Adding Controls to the Project
- •Coding the Application
- •Summary
- •Creating the Database Schema
- •Creating Database Tables
- •Managing Primary Keys and Relationships
- •Viewing the Database Schema
- •Designing Application Forms
- •Standardizing the Interface of the Application
- •Common Forms in the Application
- •Forms for Network Administrators
- •Forms for Business Managers
- •Forms for Line-of-Business Executives
- •Summary
- •The Default.aspx Form
- •The Logoff.aspx Form
- •The ManageUsers.aspx Form
- •The ManageDatabases.aspx Form
- •The ChangePassword.aspx Form
- •Restricting Access to Web Forms
- •The AddFl.aspx Form
- •The RequestID.aspx Form
- •The Reports.aspx Form
- •The FreqFl.aspx Form
- •Coding the Forms for LOB Executives
- •The CreateRes.aspx Form
- •The CancelRes.aspx Form
- •The QueryStat.aspx Form
- •The ConfirmRes.aspx Form
- •Summary
- •Designing the Form
- •The View New Flights Option
- •The View Ticket Status Option
- •The View Flight Status Option
- •The Confirm Reservation Option
- •Testing the Application
- •Summary
- •Locating Errors in Programs
- •Watch Window
- •Locals Window
- •Call Stack Window
- •Autos Window
- •Command Window
- •Testing the Application
- •Summary
- •Managing the Databases
- •Backing Up the SkyShark Airlines Databases
- •Exporting Data from Databases
- •Examining Database Logs
- •Scheduling Database Maintenance Tasks
- •Managing Internet Information Server
- •Configuring IIS Error Pages
- •Managing Web Server Log Files
- •Summary
- •Authentication Mechanisms
- •Securing a Web Site with IIS and ASP.NET
- •Configuring IIS Authentication
- •Configuring Authentication in ASP.NET
- •Securing SQL Server
- •Summary
- •Deployment Scenarios
- •Deployment Editors
- •Creating a Deployment Project
- •Adding the Output of SkySharkDeploy to the Deployment Project
- •Deploying the Project to a Web Server on Another Computer
- •Summary
- •Organization Profile
- •Project Requirements
- •Querying for Information about All Books
- •Querying for Information about Books Based on Criteria
- •Ordering a Book on the Web Site
- •Project Design
- •Database Design
- •Database Schema
- •Web Forms Design
- •Flowcharts for the Web Forms Modules
- •Summary
- •Introduction to ASP.NET Web Services
- •Web Service Architecture
- •Working of a Web Service
- •Technologies Used in Web Services
- •XML in a Web Service
- •WSDL in a Web Service
- •SOAP in a Web Service
- •UDDI in a Web Service
- •Web Services in the .NET Framework
- •The Default Code Generated for a Web Service
- •Testing the SampleWebService Web Service
- •Summary
- •Creating the SearchAll() Web Method
- •Creating the SrchISBN() Web Method
- •Creating the AcceptDetails() Web Method
- •Creating the GenerateOrder() Web Method
- •Testing the Web Service
- •Securing a Web Service
- •Summary
- •Creating the Web Forms for the Bookers Paradise Web Site
- •Adding Code to the Web Forms
- •Summary
- •Case Study
- •Project Life Cycle
- •Analyzing Requirements
- •High-Level Design
- •Low-Level Design
- •Summary
- •Overview of Mobile Applications
- •The Microsoft Mobile Internet Toolkit
- •Overview of WAP
- •The WAP Architecture
- •Overview of WML
- •The Mobile Web Form
- •The Design of the MobileTimeRetriever Application
- •Creating the Interface for the Mobile Web Forms
- •Adding Code to the MobileTimeRetriever Application
- •Summary
- •Creating the Forms Required for the MobileCallStatus Application
- •Creating the frmLogon Form
- •Creating the frmSelectOption Form
- •Creating the frmPending Form
- •Creating the frmUnattended Form
- •Adding Code to the Submit Button in the frmLogon Form
- •Adding Code to the Query Button in the frmSelectOption Form
- •Adding Code to the Mark checked as complete Button in the frmPending Form
- •Adding Code to the Back Button in the frmPending Form
- •Adding Code to the Accept checked call(s) Button in the frmUnattended Form
- •Adding Code to the Back Button in the frmUnattended Form
- •Summary
- •What Is COM?
- •Windows DNA
- •Microsoft Transaction Server (MTS)
- •.NET Interoperability
- •COM Interoperability
- •Messaging
- •Benefits of Message Queues
- •Limitations
- •Key Messaging Terms
- •Summary
- •Pointers
- •Declaring Pointers
- •Types of Code
- •Implementing Pointers
- •Using Pointers with Managed Code
- •Working with Pointers
- •Compiling Unsafe Code
- •Summary
- •Introduction to the Languages of Visual Studio .NET
- •Visual C# .NET
- •Visual Basic .NET
- •Visual C++ .NET
- •Overview of Visual Basic .NET
- •Abstraction
- •Encapsulation
- •Inheritance
- •Polymorphism
- •Components of Visual Basic .NET
- •Variables
- •Constants
- •Operators
- •Arrays
- •Collections
- •Procedures
- •Arguments
- •Functions
- •Adding Code to the Submit Button
- •Adding Code to the Exit Button
- •Summary
- •Introduction to Visual Studio .NET IDE
- •Menu Bar
- •Toolbars
- •Visual Studio .NET IDE Windows
- •Toolbox
- •The Task List Window
- •Managing Windows
- •Customizing Visual Studio .NET IDE
- •The Options Dialog Box
- •The Customize Dialog Box
- •Summary
- •Index
DEVELOPING WEB SERVICES |
Chapter 29 |
645 |
|
|
|
|
|
Creating the SearchAll() Web Method
Creating a Web service involves coding for the Web methods in the Web service. In this case, you need to create a Web method that returns information about all the books published at Deepthoughts Publications. Before creating the Web method, add a short description about the Web method.
[WebMethod(Description=”This method searches for the details of all books published
by Deepthoughts Publications”)]
Now add the code for the Web method. The code for the Web method is as displayed:
[WebMethod(Description=”This method searches for the details of all books published by Deepthoughts Publications”)]
public DataSet SearchALL()
{
string SelStr;
SelStr = “Select * from DTCatalog”;
SqlCommand SelCom;
SelCom = new SqlCommand(SelStr, sqlConnection1); sqlDataAdapter1.SelectCommand = SelCom; sqlConnection1.Open(); sqlDataAdapter1.SelectCommand.ExecuteNonQuery(); sqlDataAdapter1.Fill(dsDetails1,”Details”); sqlConnection1.Close();
return dsDetails1;
}
The preceding code declares a string variable with the name SelStr. Next, the code initializes the SelStr variable to a SQL statement that retrieves all the records from the DTCatalog table. Next, an instance of the SqlCommand class is created with the name SelCom. The SqlCommand class is present in the System.Data.SqlClient namespace. The SqlCommand class is used to represent a SQL statement that is executed against a SQL server database. You can derive a class from a SqlCommand class.
After declaring the SelCom instance, you can initialize it. In the constructor of the SqlCommand class, you need to pass two parameters, SelStr and sqlConnection1. Because the SqlCommand class represents all the SQL statements executed against a SQL ser ver database, you need to specify the SQL statement by passing it as a
646 Project 5 CREATING A WEB PORTAL FOR A BOOKSTORE
parameter to the constructor. In addition, you need to specify the sqlConnection object for executing the SQL command. This object is passed as a parameter to the constructor of the SqlCommand class.
Next, the SelectCommand property of the SqlDataAdapter class is used to select the records stored in the SelCom object.The SqlDataAdapter class is present in the System.Data.SqlClient namespace and represents the SQL commands used to modify the SQL ser ver database.
Then, the Open() method of the SqlConnection class is used to establish a connection with the DTDB database. When a connection with the DTDB database is established, the records in the DTCatalog table are retrieved and stored in the dsDetails1 dataset. To do this, the ExecuteNonQuery() method of the SqlCommand class is executed to return the records that are affected by the SQL command stored in the SelStr variable. In this case, all the records in the DTCatalog table are returned by the ExecuteNonQuery() method. The records returned are then stored in the dataset by using the Fill() method of the DbDataAdapter class.
Once the records are retrieved, you can close the connection to the DTDB database by using the Close() method of the SqlConnection class. Finally, the dataset, dsDetails1, is returned when the SearchAll() method is called by a Web service client application. To return the dataset, you use the return keyword.
After creating the Web method, you can test the Web method by pressing the F5 key. The Service1.asmx page is displayed as shown in Figure 29-3.
FIGURE 29-3 The Service1.asmx page
DEVELOPING WEB SERVICES |
Chapter 29 |
647 |
|
|
|
|
|
The Service1.asmx page contains a link to the SearchAll() method. Click on the link to view the Service1.asmx page for the SearchAll() method. This page contains an Invoke button. When the user clicks on the Invoke button, the SearchAll() method is executed and the results are displayed as shown in Figure 29-4.
FIGURE 29-4 The results returned by the SearchAll() method
Creating the SrchISBN() Web Method
You can now create a Web method that returns the records from the DTCatalog table with the ISBN number that is passed as a parameter to the Web method. First, write a description for the Web method.
[WebMethod(Description=”This method searches for the details of the book based on
the “ + “ ISBN Number of the book”)]
After writing the description, you need to write the code for the Web method SrchISBN(). The code for the Web method is as follows:
[WebMethod(Description=”This method searches for the details of the book based on the “ + “ ISBN Number of the book”)]
public DataSet SrchISBN(string ISBN)
{
string SelStr;
648 |
Project 5 |
|
CREATING A WEB PORTAL FOR A BOOKSTORE |
||||
|
|
|
|
||||
|
|
SelStr = “Select * from DTCatalog where ISBNNo = @ISB”; |
|||||
|
|
SqlCommand SelCom; |
|
|
|
|
|
|
|
SelCom = new SqlCommand(SelStr, sqlConnection1); |
|||||
|
|
sqlDataAdapter1.SelectCommand = SelCom; |
|
||||
|
|
sqlDataAdapter1.SelectCommand.Parameters.Add(“@ISB”,SqlDbType.Char, 10) |
|||||
|
|
|
.Value = ISBN; |
|
|
|
|
|
|
sqlConnection1.Open(); |
|
|
|
|
|
|
|
sqlDataAdapter1.SelectCommand.ExecuteNonQuery(); |
|||||
|
|
sqlDataAdapter1.Fill(dsDetails1,”Details”); |
|||||
|
|
sqlConnection1.Close(); |
|
|
|
Y |
|
|
|
return dsDetails1; |
|
|
|
||
|
} |
|
|
|
|
|
|
|
|
|
|
|
L |
||
|
|
|
|
|
|
||
|
The preceding code declares a WebFmethod, SrchISBN(), which accepts a string |
||||||
|
type parameter named ISBN. In the method declaration statement, you also spec- |
||||||
|
ify the return type of the Web method. Because the SrchISBN() Web method |
||||||
|
|
|
|
|
M |
|
|
|
|
|
|
A |
|
|
|
|
|
|
E |
|
|
||
|
|
|
T |
|
|
|
returns the records with the specified ISBN number, the return type of the
SrchISBN() Web method is Dataset.
Next, a SQL statement that retrieves the record with the specified ISBN number is created and stored in the string type variable SelStr. Notice that the parameter specifying the ISBN number is preceded with @ in the SQL statement. This is the syntax for writing SQL queries in Visual Studio .NET.
After the SQL statement is created, the Add() method of the SqlParameterCol-
lection class is used to add SqlParameter to the SqlParameterCollection object.
The SqlParameterCollection object is used to store the parameters associated with the SQL command in the SqlParameterCollection object. Next, the Value property is used to assign a value to the parameter. In this case, the value assigned to the @ISB parameter is the ISBN number, which is passed to the SrchISBN() Web method.
After specifying a parameter, you can create a connection to the DTDB database. To do this, you use the Open() method. Then, the records affected are retrieved and stored in the dsDetails1 dataset. In this case, the records affected are the ones that match the ISBN number sent as the parameter. After storing the records, close the SQL connection by using the Close() method. The dataset is then returned by using the return keyword.
After creating the Web method, you can test the Web service. On the Service1.asmx page for the SrchISBN() Web method, specify the parameter and
Team-Fly®
DEVELOPING WEB SERVICES |
Chapter 29 |
649 |
|
|
|
|
|
click on the Invoke button. Figure 29-5 shows the Service1.asmx page for the
SrchISBN() Web method.
FIGURE 29-5 The Service1.asmx page for the SrchISBN() method
After clicking on the Invoke button, the Web method is executed and the results are returned as shown in Figure 29-6.
FIGURE 29-6 The results returned by the SrchISBN() method