Future Institute Of Engineering & Management

Project Documentation On
“Online Flight Booking System”

Submitted By:
Guided By
1. Anirban Nandi Mr. Shibaprasad sen
2. Arjun Ghosh FIEM,kolkata

1
 CERTIFICATE
This is to certify that this report embodies the original work
done by Arjun Ghosh and Anirban Nandi during this project
submission as a partial fulfillment of the requirement for the
System Design Project of Masters of Computer Application V
Semester, of the West Bengal University Of Technology
under Future Institute Of Engineering & Management
supervision.

Project Co-ordinator

FIEM,Kolkata-150

Signature of HOD :-

Signature of Examiner :-

Signature of Project guide :-

2
 ACKNOWLEDGEMENT
The satisfaction that accompanies that the successful
completion of any task would be incomplete without the
mention of people whose ceaseless cooperation made it
possible, whose constant guidance and encouragement
crown all efforts with success. We are grateful to our project
guide Mr. Shibaprasad Sen for the guidance, inspiration
and constructive suggestions that helpful us in the
preparation of this project.

Arjun Ghosh
Anirban Nandi

3
 To Whom It May Concern:

The forgoing project is hereby approved as a creditable

study on engineering study on engineering subject carried
out & presented in a manner satisfactory to warrant it’s
acceptance as a prerequisite for the course for which it has
been submitted. It is understood that by approval
undersigned do not necessary endorsed or approve any
statement made, opinion expressed or conclusion drawn but
approve the work only for the purpose for which it has been
submitted.

Signature Of Examiner

--------------------------------
([Link] SEN)
Lecturer,CSE department,
Future Institute Of
Engineering & Management.

4
 PREFACE

We feel satisfied in presenting this major project report on

“Online Flight Booking System”.

The purpose of Online Flight Booking System is to book

flight tickets online in an efficient way.

The subject material has been presented in a concise,

compact, result oriented and lucid manner. Care has been
taken to make this documentation as self- explanatory as
possible.

Although every care has been taken to check mistakes and

misprints, yet it is difficult to claim perfection, so we request
any errors and omission to be excused.

Thank you,

Arjun Ghosh

5
Table of Contents
1. Synopsis

2. Feasibility Study

3. Working Of Present System

4. Characteristics of The Proposed System

5. Data Tables

6. Data Flow Diagrams

7. Entity Relationship Diagram

8. Screen Shots Of Form

9. Coding

[Link]

[Link]

6
ONLINE FLIGHT BOOKING SYSTEM

PURPOSE:
The purpose of Online Flight Booking System is to book flight tickets online
in an efficient way. The main objective of an Online Flight Booking System
is to make the ticket booking system more convenient for the public. People
no more have to go all the way to the Airport Ticket Counters to buy tickets.
No more waiting in queues. All a person needs is a computer with an
internet connection and that’s it. After booking the ticket online an e-ticket is
provided to the consumer by the website. The e-ticket is usually sent by e-
mail. The consumer only needs to take a printout of that e-ticket and present
that e-ticket while actually catching the respective flight.

FEATURES:
_ Secure
_ Simplistic
_ User-friendly
_ Reliable and accurate

7
OVERVIEW:
The purpose of Online Flight Booking System is to book flight tickets online
in an efficient way.

_ Login
_ Search Domestic Flights
_ Search International Flights
_ Get names of the Airports
_ Book Tickets Online

Login:-

There will be a standard login page for the registered users. Administrators
and Moderators can also login from there. The users will be required to enter
their login id and password to book tickets. Flight details will be visible to
unregistered users as well. However, to book tickets the users will be
required to be registered with the website.

Search Domestic Flights:-

Users, registered or unregistered, can search and access the details of

Domestic Flights ie. flights within India. The search can be done on the
following criteria:

_ Flight Id
_ Flight Name
_ Source
_ Destination

8
Search International Flights:-

Users, registered or unregistered, can search and access the details of

International Flights. The search can be done on the following criteria:

_ Flight Id
_ Flight Name
_ Source
_ Destination

Get Names of the Airports:-

Users can view the names of the Airports.

Book Tickets Online:-

Users can book tickets online from the Ticket Booking Section. As
mentioned before the user will be required to be logged in with his/her
respective login id and password. The user can book tickets one-way
or round trip. Choosing the Source and Destination as well as the
Departure Date and Arrival Date(if it’s a round trip) will provide the
user with all the flights available which helps the user to choose the
flight that best fits his/her requirement.

9
TECHNOLOGIES USED

Front end as:

[Link]

Back end as:

Microsoft SQL server 2003

Database:
Sql server

Querying language:
Sql

Programming Language:
C#

10
 TECHNICAL DISCUSSION

