ASP.NET Web Forms Project Report

1. Customer Registration

File: Customer_Registration.aspx and Customer_Registration.aspx.vb

This form allows a new customer to register with the system by entering details such as:

• Full Name
• Email Address
• Phone Number
• Address
• Gender
• Date of Birth

Upon clicking the Register button, the customer's data is inserted into the SQL Server database using parameterized queries to avoid SQL injection.

Backend Functionality:

• Database Connection via connection string
• SQL Command with parameters
• Customer ID is auto-incremented using MAX(CustomerID)+1

2. Flight Search

File: Flight_Search.aspx and Flight_Search.aspx.vb

This page allows the user to search for available flights based on input criteria:

• Schedule ID
• Departure Airport ID
• Arrival Airport ID

Search results are displayed in an asp:GridView after querying the flight schedule table in the database.

Backend Functionality:

• Data retrieved using SqlDataAdapter
• Results bound to a GridView
• Connection string reused for consistency

Technologies Used

• ASP.NET Web Forms (.aspx and VB.NET)
• Microsoft SQL Server
• ADO.NET for database interaction
• HTML/CSS for frontend styling