Reason for choosing [Link]:

[Link] is Microsoft’s most rated web technology these days. With

[Link] we can build powerful yet simple web application for internet
as well as intranet networks. In [Link], we can use fully fledged
programming languages like C# which is Microsoft’s most rated
language (because both the features of C++ and JAVA are available
in C#, plus some additional tools are available in C#.)[Link] is
compiled so it is faster than the classic asp, which interprets. Also
[Link] uses the .net framework, which means it has the advantage
of cross language integration and side by side execution, so no more
DLL hell.

Reason for choosing SQL server as Backend:

MS SQL Server is a powerful database server. Specially for working

with web technology like [Link], as backend MS SQL Server is the
premier choice because in .net framework, the [Link]
namespace is specially designed to work with MS SQL Server. This
SqlClient class is designed in such a way so that performance is
optimized. Also reliability is the key for any database application
(especially in the web application), and in that case MS SQL Server is
[Link] SQL Server (the version used in the application is ms
sql server 2000) increases scalability of a web application. Especially
when hundreds of clients are accessing a web application sql server’s
stored procedures are definitely the best way.

11
Advantage of [Link] over others:

There are several advantages of [Link] over other

technologies; they are briefly described as follows –

1. With [Link], we can get the advantage of using entire .NET

framework. So, the entire web application runs under CLR
(Common Language Runtime). All the codes under .NET
framework are called managed code.

2. After compilation of the .NET application, the intermediate code

is generated which is processor non specific.

3. In [Link] we can use fully fledged programming languages

(unlike Classic ASP, where we used only scripting languages like
VB Script, Java Script or Jscript).

4. .NET application supports cross language integration so we

can embeed codes written in other languages (e.g. managed C++
code or [Link] codes can also be added in an [Link]
application in which the default language is C#).

5. [Link] code is compiled, not interpreted like Classic Asp.

So, the execution of [Link] application is faster than classic
Asp. In case of [Link], there are so many controls, so user can
take the full advantage of it.

12
 Use of IIS (Internet Information Services):

It is the web server in our application. A web server is a software,

which serves web pages to the client. For a particular page
request, the web server first locates that page in the server, and
then it creates the equivalent html output and sends it to the client.
IIS is the most convenient web server in case of [Link] web
application. IIS web server can be found in the Windows
Installation CD. So, there’s no need to download any other web
server installation file. IIS is Microsoft’s professional web server
which is [Link] our application, IIS 5.1 is used (which can be
found in Windows XP installation cd). But this project can be
deployed under Windows Server 2003(IIS 6.0).

Runtime environment of the project:

For running this web application we need .net framework 3.5 in the
web server. Without this Framework this project won’t run. The
.net framework 3.5 can be downloaded from the Microsoft website
[Link] While installing visual
[Link] 2008 the .net framework 3.5 is installed automatically.
The CLR of .net framework provides the runtime environment of
the web application.

13
FEASIBILITY STUDY

Feasibility is the determination of whether a project worth doing.

Once preliminary area of application has been defined its subject to a
more rigorous examination in a feasibility study. In conducting the
feasibility study three types of feasibility can be considered-
Technical, Economical, Operational and Behavioural feasibility.

1.) ECONOMIC FEASIBILITY:-

Economic analysis is most frequently used for evaluation of the

14
effectiveness of the system. More commonly known as cost/benefit analysis
the procedure is to determine the benefit and saving that are expected from a
system and compare them with costs, decisions is made to design and
implement the system.

This part of feasibility study gives the top management the economic
justification for the new system. This is an important input to the
management the management, because very often the top management does
not like to get confounded by the various technicalities that bound to be
associated with a project of this kind. A simple economic analysis that gives
the actual comparison of costs and benefits is much more meaningful in such
cases.

In the system, the organization is most satisfied by economic feasibility.

Because, if the organization implements this system, it need not require any
additional hardware resources as well as it will be saving lot of time.

2.) TECHNICAL FEASIBILITY:-

Technical feasibility centers on the existing manual system of the test

management process and to what extent it can support the system.
According to feasibility analysis procedure the technical feasibility of the
system is analyzed and the technical requirements such as software facilities,
procedure, inputs are identified. It is also one of the important phases of the
system development activities.

The system offers greater levels of user friendliness combined with greater
processing speed. Therefore, the cost of maintenance can be reduced. Since,
processing speed is very high and the work is reduced in the maintenance
point of view management convince that the project is operationally feasible.

3) BEHAVIOURAL FEASIBILITY:-

15
People are inherently resistant to change and computer has been known to
facilitate changes. An estimate should be made of how strong the user is
likely to move towards the development of computerized system. These are
various levels of users in order to ensure proper authentication and
authorization and security of sensitive data of the organization.

16
4) OPERATIONAL FEASIBILITY:-

For a moment that technical and economical

resources are both judged adequate. The systems analyst must still
consider the operational feasibility of the requested project.
Operational feasibility is dependent on human resources available for
the project and projecting whether the system will operate and used
once it is installed.
If users are virtually wed to the present system, see on problems with
it, and generally are not involved in requesting a new system,
resistance to implementing the new system will be strong.

REQUIREMENT SPECIFICATION
1. Hardware environment :-

Processor: Intel P- III or above (Recommended)

Memory: 256MB RAM (Recommended)
Mother Board: Intel Architecture or compatible

2. Software Environment :-

Operating System: Microsoft windows Xp or Above

Web technology: [Link]
Web server: IIS (5.1 used in the application but 6.0 can
be used)

Server Side Scripting: C#

Database: MS SQL server 2000 (SQL Express)
Dependency: .Net framework 3.5
IDE: MS Visual Studio .Net 2008

17
ADVANTAGES OF CURRENT
SYSTEM
_ In comparison to the present system the proposed system will be less time
consuming and is more efficient as less graphics has been used.

_ It is simple and very user-friendly.

_ Website is updated regularly.

_ No Spam or Pop-Ups or unnecessary advertisements.

18
Indigo :-

Column Name Data Type Size

Flight_ID Integer 2
Flight_Name Varchar 20
Flight_Number Varchar 50
Origin Varchar 50
Via Varchar 50
Destination Varchar 50
Departure_Time Varchar 50
Arrival_Time Varchar 50
Days Varchar 50
Fare Integer 5

JetAirways :-

Column Name Data Type Size

19
 Flight_ID Integer 2
Flight_Name Varchar 20
Flight_Number Varchar 50
Origin Varchar 50
Via Varchar 50
Destination Varchar 50
Departure_Time Varchar 50
Arrival_Time Varchar 50
Days Varchar 50
Fare Integer 5
JetAirways-International :-

Column Name Data Type Size

Flight_ID Integer 2
Flight_Name Varchar 20
Flight_Number Varchar 50
Origin Varchar 50
Via Varchar 50
Destination Varchar 50
Departure_Time Varchar 50
Arrival_Time Varchar 50
Days Varchar 50
Fare Integer 5

Kingfisher :-

Column Name Data Type Size

Flight_ID Integer 2

20
Flight_Name Varchar 20
Flight_Number Varchar 50
Origin Varchar 50
Via Varchar 50
Destination Varchar 50
Departure_Time Varchar 50
Arrival_Time Varchar 50
Days Varchar 50
Fare Integer 5

Kingfisher-International :-

Column Name Data Type Size

Flight_ID Integer 2
Flight_Name Varchar 20
Flight_Number Varchar 50
Origin Varchar 50
Via Varchar 50
Destination Varchar 50
Departure_Time Varchar 50
Arrival_Time Varchar 50
Days Varchar 50
Fare Integer 5

Spicejet :-

Column Name Data Type Size

Flight_ID Integer 2

21
Flight_Name Varchar 20
Flight_Number Varchar 50
Origin Varchar 50
Via Varchar 50
Destination Varchar 50
Departure_Time Varchar 50
Arrival_Time Varchar 50
Days Varchar 50
Fare Integer 5

Spicejet-International :-

Column Name Data Type Size

Flight_ID Integer 2
Flight_Name Varchar 20
Flight_Number Varchar 50
Origin Varchar 50
Via Varchar 50
Destination Varchar 50
Departure_Time Varchar 50
Arrival_Time Varchar 50
Days Varchar 50
Fare Integer 5

22
Data Flow Diagram of Online Question Forum:-

23
24
25
Entity Relationship Diagram:-

26
Screenshots of the entire Project

Our project is an intranet-based application .So this project can be

used in any spectrum because these types of activities are performed
in any computer based System. There are several web forms. The
details are described as follows-

Home page:

27
This is the first page or the default page of the entire web application.
In this page there are some hyperlinks to other respective web pages
eg. Login Page, International and Domestic Flight Details, Booking
Tickets etc.

On home page is an International Flight section, clicking it will redirect

on the following page:

28
This is add
vertise.

29
To see the details of any of the Brands we click on the brand
name. On this page users can also search specific flights by
providing the source and destination. For example to see the
details of flights under Kingfisher we click on the icon of
Kingfisher and the following screen is displayed:

30
On home page is a Domestic Flight section, clicking it will redirect on
the following page:

31
To see the details of any of the Brands we click on the brand
name. On this page users can also search specific flights by
providing the source and destination. For example to see the
details of flights under Kingfisher we click on the icon of
Kingfisher and the following screen is displayed:

32
On the homepage there is also a hyperlink for Ticket Booking clicking on
which users are taken to the following page:

On this page users may book one-way or round trip tickets. Users have to be
registered to the website in order to book tickets i.e. users must have a valid
username and password.

33
On the homepage there is also a hyperlink to view the list of the national and
international airports. Clicking on that link takes the user to the following
page:

34
 CODING

Scripts

The project consists of various scripts, the details about the coding is
beyond the scope of this report. So, we like to mention only parts of
the scripts. In [Link] coding there can be two types, one is the Inline
coding and the other is code behind written in C#. We follow the code
behind technique. That is for generating output of one page we need
two pages one is the (* .aspx) page and the other is (* .[Link])
page.

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default4 : [Link]

{
protected void lbtnInternational_Click1(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void lbtnDomestic_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}

protected void lbtnTicketBooking_Click(object sender, EventArgs e)

{

35
 [Link]("[Link]");
}
protected void lbtnNamesOfDifferentFlights_Click(object sender,
EventArgs e)
{
[Link]("[Link]");
}

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default5 : [Link]

{

protected void imgbtnIndigo_Click(object sender, ImageClickEventArgs

e)
{
[Link]("[Link]");
}
protected void imgbtnJetairways_Click(object sender,
ImageClickEventArgs e)
{
[Link]("[Link]");
}
protected void imgbtnKingfisher_Click(object sender,
ImageClickEventArgs e)
{
[Link]("[Link]");
}

protected void imgbtnSicejet_Click(object sender,

ImageClickEventArgs e)

36
 {
[Link]("[Link]");
}
protected void LinkButton1_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void lbtnIndigo_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void lbtnJetAirways_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void lbtnKingfisher_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void lbtnSpicejet_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default4 : [Link]

{
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
protected void Page_Load(object sender, EventArgs e)
{

37
 if (!IsPostBack)
loadDomesticIndigo();
}
protected void loadDomesticIndigo()
{
string query = "select
Flight_ID,Flight_Number,Origin,Via,Destination,Departure_Time,Arrival_Ti
me,Days,Fare from [Indigo] ";
// string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
[Link]();
}
protected void dgrid_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if ([Link]([Link]) == "viewfl")
{

[Link]("[Link]?
type=Domestic&name=Indigo&id=" + ([Link]).ToString());
}

protected void dgrid_PageIndexChanging(object sender,

GridViewPageEventArgs e)
{
[Link] = [Link];
loadDomesticIndigo();
}
protected void dgrid_SelectedIndexChanged(object sender, EventArgs
e)
{

protected void btnSearch_Click(object sender, EventArgs e)

{
string or = [Link];
string query = "select Flight_ID, Flight_Number
,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[Indigo] where Origin='" + [Link] + "' and
Destination='" + [Link] + "'";

SqlConnection conn = new SqlConnection(constr);

[Link]();

38
 SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link]();
[Link] = dt;
[Link]();
}
protected void btnReset_Click(object sender, EventArgs e)
{
loadDomesticIndigo();
}
protected void btnBackHome_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default4 : [Link]

{
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
loadDomesticJetAirways();
}
protected void loadDomesticJetAirways()
{
string query = "select
Flight_ID,Flight_Number,Origin,Via,Destination,Departure_Time,Arrival_Ti
me,Days,Fare from [JetAirways] ";

39
 // string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
[Link]();
}
protected void dgrid_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if ([Link]([Link]) == "viewfl")
{

[Link]("[Link]?
type=Domestic&name=JetAirways&id=" + ([Link]).ToString());
}

protected void dgrid_PageIndexChanging(object sender,

GridViewPageEventArgs e)
{
[Link] = [Link];
loadDomesticJetAirways();
}
protected void dgrid_SelectedIndexChanged(object sender, EventArgs
e)
{

protected void btnSearch_Click(object sender, EventArgs e)

{
//string or = [Link];
string query = "select Flight_ID, Flight_Number
,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[JetAirways] where Origin='" + [Link] + "' and
Destination='" + [Link] + "'";

SqlConnection conn = new SqlConnection(constr);

[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link]();
[Link] = dt;
[Link]();
}

40
 protected void btnReset_Click(object sender, EventArgs e)
{
loadDomesticJetAirways();
}
protected void btnBackHome_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default4 : [Link]

{
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
loadDomesticKingfisher();
}
protected void loadDomesticKingfisher()
{
string query = "select
Flight_ID,Flight_Number,Origin,Via,Destination,Departure_Time,Arrival_Ti
me,Days,Fare from [Kingfisher] ";
// string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);

41
 SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
[Link]();
}
protected void dgrid_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if ([Link]([Link]) == "viewfl")
{

[Link]("[Link]?
type=Domestic&name=Kingfisher&id=" + ([Link]).ToString());
}

protected void dgrid_PageIndexChanging(object sender,

GridViewPageEventArgs e)
{
[Link] = [Link];
loadDomesticKingfisher();
}
protected void dgrid_SelectedIndexChanged(object sender, EventArgs
e)
{

protected void btnSearch_Click(object sender, EventArgs e)

{
string or = [Link];
string query = "select Flight_ID, Flight_Number
,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[Kingfisher] where Origin='" + [Link] + "' and
Destination='" + [Link] + "'";

SqlConnection conn = new SqlConnection(constr);

[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link]();
[Link] = dt;
[Link]();
}
protected void btnReset_Click(object sender, EventArgs e)
{
loadDomesticKingfisher();
}
protected void btnBackHome_Click(object sender, EventArgs e)
{

42
 [Link]("[Link]");
}
}

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default4 : [Link]

{
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
loadDomesticSpicejet();
}
protected void loadDomesticSpicejet()
{
string query = "select
Flight_ID,Flight_Number,Origin,Via,Destination,Departure_Time,Arrival_Ti
me,Days,Fare from [Spicejet] ";
// string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
[Link]();
}
protected void dgrid_RowCommand(object sender,
GridViewCommandEventArgs e)
{

43
 if ([Link]([Link]) == "viewfl")
{

[Link]("[Link]?
type=Domestic&name=Spicejet&id=" + ([Link]).ToString());
}

protected void dgrid_PageIndexChanging(object sender,

GridViewPageEventArgs e)
{
[Link] = [Link];
loadDomesticSpicejet();
}
protected void dgrid_SelectedIndexChanged(object sender, EventArgs
e)
{

protected void btnSearch_Click(object sender, EventArgs e)

{
string or = [Link];
string query = "select Flight_ID, Flight_Number
,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[Spicejet] where Origin='" + [Link] + "' and
Destination='" + [Link] + "'";

SqlConnection conn = new SqlConnection(constr);

[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link]();
[Link] = dt;
[Link]();
}
protected void btnReset_Click(object sender, EventArgs e)
{
loadDomesticSpicejet();
}
protected void btnBackHome_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

[Link] :-

44
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default5 : [Link]

{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void imgbtnJetairways_Click(object sender,
ImageClickEventArgs e)
{
[Link]("[Link]");
}
protected void imgbtnKingfisher_Click(object sender,
ImageClickEventArgs e)
{
[Link]("[Link]");
}

protected void imgbtnSpicejet_Click(object sender,

ImageClickEventArgs e)
{
[Link]("[Link]");
}
protected void lbtnAvailableLocation_Click(object sender, EventArgs
e)
{
[Link]("[Link]");
}
protected void lbtnBackHome_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void lbtnJetAirways_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void lbtnKingfisher_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void lbtnSpicejet_Click(object sender, EventArgs e)
{

45
 [Link]("[Link]");
}
}

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default4 : [Link]

{
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
loadInternationalJetAirways();
}
protected void loadInternationalJetAirways()
{
string query = "select
Flight_ID,Flight_Number,Origin,Via,Destination,Departure_Time,Arrival_Ti
me,Days,Fare from [JetAirways-International] ";
// string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
[Link]();
}
protected void dgrid_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if ([Link]([Link]) == "viewfl")
{

46
 [Link]("[Link]?
type=International&name=JetAirways&id=" +
([Link]).ToString());
}

protected void dgrid_PageIndexChanging(object sender,

GridViewPageEventArgs e)
{
[Link] = [Link];
loadInternationalJetAirways();
}
protected void dgrid_SelectedIndexChanged(object sender, EventArgs
e)
{

protected void btnSearch_Click(object sender, EventArgs e)

{
string or = [Link];
string query = "select Flight_ID, Flight_Number
,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[JetAirways-International] where Origin='" + [Link]
+ "' and Destination='" + [Link] + "'";

SqlConnection conn = new SqlConnection(constr);

[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link]();
[Link] = dt;
[Link]();
}
protected void btnReset_Click(object sender, EventArgs e)
{
loadInternationalJetAirways();
}
protected void btnBackHome_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

47
[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class _Default : [Link]

{
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
loadInternationalKingfisher();
}
protected void loadInternationalKingfisher()
{
string query = "select
Flight_ID,Flight_Number,Origin,Via,Destination,Departure_Time,Arrival_Ti
me,Days,Fare from [Kingfisher-International] ";
// string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
[Link]();
}
protected void dgrid_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if ([Link]([Link]) == "viewfl")
{

[Link]("[Link]?
type=International&name=Kingfisher&id=" +
([Link]).ToString());
}

48
 }

protected void dgrid_PageIndexChanging(object sender,

GridViewPageEventArgs e)
{
[Link] = [Link];
loadInternationalKingfisher();
}
protected void dgrid_SelectedIndexChanged(object sender, EventArgs
e)
{

protected void btnSearch_Click(object sender, EventArgs e)

{
string or = [Link];
string query = "select Flight_ID, Flight_Number
,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[Kingfisher-International] where Origin='" + [Link]
+ "' and Destination='" + [Link] + "'";

SqlConnection conn = new SqlConnection(constr);

[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link]();
[Link] = dt;
[Link]();
}
protected void btnReset_Click(object sender, EventArgs e)
{
loadInternationalKingfisher();
}
protected void btnBackHome_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

49
[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default4 : [Link]

{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void lbtnBackInernational_Click(object sender, EventArgs
e)
{
[Link]("[Link]");
}
protected void lbtnBackHome_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

[Link] :-
50
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default4 : [Link]

{
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
loadInternationalSpicejet();
}
protected void loadInternationalSpicejet()
{
string query = "select
Flight_ID,Flight_Number,Origin,Via,Destination,Departure_Time,Arrival_Ti
me,Days,Fare from [Spicejet-International] ";
// string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link] = dt;
[Link]();
}
protected void dgrid_RowCommand(object sender,
GridViewCommandEventArgs e)
{
if ([Link]([Link]) == "viewfl")
{

[Link]("[Link]?
type=International&name=Spicejet&id=" + ([Link]).ToString());
}

51
 protected void dgrid_PageIndexChanging(object sender,
GridViewPageEventArgs e)
{
[Link] = [Link];
loadInternationalSpicejet();
}
protected void dgrid_SelectedIndexChanged(object sender, EventArgs
e)
{

protected void btnSearch_Click(object sender, EventArgs e)

{
string or = [Link];
string query = "select Flight_ID, Flight_Number
,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[Spicejet-International] where Origin='" + [Link] +
"' and Destination='" + [Link] + "'";

SqlConnection conn = new SqlConnection(constr);

[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
[Link]();
[Link] = dt;
[Link]();
}
protected void btnReset_Click(object sender, EventArgs e)
{
loadInternationalSpicejet();
}
protected void btnBackHome_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

[Link] :-
using System;

52
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class LoginPage : [Link]

{
protected void Page_Load(object sender, EventArgs e)
{

}
}

[Link] :-

<%@ Master Language="C#" AutoEventWireup="true"

CodeFile="[Link]"
Inherits="MasterPage2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"[Link]
<html xmlns="[Link]
<head id="Head1" runat="server">
<title>Untitled Page</title>
<asp:ContentPlaceHolder ID="head" runat="server">
</asp:ContentPlaceHolder>
<style type="text/css">

.style2
{
width: 110px;
}
.textalignmnetCenter
{
text-align: center;
}
.bodytext
{
color: #FFBBDD;
font-family: Verdana;
}
.tdstyle

53
 {
background-color:Blue;
height: 500px;
width: 80px;
}
.style3
{
width: 838px;
}
</style>
</head>
<body style="margin: 5px auto; margin-left:auto; " class="bodytext" >
<form id="form1" runat="server">
<table cellpadding="0" cellspacing="0" width="100%" >
<tr>
<td bgcolor="#0D6B10" colspan="2" height="100px"
class="textalignmnetCenter">
<asp:Label ID="Label1" runat="server" Font-Bold="True"
Font-Size="X-Large"
Text="Online Flight Booking System"
ForeColor="White"></asp:Label>
</td>
</tr>
<tr>
<td class="tdstyle" bgcolor="Red">
</td>
<td valign="top" class="style3">
<asp:ContentPlaceHolder ID="ContentPlaceHolder1"
runat="server">
</asp:ContentPlaceHolder>
</td>
</tr>
<tr>
<td class="style2">
&nbsp;
</td>
<td class="style3">
&nbsp;
</td>
</tr>
</table>
</form>
</body>
</html>

[Link] :-

54
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class _Default : [Link]

{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void lbtnBackHome_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

55
[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class Default4 : [Link]

{
string ftype = [Link];
string fid = [Link];
string fname = [Link];

protected void Page_Load(object sender, EventArgs e)

{
ftype=[Link]([Link]["type"]);
fid=[Link]([Link]["id"]);
fname = [Link]([Link]["name"]);
if (!IsPostBack)
{
filldata();
}
}

private void filldata()

{
if (ftype == "International")
{
[Link] = true;

}
else
{
[Link] = true;

[Link](fname).Selected=true;
[Link] = fid;

string query = "select Flight_ID,Flight_Number

,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[JetAirways-International] where Flight_ID='" + fid + "' ";
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";

56
 SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
if ([Link] > 0)
{
[Link] = [Link]([Link][0]["Fare"]);
[Link] = [Link]([Link][0]
["Departure_Time"]);
[Link] = [Link]([Link][0]
["Arrival_Time"]);
[Link] = [Link]([Link][0]
["Flight_Number"]);
[Link]([Link]([Link][0]
["Origin"])).Selected = true;
[Link]([Link]([Link][0]
["Destination"])).Selected = true;
}

[Link](fname).Selected = true;
[Link] = fid;
}

protected void lbtnBackHome_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}

protected void btnSubmit_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

57
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class _Default : [Link]

{
string ftype = [Link];
string fid = [Link];
string fname = [Link];

protected void Page_Load(object sender, EventArgs e)

{
ftype = [Link]([Link]["type"]);
fid = [Link]([Link]["id"]);
fname = [Link]([Link]["name"]);
if (!IsPostBack)
{
filldata();
}
}
private void filldata()
{
if (ftype == "International")
{
[Link] = true;
}
else
{
[Link] = true;
}
[Link](fname).Selected = true;
[Link] = fid;

string query = "select Flight_ID,Flight_Number

,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[Kingfisher-International] where Flight_ID='" + fid + "' ";
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
if ([Link] > 0)
{
[Link] = [Link]([Link][0]["Fare"]);
[Link] = [Link]([Link][0]
["Departure_Time"]);
[Link] = [Link]([Link][0]
["Arrival_Time"]);
[Link] = [Link]([Link][0]
["Flight_Number"]);

58
 [Link]([Link]([Link][0]
["Origin"])).Selected = true;
[Link]([Link]([Link][0]
["Destination"])).Selected = true;
}

[Link](fname).Selected = true;
[Link] = fid;
}

protected void lbtnBackHome_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}

protected void btnSubmit_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class _Default : [Link]

{
string ftype = [Link];
string fid = [Link];
string fname = [Link];

protected void Page_Load(object sender, EventArgs e)

{
ftype = [Link]([Link]["type"]);

59
 fid = [Link]([Link]["id"]);
fname = [Link]([Link]["name"]);
if (!IsPostBack)
{
filldata();
}
}
private void filldata()
{
if (ftype == "International")
{
[Link] = true;
}
else
{
[Link] = true;
}
[Link](fname).Selected = true;
[Link] = fid;

string query = "select Flight_ID,Flight_Number

,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[Indigo] where Flight_ID='" + fid + "' ";
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
if ([Link] > 0)
{
[Link] = [Link]([Link][0]["Fare"]);
[Link] = [Link]([Link][0]
["Departure_Time"]);
[Link] = [Link]([Link][0]
["Arrival_Time"]);
[Link] = [Link]([Link][0]
["Flight_Number"]);
[Link]([Link]([Link][0]
["Origin"])).Selected = true;
[Link]([Link]([Link][0]
["Destination"])).Selected = true;
}

[Link](fname).Selected = true;
[Link] = fid;
}

protected void lbtnBackHome_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}

60
 protected void btnSubmit_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class _Default : [Link]

{
string ftype = [Link];
string fid = [Link];
string fname = [Link];

protected void Page_Load(object sender, EventArgs e)

{
ftype = [Link]([Link]["type"]);
fid = [Link]([Link]["id"]);
fname = [Link]([Link]["name"]);
if (!IsPostBack)
{
filldata();
}
}

private void filldata()

{
if (ftype == "International")
{
[Link] = true;
}
else
{
[Link] = true;

61
 }
[Link](fname).Selected = true;
[Link] = fid;

string query = "select Flight_ID,Flight_Number

,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[Spicejet-International] where Flight_ID='" + fid + "' ";
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
if ([Link] > 0)
{
[Link] = [Link]([Link][0]["Fare"]);
[Link] = [Link]([Link][0]
["Departure_Time"]);
[Link] = [Link]([Link][0]
["Arrival_Time"]);
[Link] = [Link]([Link][0]
["Flight_Number"]);
[Link]([Link]([Link][0]
["Origin"])).Selected = true;
[Link]([Link]([Link][0]
["Destination"])).Selected = true;
}

[Link](fname).Selected = true;
[Link] = fid;
}

protected void lbtnBackHome_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}

protected void btnSubmit_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

62
[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class _Default : [Link]

{
string ftype = [Link];
string fid = [Link];
string fname = [Link];

protected void Page_Load(object sender, EventArgs e)

{
ftype = [Link]([Link]["type"]);
fid = [Link]([Link]["id"]);
fname = [Link]([Link]["name"]);
if (!IsPostBack)
{
filldata();
}
}
private void filldata()
{
if (ftype == "International")
{
[Link] = true;
}
else
{
[Link] = true;
}
[Link](fname).Selected = true;
[Link] = fid;

string query = "select Flight_ID,Flight_Number

,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[JetAirways] where Flight_ID='" + fid + "' ";
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);

63
 SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
if ([Link] > 0)
{
[Link] = [Link]([Link][0]["Fare"]);
[Link] = [Link]([Link][0]
["Departure_Time"]);
[Link] = [Link]([Link][0]
["Arrival_Time"]);
[Link] = [Link]([Link][0]
["Flight_Number"]);
[Link]([Link]([Link][0]
["Origin"])).Selected = true;
[Link]([Link]([Link][0]
["Destination"])).Selected = true;
}

[Link](fname).Selected = true;
[Link] = fid;
}

protected void lbtnBackHome_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}

protected void btnSubmit_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

[Link] :-
using System;
using [Link];
using [Link];

64
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class _Default : [Link]

{
string ftype = [Link];
string fid = [Link];
string fname = [Link];

protected void Page_Load(object sender, EventArgs e)

{
ftype = [Link]([Link]["type"]);
fid = [Link]([Link]["id"]);
fname = [Link]([Link]["name"]);
if (!IsPostBack)
{
filldata();
}
}
private void filldata()
{
if (ftype == "International")
{
[Link] = true;
}
else
{
[Link] = true;
}
[Link](fname).Selected = true;
[Link] = fid;

string query = "select Flight_ID,Flight_Number

,Origin,Via,Destination,Departure_Time ,Arrival_Time ,Days,Fare from
[Kingfisher] where Flight_ID='" + fid + "' ";
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
if ([Link] > 0)
{
[Link] = [Link]([Link][0]["Fare"]);
[Link] = [Link]([Link][0]
["Departure_Time"]);

65
 [Link] = [Link]([Link][0]
["Arrival_Time"]);
[Link] = [Link]([Link][0]
["Flight_Number"]);
[Link]([Link]([Link][0]
["Origin"])).Selected = true;
[Link]([Link]([Link][0]
["Destination"])).Selected = true;
}

[Link](fname).Selected = true;
[Link] = fid;
}

protected void lbtnBackHome_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}

protected void btnSubmit_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

[Link] :-
using System;
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];
using [Link];

public partial class _Default : [Link]

{
string ftype = [Link];
string fid = [Link];

66
 string fname = [Link];

protected void Page_Load(object sender, EventArgs e)

{
ftype = [Link]([Link]["type"]);
fid = [Link]([Link]["id"]);
fname = [Link]([Link]["name"]);
if (!IsPostBack)
{
filldata();
}
}

private void filldata()

{
if (ftype == "International")
{
[Link] = true;
}
else
{
[Link] = true;
}
[Link](fname).Selected = true;
[Link] = fid;

string query = "select

Flight_ID,Flight_Number,Origin,Via,Destination,Departure_Time
,Arrival_Time ,Days,Fare from [Spicejet] where Flight_ID='" + fid + "'
";
string constr = "Data Source=.\\SQLEXPRESS;AttachDbFilename=|
DataDirectory|\\[Link];Integrated Security=True;User
Instance=True";
SqlConnection conn = new SqlConnection(constr);
[Link]();
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
[Link](dt);
if ([Link] > 0)
{
[Link] = [Link]([Link][0]["Fare"]);
[Link] = [Link]([Link][0]
["Departure_Time"]);
[Link] = [Link]([Link][0]
["Arrival_Time"]);
[Link] = [Link]([Link][0]
["Flight_Number"]);
[Link]([Link]([Link][0]
["Origin"])).Selected = true;
[Link]([Link]([Link][0]
["Destination"])).Selected = true;
}

[Link](fname).Selected = true;
[Link] = fid;
}

67
 protected void lbtnBackHome_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}

protected void btnSubmit_Click(object sender, EventArgs e)

{
[Link]("[Link]");
}
protected void btnCancel_Click(object sender, EventArgs e)
{
[Link]("[Link]");
}
}

Conclusion

68
The Online Flight Booking System is developed using
[Link] with C# and SQL 2003 server fully meets the
objectives of the system for which it has been
developed. The system has reached a steady state
where all bugs have been eliminated. The system is
operated at a high level of efficiency and the users
associated with the system fully understand its
advantage. The system solves the problem of high
complexity. It was intended to solve as requirement
specification.

Bibliography
1. [Link] 3.5 in C# 2008

69
2. Black book of [Link] 3.5 framework

70