VIJAYA COLLEGE, JAYANAGAR

(Formerly BHS First Grade College)

4th Block, Jayanagar, Bangalore – 11

Report is submitted for the fulfillment of the requirement

for the Project Work of VI Semester BCA
of
Bengaluru City University
Project on

ONLINE SHOPPING

By

NAGARAJ G B R2017219
NIRANJAN D C R2017222

Under the Guidance

RAMYA S
 VIJAYA COLLEGE, JAYANAGAR
th 4 Block, Jayanagar, Bangalore – 11

CERTIFICATE
This is to certify that the project entitled “ONLINE SHOPPING ” the
bonafide work done by

Name Register Number

NAGARAJA G B R2017219
NIRANJAN D C R2017222

Students of Vijaya College, Jayanagar, Bangalore – 11, in partial fulfillment

of the requirement for Sixth Semester - BCA of Bengaluru City University
for the year 2022 – 2023.

Smt.Ramya s Prof. Sreelatha V M

(Internal Guide) (HOD, Department of Computer Science)

Examiners:
1.
2.
 ACKNOWLEDGEMENT
I, express my sincere thanks to, Smt. D R Sudha, honorable
Principal, for providing me all the facilities for the laboratory and
library.

I, also express my gratitude to Smt. Sreelatha V M, Head of the

Department of Computer Science, for the encouragement given to
me during the project.

I, thank Smt. Ramya S, Internal Guide for the valuable suggestions

and guidance given to me in designing and implementing the
project.

I, also, express my grateful thanks to all the staff members,

Department of Computer Science, for their valuable assistance,
encouragement and co-operation during this wonderful learning
experience.

Finally, I am also very grateful to my parents and friends who have

helped and encouraged me to complete this project successfully.
 CONTENTS
Sl.No. Pg.No.
1. Abstract
2. Introduction
2.1 General Overview of the Project
2.2 Goals of Proposed System
2.3 Introduction about Software
2.3.1 Introduction to Front-end software.
2.3.2 Introduction to Backend software.
3. Hardware Requirements

4. Software Requirement Specification

4.1 Introduction
4.1.1 Purpose
4.1.2 Scope
4.1.3 Definitions, Acronyms and Abbreviations
4.2 Overall Description
4.2.1 Product Perspective
4.2.2 User Characteristics
4.2.3 General Constraints
4.2.4 Assumptions and Dependencies
4.3 Specific Requirements
4.3.1 Functional Requirements
4.3.2 Performance Requirements
4.3.3 Design Constraints

5. Detailed Design
5.1 Entity – Relationship Diagram
5.2 Data Flow Diagram

6. Implementation
6.1 Database Structure
6.2 Source Code
6.3 Screen View

7. Testing and Result

7.1 Objective
7.2 Test Plan
7.3 Levels of Testing
 7.4 Test Cases
7.5 Test Results / Outputs

8. Conclusion
9. Future Enhancements
10. User Manual
11. Bibliography
 ABSTRACT

Now a days the life style of the people is different. People feel uncomfortable
and time consuming for going crowded markets. So, E-Shopping is a boon as
it saves lot of time. Online shopping is a process whereby consumers directly
buy goods, services etc. from a seller without an intermediary service over
the Internet. Shoppers can visit web stores from the comfort of their house
and shop as by sitting in front of the computer. Online stores are usually
available 24 hours a day and many consumers have internet access both at
work and at home. So it is very convenient for them to shop Online. One of
the most enticing factors about online shopping, particularly during holiday
season is, it alleviates the need to wait in long lines or search from a store for
a particular item. Variety of goods are available in online. So the researcher
want to know the preference of the consumers. So fifty respondents were met
and data were collected regarding their preference towards shopping online.

This project is helpful in shopping items online anywhere around the world.
The ordered items will be delivered directly to their address specified by
shopping online. Time spent is less. People can interact with business at any
hour of the day being convenient.

This project is an attempt to provide the advantages of online shopping to

customers of a real shop. It helps buying the products in the shop anywhere
through internet by using an android device. Thus the customer will get the
service of online shopping and home delivery from his favorite shop. This
system can be implemented to any shop in the locality or to multinational
branded shops having retail outlet chains.

If shops are providing an online portal where their customers can enjoy easy
shopping from anywhere, the shops won’t be losing any more customers to
the trending online shops such as flipcart or ebay. Since the application is
available in the Smartphone it is easily accessible and always available.
 INTRODUCTION
General over view of the project

An online shopping project typically involves the creation and development

of a website or application that enables users to browse and purchase products
or services over the internet. The project's general overview can be broken
down into several key components:

User Interface (UI) and User Experience (UX): Designing an intuitive and
visually appealing interface that allows users to navigate the online store
easily. This includes creating product categories, search functionality,
shopping cart, and checkout process.

Product Catalog: Building a comprehensive database that stores information

about the products or services available for purchase. This includes details
like product descriptions, images, pricing, availability, and user reviews.

Shopping Cart and Checkout: Implementing a system that allows users to

add items to their virtual shopping carts, review their selections, and proceed
to the checkout process. This typically involves integrating secure payment
gateways for transaction processing.

User Registration and Authentication: Providing a mechanism for users to

create accounts, log in, and manage their profiles. This may include features
like order history, wish lists, saved addresses, and preferences.

Payment and Security: Integrating secure payment gateways to facilitate

transactions, ensuring that user's financial information is protected.
Implementing security measures, such as SSL encryption and compliance
with relevant data protection regulations, is crucial.

Order Management: Developing a backend system to handle order

processing, inventory management, and order fulfillment. This involves
tracking orders, generating invoices, updating stock levels, and coordinating
shipping or delivery.

Customer Support: Implementing features that enable customers to contact

support for inquiries, returns, or other assistance. This may include options
like live chat, email support, or a dedicated customer service portal.
Analytics and Reporting: Integrating analytics tools to track user behavior,
monitor sales performance, and gather insights for business decision-making.
This can involve collecting data on page views, conversion rates, customer
demographics, and other key metrics.

Scalability and Performance: Building the project with scalability in mind,

allowing it to handle increased traffic and growing product catalogs.
Optimizing the code, implementing caching mechanisms, and utilizing
scalable infrastructure are essential to ensure good performance.

Goals of Proposed System

The goals of a proposed online shopping project can vary depending on the specific
objectives and requirements of the organization or individuals involved. However, some
common goals of an online shopping system can include:

Increased Sales: The primary goal of an online shopping project is to facilitate and boost
sales by providing customers with a convenient and accessible platform to browse and
purchase products. The system aims to attract more customers and encourage them to make
purchases, ultimately increasing revenue for the business.

Improved Customer Experience: Enhancing the overall customer experience is crucial

in online shopping. The proposed system should focus on providing a user-friendly
interface, smooth navigation, quick and secure transactions, comprehensive product
information, and personalized recommendations. A positive customer experience fosters
customer satisfaction, loyalty, and repeat business.

Expanded Market Reach: With an online shopping system, businesses can expand their
reach beyond their physical location and tap into a global customer base. The goal is to
make products accessible to customers from different geographical locations, thereby
increasing market reach and potential sales opportunities.

Efficient Inventory Management: An effective online shopping project should integrate

inventory management capabilities to ensure accurate product availability information.
This helps prevent overselling or underselling of products, minimizes backorders, and
enables timely fulfillment of customer orders.

Streamlined Order Processing: The system should automate and streamline the order
processing workflow, from the moment a customer places an order to its fulfillment. This
includes automated order confirmation, tracking, shipping notifications, and invoicing,
reducing manual effort and improving operational efficiency.

Secure and Reliable Transactions: Ensuring the security of customer data and financial
transactions is of utmost importance. The proposed system should integrate robust security
measures, such as SSL encryption, secure payment gateways, and compliance with
industry standards and regulations (e.g., PCI DSS). Building trust and confidence among
customers is crucial for the success of an online shopping project.
Scalability and Flexibility: The online shopping project should be designed with
scalability and flexibility in mind, allowing it to handle increased traffic, growing product
catalogs, and potential future enhancements. This ensures that the system can adapt and
grow alongside the business requirements.

Customer Support and Engagement: The system should provide channels for customer
support, such as live chat, email, or a dedicated support portal. Prompt and efficient
customer support enhances the overall customer experience and helps resolve queries,
concerns, or issues, fostering customer satisfaction and loyalty.
 Introduction about Software
Introduction to Front-end software.[ASP.NET]:

ASP.NET is a widely used framework for building web applications and websites,
developed by Microsoft. In the context of front-end development, ASP.NET provides
a powerful set of tools and libraries for creating interactive and dynamic user
interfaces.

• Front-end development refers to the client-side of web development, where the focus
is on designing and implementing the user interface that users interact with.
ASP.NET offers several features and components that facilitate front-end
development, including:

• HTML and CSS Support: ASP.NET provides support for HTML (Hypertext Markup
Language) and CSS (Cascading Style Sheets), which are fundamental technologies
used for structuring web content and applying styles and layouts. Developers can
leverage ASP.NET's HTML and CSS capabilities to create visually appealing and
responsive web pages.

• Web Forms: ASP.NET Web Forms is a feature-rich component of the framework that
allows developers to build interactive web applications using server-side controls.
Web Forms abstracts the complexities of web development and provides a drag-and-
drop interface for quickly designing user interfaces. It supports event-driven
programming and provides server-side processing capabilities.

• ASP.NET MVC: ASP.NET MVC (Model-View-Controller) is a pattern and framework

for building web applications that emphasizes separation of concerns. It provides a
structured approach to front-end development, where models represent the data,
views define the user interface, and controllers handle the interaction between
models and views. ASP.NET MVC enables the development of scalable and testable
web applications.

• JavaScript Integration: ASP.NET seamlessly integrates with JavaScript, a popular

programming language for front-end development. Developers can utilize JavaScript
libraries and frameworks, such as jQuery, AngularJS, or React, to enhance the
interactivity and functionality of ASP.NET web applications. ASP.NET provides
integration points for incorporating JavaScript code into the application's front-end
logic.

• Client-Side Validation: ASP.NET offers built-in validation capabilities that allow

developers to validate user input on the client-side. By leveraging JavaScript and
 ASP.NET validation controls, developers can perform real-time validation to ensure
data integrity and enhance user experience without requiring server round-trips.

• Responsive Design: ASP.NET supports responsive design principles, allowing

developers to create web applications that adapt and display optimally across
various devices and screen sizes. This is achieved by utilizing CSS media queries and
implementing responsive layouts and flexible design patterns.
 Introduction to Backend software used.[MYSQL]:

MYSQL is an open-source relational database management system that

works on any platforms. It provides multi-user access to support many storage
engines and is backed by Oracle. The data in a MYSQL database are stored
in tables which consists of columns and rows. MYSQL is a fast, easy to use
RDBMS being used for many small and big businesses. MYSQL is
developed, marketed and supported by MYSQL AB, which is a Swedish
company.

Features of MYSQL:

Ease of Management The software very easily gets downloaded and also uses
an event scheduler to schedule the tasks automatically. Robust Transactional
Support Holds the ACID (Atomicity, Consistency, Isolation, Durability)
property, and also allows distributed multi-version support. Comprehensive
Application Development MYSQL has a plugin libraries to embed the
database into any application. It also supports stored procedures, triggers,
functions, views and many more for application development. High
Performance Provides fast load utilities with distinct memory catches and
table index partitioning. Smart shop 6 Secure Data Protection MYSQL
supports powerful mechanisms to ensure that only authorized users have
access to the databases. High Availability MYSQL can run high-speed
master/slave replication configurations and it offers cluster servers.
Scalability & Flexibility With MYSQL you can run deeply embedded
applications and create data warehouses holding a humongous amount of
data.

SQL statements are divided into following categories:

• Data Definition Language (DDL)statement.

• Data Manipulation Language (DML)statement.
• Transaction control statement
• Session control statement.
• System control statement.
• Embedded control statement.
DATA DEFINITON LANGUAGE (DDL):
DDL statements define, maintain and drop objects when they are no longer
needed. DDL statements also include statements that permit a user to grant
other privileges or rights to access the database and specific objects with in
the database.

DATA MANIPULATION LANGUAGE (DML):

DML statements manipulate the database data. Update and deleting rows of
a table are all DML operations. Looking at a table or view and examining the
execution of the plan of an SQL statement is also a DMLoperation.

TRANSACTION CONTROL STATEMENT:

Transaction control statement manages the changes made by the DML
statement. They allow the user or application developer to group changes into
logical transactions.

SESSION CONTROL STATEMENT:

Session control statement allows the user to control the properties of
this current session, enabling and disabling role and changing language
settings. Two-session control statements are ALTER SESSION and
SET ROLE.

SYSTEM CONTROL STATEMENT:

A system control command is the properties of the oracle server instance. The
only system control command is ALTER SYSTEM it allows you to change
the minimum number of shared servers, to kill a session and to
per for mother tracks.
 HARDWARE REQUIREMENTS

Processor : Intel i3 or above

Clock Speed : 2 GHz

RAM : 8GB

Hard disk Capacity : 500GB

SOFTWARE REQUIREMENTS

Front End : ASP.NET

Operating System : Intel i3 or above

Back End : SQL Server

Operating System : Windows 10 or above

 SOFTWARE REQUIREMENT SPECIFICATION
The software requirement specification is produced at the culmination of the
analysis task. The function and performance allocated to the software as a
part of system engineering are refined by establishing a complete information
description, a detailed functional and behavioural description, and indication
of performance requirements and design constraints, appropriate validation
criteria and other pertinent to requirements.

Purpose: The "Online shopping" project an automated online assistant, with

potential to enhance user interface on shopping sites. It is mainly used to store
the details of user details, stock and shipping details and very easy to calculate
net profit and credit. It provides the facility where in the admin generates
report on shipping and shopping details of customers which have been stored.

Scope:
The scope of the system is mainly maintaining the clothing and accessories
in proper manner. t maintains the details and shipping details of the users.

Definition and Acronyms:

UID: User Information Module Identification DFD: Data Flow Diagram ER:
Entity Relationship

Abbreviations:
The abbreviation for Software Specification Requirements is commonly
represented as SRS. SRS stands for Software Requirements Specification,
which is a document that outlines the functional and non-functional
requirements of a software system. The SRS document serves as a reference
for developers, stakeholders, and other project members to understand and
implement the software according to the specified requirements.
 OVERALL DESCRIPTION
Product Perspective:

The customer/user may use any of the web browsers and enter the web address,
from which they want to shop. Looking through the list of items provided along
with the rate, the customer can select any of it. Next the customer is requested to
enter the quantity of items he wishes to buy. Depending on this, the total amount is
displayed and also provides discount if any and finally the net amount is displayed.
Next is the payment procedure. The customer can pay cash on delivery or through
his credit card. The system also asks for the address to where the goods have to be
delivered. As soon as he provides his credit card number, its details are checked. If
the details are correct, then the sales procedure is authorized.
The “Online Supermarket” normally doesn’t have items in their warehouse. They
order it from a distributor and the items are dispatched to the customer. A bill will
be sent to the customer by the credit card company and vendors account will be
credited.
Admin provides a unique username and password for each employee through which
he can login. Admin also has the authority to add details of the items to be sold.
And he also has the right to edit or delete that information to/from the list.

Modules:

➢ Product: The admin has the authority to add or delete product details.
He also has the right to modify those details.
➢ Customer: At first the customer is supposed to enter his complete
details.
➢ Registration: As soon as the customer fills his complete details, the
admin provides unique username and password to him so that he can
login and can shop at any time.
➢ Shopping: The customer can select the items and put it into a trolley
provided and as soon as he clicks on “finish”, the total amount to be
paid is displayed and also provides discount if any.
➢ Payment: The customer can pay cash on delivery o else he can pay by
entering his credit card number and address to which the items have
to be shipped. If the payment is by credit card, the details of the credit
card are checked. If that particular credit card number is correct, then
the company authorizes the sale and the customer will receive an
acknowledgement.
 ➢ Indent Report: Here data will be available to know about the orders
taken by the customer in a day/month/year and this report can be
used for future verification purpose.
➢ Display: The user can view information regarding the items available
and its price details.
➢ Logout: This module allows the user to Logout the application. Further
operations cannot be performed after user exits.

User Characteristics:

• More informed. The digital consumer searches before buying.

• More connected. The digital consumer is connected at any time and
any place, mainly because of the growing use of mobile devices.
• Less impulsive.
• More exigent.
• More participative.

General Constraints:

Limitations on the developer's option include

•Developing the system, this meets the SRS and solving all the requirements
of the system.

•Demonstrating the system and installing the system at client's location after
the acceptance testing is successful inSubmitting the required user manual
describing the system interfaces to work on it and also the documents of the
system.

•Conducting any user training that might be needed for using the system.

•Maintaining the system for a period of one year after installation.

Assumptions and Dependencies:

ER-Modelling to concentrate on the relational states existing upon the

system with respect to cardinality.
The physical dispense, which state the overall data search for the relational
key where as a transaction is implemented on the wear entities.
Unified modelling language concepts to give a generalized blue print for the
overall system.

.The standards of flow chart at the required states that are the functionality of
the operations need more concentration.

Specific Requirements

Functional Requirements:

The functional requirements are the high level functionality of the system
here the function requirements of the central system monitoring all the
activities of the organization for storing the details
of the database.

Performance Requirements:

A performance requirement is a statement of how much a function must be

executed, generally measured in terms such as quantity, accuracy, coverage,
timeliness, or readiness. The performance requirements for the operational
function and sometimes a few others often correlate well with the statement
of the needed operational capability developed by the Joint Capabilities
Integration and Development System (JCIDS) Process. The statement of
other performance requirements usually requires thorough systems
engineering.

Design Constraints:

Design constraints are limitations or restrictions in the design process

imposed by internal and external factors. These constraints impact the final
product, so it’s critical that everyone in the organization is aware of them and
considers these limitations before every project.

Common types of design constraints include:

• Technical constraints
• Financial constraints
• Talent constraints
• Project-specific constraints
DETAILED DESIGN
DETAILED DESIGN

Design is a multi-steps process that focuses on data structure, software,

software architecture, external details and interface between the modules. The
design processes also translate the requirements into representation of
software that can be accessed for quality before coding begins.

However techniques for software design do exist, criteria for design qualities
are available and design notation can be applied. Once software requirements
have been analysed and specified, software design is the first of three
activities- Design, code, test, that are required to build and verify software.
Each activities transform information in a manner that ultimately results in a
validation of computer software. The importance software design can be
started with a single word quality. Design is the place where quality fostered
in software development. Design provides us with the representations of the
software that can be accessed for quality.

Design the only way that we can accurately translate a customer's requirement
into a finished software product or system. Without design, risk of building
an unstable system exists-one that will fail when small changes are made one
that may be difficult to test.

Internal Design

The input design is the link between the information system and the users. It
comprises the directing specification and procedures for data preparations and
those steps that are necessary to put transaction data into a usable form for
processing data entry.

The designs of inputs focuses on controlling the amount of inputs required,

controlling errors, avoiding delay, avoiding extra steps and keeping the
process simple.

System analyst decides the following input designs details :

• Why data to input?

• What medium to use?
• How the data should be arranged or coded?
• The dialogue to guide users in providing input.

Several activities have to be carried out as part of the overall input process.
They include some or all of the following stages
 • Data recording (that is, collection of data at its source);
• Data transcription (that is, transfer of data to an input form);
• Data conversion (that is, checking the conversion);
• Data control (that is, checking the accuracy and controlling the flow of
the data to the computer);
• Data transmission (that is, transmitting or transporting the data to the
computer);
• Data validation (that is, checking the input data by program when it
• enters the computer system);
• Data correction (that is, correcting the errors that are found at any of
the
• earlier stages).

External Design

Designing computer output should proceed in an organized, well thought out

manner. The term output applies to any information produced by an
information system whether printed or displayed. When analyst designs
what are tcomputer output, they identified the specific output is needed to
meet the information requirements.

Computer output is the most important and direct source of information to the
user. Output design is a process that involves designing necessary outputs that
have to be various users according to their requirements.

Efficient intelligent output design should improve the systems relationship

with the users and help in decision-making. Since the reports are directly
required by the management for taking decisions and to draw conclusions,
they must be designed with utmost care and the details in the records must be
simple, descriptive and clear to the user.

The options for the outputs and reports are given in the systems menu. When
designing output, system analyst must accomplish the following:
• Determine the information to present.
• Decide whether to display or print the information and select the
output medium.
• Arrange the present of information acceptable format.
• Decide how to distribute the output to intended receipts.
• Architectural Design
 Entity – Relationship Diagram
Entity-Relationship Diagram: This depicts relationship between data objects.
The attribute of each data objects noted in the entity-relationship diagram can
be described using a data object description. Data flow diagram serves two
purposes:

1. To provide an indication of how data are transformed as they move

through the system.

2. To depict the functions that transformation the data flow. Data Objects:
A data object is a representation of almost any composite information
that must be understood by the software. By composite information,
we mean something that has a number of different properties or
attributes. A data object encapsulates data only there is no reference
within a data object to operations that act on the data.

Attributes: Attributes define the properties of a data object and take on one
of three different characteristics. They can be used to: Name an instance of
data object. Describe the instance. Make reference to another instance in other
table.

Relationships: Data objects are connected to one another in a variety of

different ways. We can define a set of object relationship pairs that define the
relevant relationships.
ENTITY RELATIONSHIP DIAGRAMS
 Data Flow Diagram
A data flow diagram (DFD) is a graphical representation of the "flow" of
data through an information system. It differs from the flowchart as it shows
the data flow instead of the control flow of the program. A data flow
diagram can also be used for the visualization of data processing (Structured
design). Data flow diagrams were invented by Larry Constantine, the
original developer of structured design, based on
Martin and Estrin's "data flow graph" model of computation.

It is common practice to draw a context-level data flow diagram first which

shows the interaction between the system and outside entities. The DFD is
designed to show how a system is divided into smaller portion and to
highlight the flow of data between those parts. This context-level data flow
diagram is then "exploded" to show more details of the system being
modelled.

Data flow diagrams are concerned with designing a sequence of functional

transformation that converts system inputs into the required outputs. The
design is represented as dataflow diagrams.

Data flow diagrams are a useful and intuitive way of describing a system.
They are normally understandable without special training, especially
controls information is excluded. They show end to end processing; that is
flow of processing form when data enters the system to where it leaves the
system can be traced.

Definition

1. Rectangle with rounded edge: Represent function which transform

inputs to outputs.
2. Rectangles: It represents data stores again they should be given a
descriptive name.
3. Circles: It represents user interaction with the system which provides
input or receives outputs.
4. Arrows: Show the direction of dataflow. Their name describes the data
flowing along that path.
DATA FLOW DIAGRAM
 IMPLEMENTATION
DATABASE STRUCTURE
Table name: Admin login
Attributes Data type Size

u varchar 100

p varchar 100

Table name: Cart temp

Attributes Data type Size

pid varchar 100

pdesc varchar 100

rate varchar 100

pic varchar 100

qty varchar 100

emailid varchar 100

Table name: Contact us

Attributes Data type Size

fullname varchar 100

Email varchar 100

mobile varchar 100

Table name: Feedback
Attributes Data type Size

fullname varchar 100

Email varchar 100

mobile varchar 100

feedback varchar 100

Table name: Order track

Attributes Data type Size

billno varchar 100

Email varchar 100

dod varchar 100

dboy varchar 100

Table name: Payments

Attributes Data type Size

billno varchar 100

Bdate varchar 100

famt varchar 100

emailid varchar 100

fullname varchar 100

addr varchar 100

phno varchar 100

 status varchar 100

Table name: Products

Attributes Data type Size

Pid varchar 100

Pdesc varchar 100

rate varchar 100

pic varchar 100

category varchar 100

Table name: signup

Attributes Data type Size

fullname varchar 100

phno varchar 100

addr varchar 100

emailid varchar 100

pwd varchar 100

 SOURCE CODE

Index page(front page):

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<title>ONLINE SHOPPING</title>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"

/>

<link rel="stylesheet" type="text/css" href="css/style.css"/>

</head>

<body>

<div id="mainblock">

<!--inner block starts here -->

<div id="innerblock">

<div id="toppanel" align="center">

<img src="images/tp_logo" width="238" height="54" alt=""

class="tp_logo" /> <img src="images/shopping.jpeg" width="23"
height="21" alt="" class="tp_shopping_img" /> <a href="#"
class="tp_txt1">

Items<br />

&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;0 items
 </a> <a href="#" class="tp_txt2">sign in :: Register</a>

<div class="tp_menu_tile"> <a href="index.html"

class="tp_menu1">Home Page</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" />

<a href="about.aspx" class="tp_menu2">About</a> <img

src="images/" width="2" height="39" alt="" class="tp_divider" />

<a href="adminlogin.aspx" class="tp_menu2">Admin</a> <img

src="images/" width="2" height="39" alt="" class="tp_divider" />

<a href="guestlogin.aspx" class="tp_menu2">Guest</a>

<img src="images/" width="2" height="39" alt="" class="tp_divider"

/> <a href="contact1.aspx" class="tp_menu2">Contact Us</a>

<img src="images/" width="2" height="39" alt="" class="tp_divider"

/> <a href="ourstore.aspx" class="tp_menu2">Our Store</a> </div>

<div class="tp_tile2">

<img src="images/dought (1).png" width="15" height="15" alt=""

class="tp_btn1" />

<p class="tp_heading">Photo Gallery</p>

</div>

<div class="tp_block"><img src="images/cart.png" width="140"

height="135" alt="" class="tp_image01" /></div>

<div class="tp_block1"><img src="images/pay.png" width="140"

height="135" alt="" class="tp_image01" /></div>

<div class="tp_block1"><img src="images/pac.png" width="140"

height="135" alt="" class="tp_image01" /></div>

<div class="tp_block1"><img src="images/del.png" width="140"

height="135" alt="" class="tp_image01" /></div>

</div>

<div id="contentblock">
 <div id="leftpanel">

<div class="lp_block">

<div class="lp_tile">

<img src="images/dought (1).png" width="15" height="15"

alt="" class="lp_btn1" />

<p class="lp_heading">Categories</p>

</div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif"

width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothwears</a> </div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif"

width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electronics</a> </div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif"

width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif"

width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Books</a> </div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif"

width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif"

width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical products</a> </div>

</div>

<div class="lp_block1">

<div class="lp_tile">
 <img src="images/dought (1).png" width="15" height="15"
alt="" class="lp_btn1" />

<p class="lp_heading">Categories</p>

</div>

<p class="lp_txt">

<span style="color:#FB0616;">If you have any questions

contact us.</span><br />

17/4568, southend circle,<br />

Jayanagara Road,<br />

Bangalore-560 068<br />

Ph : 1234 5678<br />

E-mail : [email protected]

</p>

</div>

<a href="http://all-free-download.com/free-website-
templates/"><img src="images/lp_image.gif" width="279" height="129"
alt="" class="lp_image" /></a>

</div>

<div id="contentpanel">

<div style="float:left; ">

<div class="cnt_tile2">

<img src="images/dought (1).png" width="15" height="15"

alt="" class="tp_btn1" />

<p class="tp_heading">Description</p>

</div>

<div class="cnt_block1">
 <div style="float:left; display:inline; width:400px;">

<p class="cnt_txt1">

Name : Niranjan D C<br />

RRP : US $75.99/-<br />

Origin : Made in Bangalore<br />

Size : 3.5"*2.75"

</p>

<p class="cnt_txt2">"Our Project is An E-Commerce

Website. The goal of this Online shopping website is to facilitate the
customers to buy products online with ease of "Click N Buy". It's a process
of implementing all the activities of the Shopping in an electronic and
computerized automated way to fasten the performance with ease to the next
procedure"</p>

</div>

<img src="images/cnt_image2.jpeg" width="135"

height="115" alt="" class="cnt_image1" />

</div>

</div>

<div style="float:left;">

<div class="cnt_tile2">

<img src="images/dought (1).png" width="15" height="15"

alt="" class="tp_btn1" />

<p class="tp_heading">Shipping &amp; Handling</p>

</div>

<div class="cnt_block1">

<img src="images/lp_btn2.gif" width="6" height="5" alt=""

class="cnt_btn4" />
 <p class="cnt_txt3">We built the operations network from
the ground up to ensure customers receive what they need, when they need it,
wherever they are.</p>

<img src="images/lp_btn2.gif" width="6" height="5" alt=""

class="cnt_btn4" />

<p class="cnt_txt3">From a veteran loading cargo into the

belly of driver who delivers that familiar box, it's the people and partners
across our operations network who make it all possible.</p>

<img src="images/lp_btn2.gif" width="6" height="5" alt=""

class="cnt_btn4" />

<p class="cnt_txt3">Follow along as we introduce you to the

next procedure</p>

</div>

</div>

<div style="float:left;">

<div class="cnt_tile2">

<img src="images/dought (1).png" width="15" height="15"

alt="" class="tp_btn1" />

<p class="tp_heading">Payments Details</p>

</div>

<div class="cnt_block1">

<p class="cnt_txt4">provides payment options like cash on

delivery, credit card, debit card, net banking . For availing cash on delivery
option, the buyer needs to fulfill some criteria. Cash on delivery option is only
on purchases between Rs.</p>

<p class="cnt_payment"><strong>Payment
Method</strong></p>

<img src="images/cnt_paypal.gif" width="203" height="33"

alt="" class="cnt_paypal" />
 </div>

</div>

<div style="float:left; padding-bottom:20px;">

<div class="cnt_tile2">

<img src="images/dought (1).png" width="15" height="15"

alt="" class="tp_btn1" />

<p class="tp_heading">Terms &amp; Condtions</p>

</div>

<div class="cnt_block1">

<img src="images/dought (1).png" width="6" height="5"

alt="" class="cnt_btn4" />

<p class="cnt_txt3"><strong>Delivery
Details</strong>Track courier provides an online automatic tracking system
to track Delhivery Courier shipments. You can track the current status of the
parcel instead of visiting the courier location or calling customer service
center</p>

<img src="images/lp_btn2.gif" width="6" height="5" alt=""

class="cnt_btn4" />

<p class="cnt_txt3"><strong>Refunds</strong>Items cost

will be refunded once the order is cancelled successfully by the
customer"T&C"</p>

<img src="images/lp_btn2.gif" width="6" height="5" alt=""

class="cnt_btn4" />

<p class="cnt_txt3"><strong>Customer Services</strong>In

case of enquire contact or mail to the customer service by clicking the below
link</p>

<a href="contact1.aspx" class="cnt_readmore">read

more</a>

</div>
 </div>

</div>

</div>

<div id="footerpanel">

<div id="footerblock">

<a href="index.html" class="fp_txt">Home Page</a>

<p class="fp_divi">|</p>

<a href="ourstore.aspx" class="fp_txt">Payments</a>

<p class="fp_divi">|</p>

<a href="about.aspx" class="fp_txt">About us</a>

<p class="fp_divi">|</p>

<a href="ourstore.aspx" class="fp_txt">Terms</a>

<p class="fp_divi">|</p>

<a href="contact1.aspx" class="fp_txt">Contact Us</a>

<p class="fp_divi">|</p>

<a href="ourstore.aspx" class="fp_txt">Our Store</a>

<p style="display:block; width:100%; color:#FFFFFF; margin:0;

padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved. <a href="http://www.buytemplates.net/CSS-XHTML-web-
templates.aspx" style="color:#ffffff;"></a></p>

</div>

</div>

<!--inner block ends up -->

</div>

</div>

<!--main block ends up -->

</html>

Admin Login:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Admin login</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
font-size: x-large;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel"> <img src="images/tp_logo" width="238"
height="54" alt="" class="tp_logo" /> <img src="images/shopping.jpeg"
width="23" height="21" alt="" class="tp_shopping_img" /> <a href="#"
class="tp_txt1">Items<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;0 items</a> <a href="#" class="tp_txt2">sign in ::
Register</a>
<div class="tp_menu_tile"> <a href="index.html"
class="tp_menu1">Home Page</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" /> <a href="about.aspx"
class="tp_menu2">About</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="adminlogin.aspx"
class="tp_menu2">Admin</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="guestlogin.aspx"
class="tp_menu2">Guest</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="contact1.aspx"
class="tp_menu2">Contact Us</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" /> <a href="ourstore.aspx"
class="tp_menu2">Our Store</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif"

width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothwears</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electronics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Books</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>
 <div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical products</a> </div>
</div>
<div class="lp_block1">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading">ADMINISTRATOR LOGIN </p>
<br />
<br /><br />
<br /><br />

<br />
<table class="style1">
<tr>
<td>
Email Id or UserName</td>
<td>
<asp:TextBox ID="TextBox1"
runat="server"></asp:TextBox>
&nbsp;
<asp:RequiredFieldValidator
ID="RequiredFieldValidator1" runat="server"
ControlToValidate="TextBox1"
ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
Password</td>
 <td>
<asp:TextBox ID="TextBox2" runat="server"
TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator2" runat="server"
ControlToValidate="TextBox2"
ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
<asp:Button ID="Button1" runat="server" Text="Login"
onclick="Button1_Click" />
</td>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
&nbsp;</td>
<td>
&nbsp;</td>
<td>
&nbsp;</td>
</tr>
</table>
</div>

</div>
</div>
<div style="float:left;">
</div>
</div>
<div id="footerpanel">
<div id="footerblock"> <a href="index.html" class="fp_txt">Home
Page</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Payments</a>
 <p class="fp_divi">|</p>
<a href="about.aspx" class="fp_txt">About us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Terms</a>
<p class="fp_divi">|</p>
<a href="contact1.aspx" class="fp_txt">Contact Us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Our Store</a>
<p style="display:block; width:100%; color:#FFFFFF; margin:0;
padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved.</p>
</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>

</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class adminlogin : System.Web.UI.Page

{

SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{
 }
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

string s = "select * from adminlogin where u=" + "'" + TextBox1.Text

+ "'" + " and p=" + "'" + TextBox2.Text + "'";

con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;
String name = "", mobile = "", address = "";
while (reader.Read())
{
ctr++;

}
reader.Close();
con.Close();
if (ctr == 1)
{

Session["logname"] = TextBox1.Text.Trim();

Response.Redirect("adminpage.aspx");
}
else
{
 Response.Write("<script>alert('Login
Failed');window.location='index.html';</script>");
}

}
catch (Exception ex)
{
Label1.Text = ex.ToString();
}
}
}

Admin Page:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Admin Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.auto-style1 {
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel">
<div class="tp_menu_tile"> <a href="adminpage.aspx"
class="tp_menu1">Home </a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" />
<a href="products.aspx" class="tp_menu2">Products</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="editproducts0.aspx" class="tp_menu2">Edit Products</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="orders.aspx" class="tp_menu2">Orders</a>
 <img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="guests.aspx" class="tp_menu2">Guests</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider"
/> <a href="contacts.aspx" class="tp_menu2">Contact</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="index.html" class="tp_menu2">Logout</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothwears</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electronics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Collection Books</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>
 <div class="rp_listblock"> <img src="images/lp_btn2.gif"
width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical products</a> </div>

</div>
<div class="lp_block1">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading">WELCOME TO&nbsp; ADMINISTRATOR
PAGE </p>
<br /> <br />
<table class="auto-style1">
<tr>
<td>Search Reports&nbsp; Upon</td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>MONTHLY</asp:ListItem>
<asp:ListItem>YEARLY</asp:ListItem>
</asp:DropDownList>
<asp:Button ID="Button1" runat="server" Text="Search"
OnClick="Button1_Click" />
</td>
</tr>
<tr>
<td colspan="2">
<asp:GridView ID="GridView1" runat="server"
CellPadding="4" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" />
<FooterStyle BackColor="#990000" Font-Bold="True"
ForeColor="White" />
<HeaderStyle BackColor="#990000" Font-Bold="True"
ForeColor="White" />
 <PagerStyle BackColor="#FFCC66"
ForeColor="#333333" HorizontalAlign="Center" />
<RowStyle BackColor="#FFFBD6"
ForeColor="#333333" />
<SelectedRowStyle BackColor="#FFCC66" Font-
Bold="True" ForeColor="Navy" />
<SortedAscendingCellStyle BackColor="#FDF5AC" />
<SortedAscendingHeaderStyle BackColor="#4D0000" />
<SortedDescendingCellStyle BackColor="#FCF6C0" />
<SortedDescendingHeaderStyle BackColor="#820000"
/>
</asp:GridView>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
</tr>
</table>
<br />
<br /><br />
<br /><br />

<br />
</div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<div id="footerpanel">
<div id="footerblock"> <a href="index.html" class="fp_txt">Home
Page</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Payments</a>
<p class="fp_divi">|</p>
<a href="about.aspx" class="fp_txt">About us</a>
 <p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Terms</a>
<p class="fp_divi">|</p>
<a href="contact1.aspx" class="fp_txt">Contact Us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Our Store</a>
<p style="display:block; width:100%; color:#FFFFFF; margin:0;
padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved. </p>
</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class adminpage : System.Web.UI.Page

{

SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{

protected void Button1_Click(object sender, EventArgs e)

 {
if (DropDownList1.Text == "YEARLY")
{
try
{
string cdate = DateTime.Now.Year.ToString();
Label1.Text = cdate;
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

string s = "select * from payment2 where bdate like '%2023'";

con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;
double d = 0;
while (reader.Read())
{

ctr++;
d = d + Convert.ToDouble(reader.GetString(2));

}
reader.Close();
con.Close();

if (ctr > 0)
{
con.Open();
SqlCommand cmd2 = new SqlCommand(s, con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
da = new SqlDataAdapter(cmd2);
da.Fill(dt);
 GridView1.DataSource = dt;
GridView1.DataBind();

con.Close();
}
else
{
Label1.Text = "Sorry No Order details yet...";
}
Label1.Text = "TOTAL ORDER AMOUNT IS Rs."+ d;
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
}
}
else if(DropDownList1.Text=="MONTHLY")
{

try
{
string cdate = DateTime.Now.Month.ToString();
Label1.Text = cdate;
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

string s = "select * from payment2 where bdate like '%" +

Label1.Text +"%'";

con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;
double d = 0;
while (reader.Read())
{
 ctr++;
d = d + Convert.ToDouble(reader.GetString(2));
}
reader.Close();
con.Close();

if (ctr > 0)
{

con.Open();
SqlCommand cmd2 = new SqlCommand(s, con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
da = new SqlDataAdapter(cmd2);
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

con.Close();
}
else
{
Label1.Text = "Sorry No Order details yet...";
}
Label1.Text = "TOTAL AMOUNT COLLECTED IS Rs. " + d;
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
}

}
}

Add products:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Product</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel">
<div class="tp_menu_tile"> <a href="adminpage.aspx"
class="tp_menu1">Home </a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" />
<a href="products.aspx" class="tp_menu2">Products</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="editproducts0.aspx" class="tp_menu2">Edit Products</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="orders.aspx" class="tp_menu2">Orders</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="guests.aspx" class="tp_menu2">Guests</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider"
/> <a href="contacts.aspx" class="tp_menu2">Contact</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="index.html" class="tp_menu2">Logout</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
 <div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothwear</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electronics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Books</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical products</a> </div>
</div>
<div class="lp_block1">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
 <p class="tp_heading">WELCOME TO&nbsp; ADMINISTRATOR
PAGE </p>
<br />
<br /><br />
<br /><br />

<br />
<table class="style1">
<tr>
<td colspan="2" style="text-align: center">
Add Products</td>
</tr>
<tr>
<td>
Product Id</td>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td>
Product Description</td>
<td>
<asp:TextBox ID="TextBox1"
runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Rate</td>
<td>
<asp:TextBox ID="TextBox2"
runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Photo</td>
<td>
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>
</tr>
<tr>
 <td>
Category</td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>Clothwears</asp:ListItem>
<asp:ListItem>Electronics</asp:ListItem>
<asp:ListItem>Beauty products</asp:ListItem>
<asp:ListItem>Books</asp:ListItem>
<asp:ListItem>Toys</asp:ListItem>
<asp:ListItem>Musical Products</asp:ListItem>
<asp:ListItem></asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
<asp:Button ID="Button1" runat="server"
onclick="Button1_Click"
Text="Add Products" />
&nbsp;<asp:Button ID="Button2" runat="server" onclick="Button2_Click"
Text="Save Product Details" />
</td>
<td>
<asp:Label ID="Label2" runat="server"></asp:Label>
</td>
</tr>
</table>
</div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<div id="footerpanel">
<div id="footerblock"> <a href="http://all-free-download.com/free-
website-templates/" class="fp_txt">Home Page</a>
<p class="fp_divi">|</p>
 <a href="http://all-free-download.com/free-website-templates/"
class="fp_txt">Payments</a>
<p class="fp_divi">|</p>
<a href="http://all-free-download.com/free-website-templates/"
class="fp_txt">Shipping</a>
<p class="fp_divi">|</p>
<a href="http://all-free-download.com/free-website-templates/"
class="fp_txt">Terms</a>
<p class="fp_divi">|</p>
<a href="http://all-free-download.com/free-website-templates/"
class="fp_txt">Contact Us</a>
<p class="fp_divi">|</p>
<a href="http://all-free-download.com/free-website-templates/"
class="fp_txt">Our Store</a>
<p style="display:block; width:100%; color:#FFFFFF; margin:0;
padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved. <a href="http://www.buytemplates.net/CSS-XHTML-web-
templates.aspx" style="color:#ffffff;"></a></p>
</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>
</html>

C#:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class products : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
 protected void Page_Load(object sender, EventArgs e)
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

}
protected void Button1_Click(object sender, EventArgs e)
{
try
{

string s = "select * from product ";

con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 100;
while (reader.Read())
{
ctr++;

}
reader.Close();
con.Close();
Label1.Text = ctr.ToString();

}
catch (Exception ex)
{
Label1.Text = ex.ToString();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{

String s = "insert into product values(@a,@b,@c,@d,@e)";

SqlCommand cmd1 = new SqlCommand(s, con);
 cmd1 = new SqlCommand(s, con);

cmd1.Parameters.Add("@a", Label1.Text);
cmd1.Parameters.Add("@b", TextBox1.Text);
cmd1.Parameters.Add("@c", TextBox2.Text);
cmd1.Parameters.Add("@d", FileUpload1.FileName);
cmd1.Parameters.Add("@e", DropDownList1.Text);

con.Open();
cmd1.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('Added
Successfully');window.location='adminpage.aspx';</script>");

}
catch (Exception ex)
{

Label1.Text = ex.ToString();

}
}
}

Edit Products:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Edit product</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">

.style1
{
 width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel">
<div class="tp_menu_tile"> <a href="adminpage.aspx"
class="tp_menu1">Home </a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" />
<a href="products.aspx" class="tp_menu2">Products</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="editproducts0.aspx" class="tp_menu2">Edit Products</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="orders.aspx" class="tp_menu2">Orders</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="guests.aspx" class="tp_menu2">Guests</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider"
/> <a href="contacts.aspx" class="tp_menu2">Contact</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="index.html" class="tp_menu2">Logout</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
 </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothweras</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electronics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Books</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif"
width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical products</a> </div>
</div>
<div class="lp_block1">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading">WELCOME TO&nbsp; ADMINISTRATOR
PAGE </p>
<br />
<br /><br />
<br /><br />

<table class="style1">
<tr>
<td colspan="2" style="text-align: center">
 Edit Products</td>
</tr>
<tr>
<td>
Product Id</td>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td>
Product Description</td>
<td>
<asp:TextBox ID="TextBox1"
runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Rate</td>
<td>
<asp:TextBox ID="TextBox2"
runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
Photo</td>
<td>
<asp:FileUpload ID="FileUpload1" runat="server" />
</td>
</tr>
<tr>
<td>
Category</td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>Clothwears</asp:ListItem>
<asp:ListItem>Electronics</asp:ListItem>
<asp:ListItem>Beauty products</asp:ListItem>
<asp:ListItem>Books</asp:ListItem>
<asp:ListItem>Toys</asp:ListItem>
<asp:ListItem>Musical Products</asp:ListItem>
 </asp:DropDownList>
</td>
</tr>
<tr>
<td>
&nbsp;<asp:Button ID="Button2" runat="server" onclick="Button2_Click"
Text="Update Product Details" />
</td>
<td>
<asp:Label ID="Label2" runat="server"></asp:Label>
</td>
</tr>
</table>

<br />
</div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<div id="footerpanel">
<div id="footerblock"> <a href="index.html" class="fp_txt">Home
Page</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Payments</a>
<p class="fp_divi">|</p>
<a href="about.aspx" class="fp_txt">About us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Terms</a>
<p class="fp_divi">|</p>
<a href="contact1.aspx" class="fp_txt">Contact Us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Our Store</a>
<p style="display:block; width:100%; color:#FFFFFF; margin:0;
padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved.</p>
</div>
 </div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>

</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class editproducts : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
string id = "";
protected void Page_Load(object sender, EventArgs e)
{
Label1.Text=Request.QueryString.Get(0);
try
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

string s = "select * from product where pid=" + "'" + Label1.Text +

"'";
 con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();

while (reader.Read())
{

}
reader.Close();
con.Close();

}
catch (Exception ex)
{
Label1.Text = ex.ToString();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{

string s = "update product set

pdesc=@a,rate=@b,pic=@c,category=@d where
pid="+"'"+Label1.Text+"'";
SqlCommand cmd11 = new SqlCommand(s, con);
cmd11.Parameters.Add("@a", TextBox1.Text);
cmd11.Parameters.Add("@b", TextBox2.Text);
cmd11.Parameters.Add("@c", FileUpload1.FileName);
cmd11.Parameters.Add("@d", DropDownList1.Text);
con.Open();
cmd11.ExecuteNonQuery();
con.Close();
Label2.Text = "Product updated successfully";

}
catch (Exception ex)
{
 Label2.Text = ex.ToString();
}
}
}

ORDERS:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Orders</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
}
.auto-style1 {
width: 268px;
}
.auto-style2 {
height: 33px;
}
.auto-style3 {
width: 268px;
height: 33px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel">
<div class="tp_menu_tile"> <a href="adminpage.aspx"
class="tp_menu1">Home </a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" />
<a href="products.aspx" class="tp_menu2">Products</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
 <a href="editproducts0.aspx" class="tp_menu2">Edit Products</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="orders.aspx" class="tp_menu2">Orders</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="guests.aspx" class="tp_menu2">Guests</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider"
/> <a href="contacts.aspx" class="tp_menu2">Contact</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="index.html" class="tp_menu2">Logout</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothwears</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electronics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Books</a> </div>
 <div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical products</a> </div>
</div>
<div class="lp_block1">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading">WELCOME TO&nbsp; ADMINISTRATOR
PAGE </p>
<br />
<br /><br />
<br />
<table class="style1">
<tr>
<td>
<asp:GridView ID="GridView1" runat="server"
BackColor="White"
BorderColor="#3366CC" BorderStyle="None"
BorderWidth="1px" CellPadding="4">
<FooterStyle BackColor="#99CCCC"
ForeColor="#003399" />
<HeaderStyle BackColor="#003399" Font-Bold="True"
ForeColor="#CCCCFF" />
<PagerStyle BackColor="#99CCCC"
ForeColor="#003399" HorizontalAlign="Left" />
<RowStyle BackColor="White" ForeColor="#003399" />
<SelectedRowStyle BackColor="#009999" Font-
Bold="True" ForeColor="#CCFF99" />
<SortedAscendingCellStyle BackColor="#EDF6F6" />
 <SortedAscendingHeaderStyle BackColor="#0D4AC4"
/>
<SortedDescendingCellStyle BackColor="#D6DFDF" />
<SortedDescendingHeaderStyle BackColor="#002876"
/>
</asp:GridView>
</td>
<td class="auto-style1">
&nbsp;</td>
</tr>
<tr>
<td style="text-align: center">
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
<td class="auto-style1">
&nbsp;</td>
</tr>
<tr>
<td style="text-align: center">
UPDATE ORDER TRACKING</td>
<td class="auto-style1">
&nbsp;</td>
</tr>
<tr>
<td style="text-align: center">
BILL NO</td>
<td class="auto-style1">
<asp:DropDownList ID="DropDownList1" runat="server">
<asp:ListItem>Select bill no</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator1" runat="server"
ControlToValidate="DropDownList1" ErrorMessage="Select the Bill
no"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td style="text-align: center">
EMAIL ID</td>
<td class="auto-style1">
<asp:DropDownList ID="DropDownList2" runat="server">
<asp:ListItem>Select the mail</asp:ListItem>
</asp:DropDownList>
 <asp:RequiredFieldValidator
ID="RequiredFieldValidator2" runat="server"
ControlToValidate="DropDownList2" ErrorMessage="Select the
Mail"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td style="text-align: center" class="auto-style2">
DATE OF DELIVERY</td>
<td class="auto-style3">
<asp:TextBox ID="TextBox1" runat="server"
TextMode="Date"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator3" runat="server"
ControlToValidate="TextBox1" ErrorMessage="Select the delivery
date"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td style="text-align: center">
DELIVERY PERSON&nbsp; MOBILE NO</td>
<td class="auto-style1">
<asp:TextBox ID="TextBox2" runat="server"
MaxLength="10"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator4" runat="server"
ControlToValidate="TextBox2" ErrorMessage="Enter mobile
number"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td style="text-align: center">
<asp:Button ID="Button1" runat="server"
OnClick="Button1_Click" Text="UPDATE TRACKING" />
</td>
<td class="auto-style1">
&nbsp;</td>
</tr>
<tr>
<td style="text-align: center">
&nbsp;</td>
<td class="auto-style1">
&nbsp;</td>
 </tr>
</table>
<br />

<br />
</div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>

</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class orders : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
 {
try
{

// em = Session["logname"].ToString();
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

string s = "select * from payment2";// where emailid =" + "'" + em +

"'";

con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;

while (reader.Read())
{

ctr++;

}
reader.Close();
con.Close();

if (ctr > 0)
{
con.Open();
SqlCommand cmd2 = new SqlCommand(s, con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
da = new SqlDataAdapter(cmd2);
da.Fill(dt);
GridView1.DataSource = dt;
 GridView1.DataBind();

con.Close();
}
else
{
Label1.Text = "Sorry No Order details yet...";
}
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
}

try
{
string ss = "select * from payment2";

con.Open();

SqlCommand cmd11 = new SqlCommand(ss, con);

SqlDataReader reader1;
reader1 = cmd11.ExecuteReader();

String name = "";

while (reader1.Read())
{

DropDownList1.Items.Add(reader1.GetString(0));
DropDownList2.Items.Add(reader1.GetString(3));

}
reader1.Close();
con.Close();

catch(Exception ex)
{

Label1.Text = ex.ToString();
 }
}

protected void Button1_Click(object sender, EventArgs e)

{
try
{

string s = "select * from ordertrack where billno= " + "'" +

DropDownList1.Text + "'";
con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;
while (reader.Read())
{
ctr++;

}
reader.Close();
con.Close();
if (ctr == 0)
{

s = "insert into ordertrack values(@a,@b,@c,@d)";

cmd1 = new SqlCommand(s, con);

cmd1.Parameters.Add("@a", DropDownList1.Text);
cmd1.Parameters.Add("@b", DropDownList2.Text);
cmd1.Parameters.Add("@c", TextBox1.Text);
cmd1.Parameters.Add("@d", TextBox2.Text);
con.Open();
cmd1.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('Tracking updated
Successfully');window.location='adminpage.aspx';</script>");

TextBox2.Text = "";
 }
else
{
Response.Write("<script>alert('Sorry,you have Already
Updated');window.location='adminpage.aspx';</script>");
}

}
catch (Exception ex)
{

Label1.Text = ex.ToString();

}
}
}
Guest logins:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Guest</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel">
<div class="tp_menu_tile"> <a href="adminpage.aspx"
class="tp_menu1">Home </a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" />
 <a href="products.aspx" class="tp_menu2">Products</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="editproducts0.aspx" class="tp_menu2">Edit Products</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="orders.aspx" class="tp_menu2">Orders</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="guests.aspx" class="tp_menu2">Guests</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider"
/> <a href="contacts.aspx" class="tp_menu2">Contact</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="index.html" class="tp_menu2">Logout</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothwears</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electronics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Books</a> </div>
 <div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical Products</a> </div>
</div>
<div class="lp_block1">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading">WELCOME TO&nbsp; ADMINISTRATOR
PAGE </p>
<br />
<br /><br />
<table class="style1">
<tr>
<td>
<asp:GridView ID="GridView1" runat="server"
BackColor="White"
BorderColor="#3366CC" BorderStyle="None"
BorderWidth="1px" CellPadding="4">
<FooterStyle BackColor="#99CCCC"
ForeColor="#003399" />
<HeaderStyle BackColor="#003399" Font-Bold="True"
ForeColor="#CCCCFF" />
<PagerStyle BackColor="#99CCCC"
ForeColor="#003399" HorizontalAlign="Left" />
<RowStyle BackColor="White" ForeColor="#003399" />
<SelectedRowStyle BackColor="#009999" Font-
Bold="True" ForeColor="#CCFF99" />
<SortedAscendingCellStyle BackColor="#EDF6F6" />
 <SortedAscendingHeaderStyle BackColor="#0D4AC4"
/>
<SortedDescendingCellStyle BackColor="#D6DFDF" />
<SortedDescendingHeaderStyle BackColor="#002876"
/>
</asp:GridView>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
<td>
&nbsp;</td>
</tr>
</table>
<br /><br />

<br />
</div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<div id="footerpanel">
<div id="footerblock"> <a href="index.html" class="fp_txt">Home
Page</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Payments</a>
<p class="fp_divi">|</p>
<a href="about.aspx" class="fp_txt">About us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Terms</a>
<p class="fp_divi">|</p>
<a href="contact1.aspx" class="fp_txt">Contact Us</a>
 <p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Our Store</a>
<p style="display:block; width:100%; color:#FFFFFF; margin:0;
padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved.</p>
</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class guests : System.Web.UI.Page
{

SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{
try
{

// string em = Session["logname"].ToString();
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);
 string s = "select Fullname,ph as Mobile,Addr as Address,EmailId
from signup";// where emailid =" + "'" + em + "'";

con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;

while (reader.Read())
{

ctr++;

}
reader.Close();
con.Close();

if (ctr > 0)
{
con.Open();
SqlCommand cmd2 = new SqlCommand(s, con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
da = new SqlDataAdapter(cmd2);
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

con.Close();
}
else
{
Label1.Text = "Sorry No Order details yet...";
}
}
catch (Exception ex)
{
 Label1.Text = ex.ToString();
}
}
}

CONTACT US:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Contact us</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
font-size: x-large;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel"> <img src="images/tp_logo.gif" width="238"
height="54" alt="" class="tp_logo" /> <img src="images/shopping.jpeg"
width="23" height="21" alt="" class="tp_shopping_img" /> <a href="#"
class="tp_txt1">Items <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;0 items</a> <a href="#" class="tp_txt2">sign in ::
Register</a>
<div class="tp_menu_tile"> <a href="index.html"
class="tp_menu1">Home Page</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" /> <a href="about.aspx"
class="tp_menu2">About</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="adminlogin.aspx"
class="tp_menu2">Admin</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="guestlogin.aspx"
class="tp_menu2">Guest</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="contact1.aspx"
class="tp_menu2">Contact Us</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" /> <a href="ourstore.aspx"
class="tp_menu2">Our Store</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothswear</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electronics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Collection Books</a> </div> <div
class="rp_listblock"> <img src="images/lp_btn2.gif" width="6" height="5"
alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Books</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif"
width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>
 <div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical products</a> </div>
</div>
<div class="lp_block1">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Contact us </p>
<br />
<br /><br />
<br /><br />

<br />
<table class="style1">
<tr>
<td>
Full Name</td>
<td>
<asp:TextBox ID="TextBox1"
runat="server"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator1" runat="server"
ControlToValidate="TextBox1"
ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
Mobile</td>
<td>
 <asp:TextBox ID="TextBox2" runat="server"
MaxLength="11"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator2" runat="server"
ControlToValidate="TextBox2"
ErrorMessage="*"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator
ID="RegularExpressionValidator2" runat="server"
ControlToValidate="TextBox2" ErrorMessage="Should be 10 Digits"
ValidationExpression="\d{5}(-
\d{5})?"></asp:RegularExpressionValidator>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
Email Id</td>
<td>
<asp:TextBox ID="TextBox4"
runat="server"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator4" runat="server"
ControlToValidate="TextBox4"
ErrorMessage="*"></asp:RequiredFieldValidator>
&nbsp;&nbsp;
<asp:RegularExpressionValidator
ID="RegularExpressionValidator1" runat="server"
ControlToValidate="TextBox4" ErrorMessage="Invalid Email Id"
ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-
.]\w+)*"></asp:RegularExpressionValidator>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
<asp:Button ID="Button1" runat="server" Text="Contact
Us" onclick="Button1_Click" />
</td>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
 <td>
&nbsp;</td>
</tr>
<tr>
<td>
&nbsp;</td>
<td>
&nbsp;</td>
<td>
&nbsp;</td>
</tr>
</table>
</div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<div id="footerpanel">
<div id="footerblock"> <a href="index.html" class="fp_txt">Home
Page</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Payments</a>
<p class="fp_divi">|</p>
<a href="about.aspx" class="fp_txt">About us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Terms</a>
<p class="fp_divi">|</p>
<a href="contact1.aspx" class="fp_txt">Contact Us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Our Store</a>
<p style="display:block; width:100%; color:#FFFFFF; margin:0;
padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved. </a></p>
</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>

</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class contacts : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{
try
{

string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

string s = "select fullname,email,mobile from contack";// where

emailid =" + "'" + em + "'";

con.Open();
SqlCommand cmd1 = new SqlCommand(s, con);
SqlDataReader reader;
reader = cmd1.ExecuteReader();
 int ctr = 0;

while (reader.Read())
{

ctr++;

}
reader.Close();
con.Close();

if (ctr > 0)
{
con.Open();
SqlCommand cmd2 = new SqlCommand(s, con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
da = new SqlDataAdapter(cmd2);
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

con.Close();
}
else
{
Label1.Text = "Sorry No contact details yet found from
customers...";
}
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
}
}
}
Guest Login:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>GUEST LOGIN</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
font-size: x-large;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel"> <img src="images/tp_logo.gif" width="238"
height="54" alt="" class="tp_logo" /> <img src="images/shopping.jpeg"
width="23" height="21" alt="" class="tp_shopping_img" /> <a href="#"
class="tp_txt1">Items <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;0 items</a> <a href="#" class="tp_txt2">sign in ::
Register</a>
<div class="tp_menu_tile"> <a href="index.html"
class="tp_menu1">Home Page</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" /> <a href="about.aspx"
class="tp_menu2">About</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="adminlogin.aspx"
class="tp_menu2">Admin</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="guestlogin.aspx"
class="tp_menu2">Guest</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="contact1.aspx"
class="tp_menu2">Contact Us</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" /> <a href="ourstore.aspx"
class="tp_menu2">Our Store</a> </div>
 <div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif"

width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothwears</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif"
width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electronics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif"
width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif"
width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Books</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif"
width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif"
width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical products</a> </div>
</div>
<div class="lp_block1">
 <div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading">GUEST LOGIN </p>
<br />
<br /><br />
<br /><br />

<br />
<table class="style1">
<tr>
<td>
Email Id</td>
<td>
<asp:TextBox ID="TextBox1"
runat="server"></asp:TextBox>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
Password</td>
<td>
<asp:TextBox ID="TextBox2" runat="server"
TextMode="Password"></asp:TextBox>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
 <asp:Button ID="Button1" runat="server" Text="Login"
onclick="Button1_Click" />
</td>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
<asp:HyperLink ID="HyperLink1" runat="server"
NavigateUrl="~/guestreg.aspx">No Account ?</asp:HyperLink>
</td>
<td>
<asp:HyperLink ID="HyperLink2" runat="server"
NavigateUrl="~/forgotpwd.aspx">Forgot Password ?</asp:HyperLink>
</td>
<td>
&nbsp;</td>
</tr>
</table>
</div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<div id="footerpanel">
<div id="footerblock"> <a href="index.html" class="fp_txt">Home
Page</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Payments</a>
<p class="fp_divi">|</p>
<a href="about.aspx" class="fp_txt">About us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Terms</a>
<p class="fp_divi">|</p>
 <a href="contact1.aspx" class="fp_txt">Contact Us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Our Store</a>
<p style="display:block; width:100%; color:#FFFFFF; margin:0;
padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved.</p>
</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class guestlogin : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
 string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

string s = "select * from signup where emailid=" + "'" +

TextBox1.Text + "'" + " and pwd=" + "'" + TextBox2.Text + "'";

con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;
String name = "", mobile = "", address = "";
while (reader.Read())
{
ctr++;
name = reader.GetString(0);
mobile = reader.GetString(1);
}
reader.Close();
con.Close();
if (ctr == 1)
{

Session["logname"] = TextBox1.Text.Trim();
Session["name"] = name;
Session["mobile"] = mobile;
Response.Redirect("guestpage.aspx");

}
else
{
Response.Write("<script>alert('Sorry,Login
Fails');window.location='index.html';</script>");
}

}
catch (Exception ex)
 {
Label1.Text = ex.ToString();
}
}
}

Guest Registration:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Registration</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
font-size: x-large;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel"> <img src="images/tp_logo.gif" width="238"
height="54" alt="" class="tp_logo" /> <img src="images/shopping.jpeg"
width="23" height="21" alt="" class="tp_shopping_img" /> <a href="#"
class="tp_txt1">Items <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;0 items</a> <a href="#" class="tp_txt2">sign in ::
Register</a>
<div class="tp_menu_tile"> <a href="index.html"
class="tp_menu1">Home Page</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" /> <a href="about.aspx"
class="tp_menu2">About</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="adminlogin.aspx"
class="tp_menu2">Admin</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="guestlogin.aspx"
class="tp_menu2">Guest</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="contact.aspx"
class="tp_menu2">Contact Us</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" /> <a href="ourstore.aspx"
class="tp_menu2">Our Store</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"

height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothswear</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electronics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Collection Books</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Books</a> </div>>
 <div class="rp_listblock"> <img src="images/lp_btn2.gif"
width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical products</a> </div>
<div class="lp_block1">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading">GUEST LOGIN </p>
<br />
<br /><br />
<br /><br />

<br />
<table class="style1">
<tr>
<td>
Full Name</td>
<td>
<asp:TextBox ID="TextBox1"
runat="server"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator1" runat="server"
ControlToValidate="TextBox1"
ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
 Mobile</td>
<td>
<asp:TextBox ID="TextBox2" runat="server"
MaxLength="11"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator2" runat="server"
ControlToValidate="TextBox2"
ErrorMessage="*"></asp:RequiredFieldValidator>
<asp:RegularExpressionValidator
ID="RegularExpressionValidator2" runat="server"
ControlToValidate="TextBox2" ErrorMessage="Should be 10 Digits"
ValidationExpression="\d{5}(-
\d{5})?"></asp:RegularExpressionValidator>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
Address</td>
<td>
<asp:TextBox ID="TextBox3"
runat="server"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator3" runat="server"
ControlToValidate="TextBox3"
ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
Email Id</td>
<td>
<asp:TextBox ID="TextBox4"
runat="server"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator4" runat="server"
ControlToValidate="TextBox4"
ErrorMessage="*"></asp:RequiredFieldValidator>
&nbsp;&nbsp;
 <asp:RegularExpressionValidator
ID="RegularExpressionValidator1" runat="server"
ControlToValidate="TextBox4" ErrorMessage="Invalid Email Id"
ValidationExpression="\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-
.]\w+)*"></asp:RegularExpressionValidator>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
Password</td>
<td>
<asp:TextBox ID="TextBox5" runat="server"
TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator5" runat="server"
ControlToValidate="TextBox5"
ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
<asp:Button ID="Button1" runat="server" Text="Register
Me" onclick="Button1_Click" />
</td>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
&nbsp;</td>
<td>
&nbsp;</td>
<td>
&nbsp;</td>
</tr>
</table>
 </div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<div id="footerpanel">
<div id="footerblock"> <a href="index.html" class="fp_txt">Home
Page</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Payments</a>
<p class="fp_divi">|</p>
<a href="about.aspx" class="fp_txt">About us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Terms</a>
<p class="fp_divi">|</p>
<a href="contact1.aspx" class="fp_txt">Contact Us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Our Store</a>
<p style="display:block; width:100%; color:#FFFFFF; margin:0;
padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved. /p>
</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class guestreg : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{

string s = "select * from signup where emailid= " + "'" +

TextBox4.Text + "'";
con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;
while (reader.Read())
{
ctr++;

}
reader.Close();
con.Close();
if (ctr == 0)
{

s = "insert into signup values(@a,@b,@c,@d,@e)";

cmd1 = new SqlCommand(s, con);
 cmd1.Parameters.Add("@a", TextBox1.Text);
cmd1.Parameters.Add("@b", TextBox2.Text);
cmd1.Parameters.Add("@c", TextBox3.Text);
cmd1.Parameters.Add("@d", TextBox4.Text);
cmd1.Parameters.Add("@e", TextBox5.Text);

con.Open();
cmd1.ExecuteNonQuery();
con.Close();

Response.Write("<script>alert('Registered
Successfully');window.location='index.html';</script>");

TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";

TextBox5.Text = "";
TextBox1.Text = "";

}
else
{
Response.Write("<script>alert('Sorry,you have Registered
Already');window.location='homepage.aspx';</script>");
}

}
catch (Exception ex)
{

Label1.Text = ex.ToString();

}
 }
}

Forgot Password:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Forgot Password</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
font-size: x-large;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel"> <img src="images/tp_logo.gif" width="238"
height="54" alt="" class="tp_logo" /> <img src="images/shopping.jpeg"
width="23" height="21" alt="" class="tp_shopping_img" /> <a href="#"
class="tp_txt1">Items <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&
nbsp;&nbsp;&nbsp;0 items</a> <a href="#" class="tp_txt2">sign in ::
Register</a>
<div class="tp_menu_tile"> <a href="index.html"
class="tp_menu1">Home Page</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" /> <a href="about.aspx"
class="tp_menu2">About</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="adminlogin.aspx"
class="tp_menu2">Admin</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="guestlogin.aspx"
class="tp_menu2">Guest</a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" /> <a href="contact.aspx"
class="tp_menu2">Contact Us</a> <img src="images/" width="2"
height="39" alt="" class="tp_divider" /> <a href="ourstore.aspx"
class="tp_menu2">Our Store</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"

height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Clothswears</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Electonics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Beauty Products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Books</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Housewares</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif"
width="6" height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Toys</a> </div>
 <div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="guestlogin.aspx"
class="rp_listtxt">Musical products</a> </div>
</div>
<div class="lp_block1">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading">GUEST FORGOT PASSWORD ? </p>
<br />
<br /><br />
<br /><br />

<br />
<table class="style1">
<tr>
<td>
Email Id</td>
<td>
<asp:TextBox ID="TextBox2"
runat="server"></asp:TextBox>
</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td>
<asp:Button ID="Button1" runat="server" Text="Reset My
Password" OnClick="Button1_Click" />
</td>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
 <td>
&nbsp;</td>
</tr>
<tr>
<td>
<asp:HyperLink ID="HyperLink1" runat="server"
NavigateUrl="~/guestreg.aspx">No Account ?</asp:HyperLink>
</td>
<td>
<asp:HyperLink ID="HyperLink2" runat="server"
NavigateUrl="~/guestlogin.aspx">Remember Account ?</asp:HyperLink>
</td>
<td>
&nbsp;</td>
</tr>
</table>
</div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<div id="footerpanel">
<div id="footerblock"> <a href="index.html" class="fp_txt">Home
Page</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Payments</a>
<p class="fp_divi">|</p>
<a href="about.aspx" class="fp_txt">About us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Terms</a>
<p class="fp_divi">|</p>
<a href="contact1.aspx" class="fp_txt">Contact Us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Our Store</a>
<p style="display:block; width:100%; color:#FFFFFF; margin:0;
padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved.</p>
 </div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>

</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Net.Mail;
public partial class forgotpwd : System.Web.UI.Page
{

SqlConnection conn;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;

conn = new SqlConnection(strcon);

}

protected void Button1_Click(object sender, EventArgs e)

{

try
{
 String str = "select * from signup where emailid=" + "'" +
TextBox2.Text + "'";
SqlCommand cm = new SqlCommand(str, conn);
SqlDataReader reader;
conn.Open();
reader = cm.ExecuteReader();

int f1 = 0;
while (reader.Read())
{

f1++;

}
conn.Close();
if (f1 == 0)
{
Label1.Text = "Sorry,Invalid User Id";
}
else
{

string allowedChars = "";

allowedChars = "a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z,";
allowedChars +=
"A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y,Z,";
allowedChars += "1,2,3,4,5,6,7,8,9,0,!,@,#,$,%,&,?";

char[] sep = { ',' };

string[] arr = allowedChars.Split(sep);

string passwordString = "";

string temp = "";

 Random rand = new Random();
string txt = TextBox2.Text;

for (int i = 0; i < Convert.ToInt32(txt.Length); i++)

{
temp = arr[rand.Next(0, arr.Length)];
passwordString += temp;
}
string str1 = "update signup set pwd = @p where emailid= " + "'" +
TextBox2.Text.Trim() + "'";
//Response.Write(str1);
conn.Open();
SqlCommand cmd = new SqlCommand(str1, conn);
cmd.Parameters.Add("@p", passwordString);
cmd.ExecuteNonQuery();
conn.Close();
// Label1.Text = "New Password generated successfully..Your New
Password is sent to your registered emaild id";

Response.Redirect("http://localhost/emailphp2021/?e="+
TextBox2.Text+"&p="+ passwordString);

}
catch (Exception ex)
{
Response.Write(ex.ToString());
}

}
}
Guest home page:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Guest home page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel">
<div class="tp_menu_tile"> <a href="guestpage.aspx"
class="tp_menu1">Home </a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" />
<a href="mycart.aspx" class="tp_menu2">My Cart</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="ghistory.aspx" class="tp_menu2">Shopping History</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="gfeedback.aspx" class="tp_menu2">Feedback</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="geditprofile.aspx" class="tp_menu2">Edit Profile</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="index.html" class="tp_menu2">Logout</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
 <div id="leftpanel">
<div class="lp_block">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"

height="5" alt="" class="rp_btn3" /> <a href="glass.aspx"
class="rp_listtxt">Clothwear</a> </div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"

height="5" alt="" class="rp_btn3" /> <a href="office.aspx"
class="rp_listtxt">Electonics</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="health.aspx"
class="rp_listtxt">Beauty products</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="books.aspx"
class="rp_listtxt">Books</a> </div>
<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"
height="5" alt="" class="rp_btn3" /> <a href="housewares.aspx"
class="rp_listtxt">Toys</a> </div>

<div class="rp_listblock"> <img src="images/lp_btn2.gif" width="6"

height="5" alt="" class="rp_btn3" /> <a href="music.aspx"
class="rp_listtxt">Musical products</a> </div>

</div>
<div class="lp_block1">
<div class="lp_tile"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="lp_btn1" />
<p class="lp_heading">Categories</p>
</div>

</div>
<a href="http://all-free-download.com/free-website-templates/"><img
src="images/lp_image.gif" width="279" height="129" alt=""
class="lp_image" /></a> </div>
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
 <p class="tp_heading">WELCOME TO&nbsp; GUEST PAGE </p>
<br />
<br /><br />
<br /><br />

<br />
</div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<div id="footerpanel">
<div id="footerblock"> <a href="index.html" class="fp_txt">Home
Page</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Payments</a>
<p class="fp_divi">|</p>
<a href="about.aspx" class="fp_txt">About us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Terms</a>
<p class="fp_divi">|</p>
<a href="contact1.aspx" class="fp_txt">Contact Us</a>
<p class="fp_divi">|</p>
<a href="ourstore.aspx" class="fp_txt">Our Store</a>
<p style="display:block; width:100%; color:#FFFFFF; margin:0;
padding:10px 0; text-align:center; font-size:12px;">copyright, All Rights
Reserved. </p>
</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>

</html>
My cart:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
<!--
-->
#customers {
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
border-collapse: collapse;
width: 100%;
}

#customers td, #customers th {

border: 1px solid #BEEDFC;
padding: 8px;
}

#customers tr:nth-child(even){background-color:#fff;}

#customers tr:hover {background-color:#BEEDFC;}

#customers th {
padding-top: 12px;
padding-bottom: 12px;
text-align: left;
background-color: #4CAF50;
color: black;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

</div>
<asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
&nbsp;
<asp:Label ID="Label2" runat="server" Text="Label"></asp:Label>
 </form>
</body>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class mycart : System.Web.UI.Page

{

SqlConnection con;
SqlConnection con1;
SqlConnection conn;
protected void Page_Load(object sender, EventArgs e)
{
try
{

String e1 = Session["logname"].ToString();
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
String str = "", pid = "", c = "", pd = "", r = "", ph = "";
//
con = new SqlConnection(strcon);

String s = "";
int ctr = 0, rate = 0;
String str1 = "select * from carttemp where emailid=" + "'" + e1 + "'";
SqlCommand cm = new SqlCommand(str1, con);
SqlDataReader reader;
string cat = "", cat1 = "";
reader = cm.ExecuteReader();
Response.Write("<h1 align=center>Shopping Cart Details</h1>");
 Response.Write("<h1 align=center><a
href=guestpage.aspx>Home</a></h1>");
Response.Write("<table id=customers align=center
border=2><tr><td>Product Id</td><td>Product
Description</td><td>Rate</td><td>Photo</td><td>Quantity</td><td></td
></tr><tr>");

String pn = "", q = "";

while (reader.Read())
{
for (int i = 0; i <= 4; i++)
{
s = reader.GetString(i).Trim();
if (i == 2)
{
rate = rate + Convert.ToInt16(s);
}

if (i == 3)
{
//Response.Write(s);
Response.Write("<td><img src=" + s + " width=100
height=100 ></img></td>");
// Response.Write("<td><a href=addtocart.aspx?id=" + s + "
>Add to Cart</a></td>");
}
else if (i == 0)
{
pid = s;
Response.Write("<td>" + s + " </td>");

}
else
{

Response.Write("<td>" + s + " </td>");

}
 Response.Write("<td><a href=DeleteItem.aspx?id=" + pid + "
>Delete Item</a></td>");

Response.Write("</tr>");
ctr++;
}
Response.Write("</table>");

con.Close();
Label1.Text = "Total items in the cart is=" + ctr.ToString();
Label2.Text = "Total Value in the cart is Rs=" + rate.ToString();
Session["items"] = ctr.ToString();
Session["value"] = rate.ToString();
con.Close();
Response.Write("<h1 align=center><a
href=placeorder.aspx?amt="+rate+">Place Order</a></h1>");
}
catch (Exception ex)
{

Response.Write(ex.ToString());

}
}
}

Shopping history:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>History</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel">
<div class="tp_menu_tile"> <a href="guestpage.aspx"
class="tp_menu1">Home </a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" />
<a href="mycart.aspx" class="tp_menu2">My Cart</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="ghistory.aspx" class="tp_menu2">Shopping History</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="gfeedback.aspx" class="tp_menu2">Feedback</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="geditprofile.aspx" class="tp_menu2">Edit Profile</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="index.html" class="tp_menu2">Logout</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading"> ORDER HISTORY</p>
<br />
<br />

<table class="style1">
<tr>
 <td>
<asp:GridView ID="GridView1" runat="server"
BackColor="White"
BorderColor="#3366CC" BorderStyle="None"
BorderWidth="1px" CellPadding="4"
Width="596px">
<FooterStyle BackColor="#99CCCC"
ForeColor="#003399" />
<HeaderStyle BackColor="#003399" Font-Bold="True"
ForeColor="#CCCCFF" />
<PagerStyle BackColor="#99CCCC"
ForeColor="#003399" HorizontalAlign="Left" />
<RowStyle BackColor="White" ForeColor="#003399" />
<SelectedRowStyle BackColor="#009999" Font-
Bold="True" ForeColor="#CCFF99" />
<SortedAscendingCellStyle BackColor="#EDF6F6" />
<SortedAscendingHeaderStyle BackColor="#0D4AC4"
/>
<SortedDescendingCellStyle BackColor="#D6DFDF" />
<SortedDescendingHeaderStyle BackColor="#002876"
/>
</asp:GridView>
SELECT THE ORDER TO CANCEL
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>
<asp:Button ID="Button1" runat="server"
OnClick="Button1_Click" Text="CANCEL ORDER" />
</td>
<td>
&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td style="text-align: center">
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
<td style="text-align: center">
&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
 <td style="text-align: center">
<asp:Button ID="Button2" runat="server"
OnClick="Button2_Click" Text="TRACK ORDER" />
</td>
<td style="text-align: center">
&nbsp;</td>
<td>
&nbsp;</td>
</tr>
<tr>
<td style="text-align: center">
<asp:GridView ID="GridView2" runat="server"
BackColor="White" BorderColor="#CC9966" BorderStyle="None"
BorderWidth="1px" CellPadding="4">
<FooterStyle BackColor="#FFFFCC"
ForeColor="#330099" />
<HeaderStyle BackColor="#990000" Font-Bold="True"
ForeColor="#FFFFCC" />
<PagerStyle BackColor="#FFFFCC"
ForeColor="#330099" HorizontalAlign="Center" />
<RowStyle BackColor="White" ForeColor="#330099" />
<SelectedRowStyle BackColor="#FFCC66" Font-
Bold="True" ForeColor="#663399" />
<SortedAscendingCellStyle BackColor="#FEFCEB" />
<SortedAscendingHeaderStyle BackColor="#AF0101" />
<SortedDescendingCellStyle BackColor="#F6F0C0" />
<SortedDescendingHeaderStyle BackColor="#7E0000"
/>
</asp:GridView>
</td>
<td style="text-align: center">
&nbsp;</td>
<td>
&nbsp;</td>
</tr>
</table>

<br />
<br />
<br />
<br /><br />

<br />
 </div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class ghistory : System.Web.UI.Page

{

SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{
try
{

string em = Session["logname"].ToString();
 string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

string s = "select * from payment2 where emailid =" + "'" + em + "'";

con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;

while (reader.Read())
{

ctr++;

}
reader.Close();
con.Close();

if (ctr > 0)
{
SqlCommand cmd2 = new SqlCommand(s, con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
da = new SqlDataAdapter(cmd2);
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();

con.Close();
string ss = "select * from payment2 where emailid=" + "'" + em +
"'" ;
// Response.Write(ss);
 con.Open();

SqlCommand cmd11 = new SqlCommand(ss, con);

SqlDataReader reader1;
reader1 = cmd1.ExecuteReader();

String name = "";

while (reader1.Read())
{

DropDownList1.Items.Add(reader1.GetString(0));

}
reader.Close();
con.Close();
}
else
{
Label1.Text = "Sorry No Order details yet...";
}
}
catch (Exception ex)
{
Label1.Text = ex.ToString();
}
}

protected void Button1_Click(object sender, EventArgs e)

{
try
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
String str = "", pid = "", c = "", pd = "", r = "", ph = "";

con = new SqlConnection(strcon);

// pid = Request.QueryString.Get(0);
 string s = "delete from payment2 where billno=" + "'"
+DropDownList1.Text + "'";

SqlCommand cmd11 = new SqlCommand(s, con);

con.Open();
cmd11.ExecuteNonQuery();
con.Close();

Response.Write("<script>alert('Order Cancelled
Successfully');window.location='guestpage.aspx';</script>");

}
catch (Exception ex)
{

Response.Write(ex);

}
}

protected void Button2_Click(object sender, EventArgs e)

{
try
{

string em = Session["logname"].ToString();
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);
 string s = "select Billno,Email,dod as Date_of_Delivery,dboy as
Delivery_Contact_No from ordertrack where email =" + "'" + em + "'";

con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;

while (reader.Read())
{

ctr++;

}
reader.Close();
con.Close();

if (ctr > 0)
{
con.Open();
SqlCommand cmd2 = new SqlCommand(s, con);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
da = new SqlDataAdapter(cmd2);
da.Fill(dt);
GridView2.DataSource = dt;
GridView2.DataBind();

con.Close();

}
else
{
Label1.Text = "Sorry No Order updates yet...";
}
 }
catch (Exception ex)
{
Label1.Text = ex.ToString();
}
}

FeedBack:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Feed back</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
}
.style2
{
text-align: left;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel">
<div class="tp_menu_tile"> <a href="guestpage.aspx"
class="tp_menu1">Home </a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" />
<a href="mycart.aspx" class="tp_menu2">My Cart</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="ghistory.aspx" class="tp_menu2">Shopping History</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="gfeedback.aspx" class="tp_menu2">Feedback</a>
 <img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="geditprofile.aspx" class="tp_menu2">Edit Profile</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="index.html" class="tp_menu2">Logout</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading"> FEEDBACK FORM</p>
<br />
<br />

<table class="style1">
<tr>
<td>
Name</td>
<td>
<asp:Label ID="Label2" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td class="style2">
Email Id</td>
<td>
<asp:Label ID="Label3" runat="server"></asp:Label>
</td>
</tr>
<tr>
 <td class="style2">
Mobile No</td>
<td>
<asp:Label ID="Label4" runat="server"></asp:Label>
</td>
</tr>
<tr>
<td class="style2">
Feedback</td>
<td>
<asp:TextBox ID="TextBox4" runat="server"
TextMode="MultiLine"></asp:TextBox>
&nbsp;<asp:RequiredFieldValidator
ID="RequiredFieldValidator1" runat="server"
ControlToValidate="TextBox4"
ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td style="text-align: center">
<asp:Button ID="Button1" runat="server" Text="Add Feed
Back"
onclick="Button1_Click" />
</td>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
</tr>
</table>

<br />
<br />
<br />
<br /><br />

<br />
</div>

</div>
</div>
<div style="float:left;">
 </div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class gfeedback : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{

string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

Label3.Text = Session["logname"].ToString();
Label2.Text = Session["name"].ToString();

Label4.Text = Session["mobile"].ToString();
}
protected void Button1_Click(object sender, EventArgs e)
 {
try
{

String s = "insert into fback values(@a,@b,@c,@d)";

SqlCommand cmd1 = new SqlCommand(s, con);

cmd1 = new SqlCommand(s, con);

cmd1.Parameters.Add("@a", Label2.Text);
cmd1.Parameters.Add("@b", Label3.Text);
cmd1.Parameters.Add("@c", Label4.Text);
cmd1.Parameters.Add("@d", TextBox4.Text);

con.Open();
cmd1.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('Feedback Added
Successfully');window.location='guestpage.aspx';</script>");

}
catch (Exception ex)
{

Label1.Text = ex.ToString();

}
}
}

Edit Profile:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Edit profile</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"
/>
<link rel="stylesheet" type="text/css" href="css/style.css"/>
<style type="text/css">
.style1
{
width: 100%;
}
.style2
{
text-align: left;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="mainblock">
<!--inner block starts here -->
<div id="innerblock">
<div id="toppanel">
<div class="tp_menu_tile"> <a href="guestpage.aspx"
class="tp_menu1">Home </a> <img src="images/" width="2" height="39"
alt="" class="tp_divider" />
<a href="mycart.aspx" class="tp_menu2">My Cart</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="ghistory.aspx" class="tp_menu2">Shopping History</a> <img
src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="gfeedback.aspx" class="tp_menu2">Feedback</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="geditprofile.aspx" class="tp_menu2">Edit Profile</a>
<img src="images/" width="2" height="39" alt="" class="tp_divider" />
<a href="index.html" class="tp_menu2">Logout</a> </div>
<div class="tp_tile2"> <img src="images/dought (1).png" width="15"
height="15" alt="" class="tp_btn1" />
<p class="tp_heading">Photo Gallery</p>
</div>
<div class="tp_block"><img src="images/cart.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pay.png" width="140"
height="135" alt="" class="tp_image01" /></div>
<div class="tp_block1"><img src="images/pac.png" width="140"
height="135" alt="" class="tp_image01" /></div>
 <div class="tp_block1"><img src="images/del.png" width="140"
height="135" alt="" class="tp_image01" /></div>
</div>
<div id="contentblock">
<div id="leftpanel">
<div id="contentpanel">
<div style="float:left; ">
<div class="cnt_tile2"> <img src="images/dought (1).png"
width="15" height="15" alt="" class="tp_btn1" />
<p class="tp_heading"> ORDER HISTORY</p>
<br />
<br />

<table class="style1">
<tr>
<td>
Email ID</td>
<td>
<asp:Label ID="Label2" runat="server"
Text="Label"></asp:Label>
</td>
</tr>
<tr>
<td>
Name</td>
<td>
<asp:Label ID="Label3" runat="server"
Text="Label"></asp:Label>
</td>
</tr>
<tr>
<td>
Mobile no</td>
<td>
<asp:Label ID="Label4" runat="server"
Text="Label"></asp:Label>
</td>
</tr>
<tr>
<td>
Old Password</td>
<td>
 <asp:TextBox ID="TextBox1" runat="server"
TextMode="Password"></asp:TextBox>
&nbsp;
<asp:RequiredFieldValidator
ID="RequiredFieldValidator1" runat="server"
ControlToValidate="TextBox1"
ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="style2">
New Password</td>
<td>
<asp:TextBox ID="TextBox2" runat="server"
TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator2" runat="server"
ControlToValidate="TextBox2"
ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td class="style2">
Confirm Password</td>
<td>
<asp:TextBox ID="TextBox3" runat="server"
TextMode="Password"></asp:TextBox>
<asp:RequiredFieldValidator
ID="RequiredFieldValidator3" runat="server"
ControlToValidate="TextBox3"
ErrorMessage="*"></asp:RequiredFieldValidator>
</td>
</tr>
<tr>
<td style="text-align: center">
<asp:Button ID="Button1" runat="server"
onclick="Button1_Click" Text="Update" />
</td>
<td>
<asp:Label ID="Label1" runat="server"></asp:Label>
</td>
</tr>
</table>
 <br />
<br />
<br />
<br /><br />

<br />
</div>

</div>
</div>
<div style="float:left;">

</div>
</div>
<!--inner block ends up -->
</div>
</div>
<!--main block ends up -->

</form>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class geditprofile : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
 String eid = "", s = "", n = "", m = "";
protected void Page_Load(object sender, EventArgs e)
{

string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);
Label2.Text = Session["logname"].ToString();
eid = Session["logname"].ToString();
Label3.Text = Session["name"].ToString();
Label4.Text = Session["mobile"].ToString();

protected void Button1_Click(object sender, EventArgs e)

{
try
{

s = "select * from signup where emailID=" + "'" + eid + "'" + " and
pwd=" + "'" + TextBox1.Text + "'";
Response.Write(s);
con.Open();

SqlCommand cmd1 = new SqlCommand(s, con);

SqlDataReader reader;
reader = cmd1.ExecuteReader();
int ctr = 0;

while (reader.Read())
{
ctr++;
}
reader.Close();
con.Close();
if (ctr == 1)
{

s = "update signup set pwd=@p where emailid=@eid";

SqlCommand cmd11 = new SqlCommand(s, con);
 cmd11.Parameters.Add("@p", TextBox3.Text);
cmd11.Parameters.Add("@eid", eid);

con.Open();
cmd11.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('Password Updated
Successfully...');window.location='guestpage.aspx';</script>");
}
else
{
Label1.Text = "Something has gone wrong pls chk...";
}
}
catch (Exception ex)
{

Label1.Text = ex.ToString();
}
}
}

Categories

1.Cloth wears

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
<!--
.style1 {color: #000000}
.style2 {color: #FF0000;
font-size: 12px;
}
-->
#customers {
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
border-collapse: collapse;
 width: 100%;
}

#customers td, #customers th {

border: 1px solid #BEEDFC;
padding: 8px;
}

#customers tr:nth-child(even){background-color:#fff;}

#customers tr:hover {background-color:#BEEDFC;}

#customers th {
padding-top: 12px;
padding-bottom: 12px;
text-align: left;
background-color: #4CAF50;
color: black;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

</div>
</form>
</body>
</html>

C#:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class glass : System.Web.UI.Page

{
 SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{
try
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;

con = new SqlConnection(strcon);

String str = "select * from product where category='Clothwears'";

SqlCommand cm = new SqlCommand(str, con);
SqlDataReader reader;
con.Open();
// string cat = "", cat1 = "";
reader = cm.ExecuteReader();
Response.Write("<h1 align=center>Clothwears Products</h1>");
Response.Write("<h1 align=center><a
href=guestpage.aspx>Home</a></h1>");

Response.Write("<table id=customers align=center

border=2><tr><td>Product Id</td><td>Product
Description</td><td>Rate</td><td>Photo</td><td>Category</td></tr><tr
>");

String s = "", pid = "", cat = "", pn = "", r = "", ph = "";

while (reader.Read())
{
for (int i = 0; i <= 4; i++)
{
s = reader.GetString(i).Trim();
if (i == 3)
{
//Response.Write(s);
Response.Write("<td><img src=" + s + " width=100
height=100 ></img></td>");

}
else if (i == 0)
{
 pid = s;
Response.Write("<td>" + s + " </td>");

}
else
{

Response.Write("<td>" + s + " </td>");

}
Response.Write("<td><a href=AddtoCart.aspx?id=" + pid + "
>Add to Cart</a></td>");

Response.Write("</tr>");
}
Response.Write("</table>");
con.Close();
}
catch (Exception ex)
{
Response.Write(ex);
}
}
}

2.Electronics

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
<!--
.style1 {color: #000000}
.style2 {color: #FF0000;
font-size: 12px;
}
-->
#customers {
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
border-collapse: collapse;
width: 100%;
}

#customers td, #customers th {

border: 1px solid #BEEDFC;
padding: 8px;
}

#customers tr:nth-child(even){background-color:#fff;}

#customers tr:hover {background-color:#BEEDFC;}

#customers th {
padding-top: 12px;
padding-bottom: 12px;
text-align: left;
background-color: #4CAF50;
color: black;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

</div>
</form>
</body>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class office : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{
try
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

String str = "select * from product where category='Electronics'";

SqlCommand cm = new SqlCommand(str, con);
SqlDataReader reader;
con.Open();
// string cat = "", cat1 = "";
reader = cm.ExecuteReader();
Response.Write("<h1 align=center>Electronic Products</h1>");
Response.Write("<h1 align=center><a
href=guestpage.aspx>Home</a></h1>");

Response.Write("<table id=customers align=center

border=2><tr><td>Product Id</td><td>Product
Description</td><td>Rate</td><td>Photo</td><td>Category</td></tr><tr
>");

String s = "", pid = "", cat = "", pn = "", r = "", ph = "";

while (reader.Read())
{
for (int i = 0; i <= 4; i++)
{
s = reader.GetString(i).Trim();
if (i == 3)
{
Response.Write("<td><img src=" + s + " width=100
height=100 ></img></td>");
 }
else if (i == 0)
{
pid = s;
Response.Write("<td>" + s + " </td>");

}
else
{

Response.Write("<td>" + s + " </td>");

}
Response.Write("<td><a href=AddtoCart.aspx?id=" + pid + "
>Add to Cart</a></td>");

Response.Write("</tr>");
}
Response.Write("</table>");
con.Close();
}
catch (Exception ex)
{
Response.Write(ex);
}

}
}

3.Beauty products:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
<!--
.style1 {color: #000000}
.style2 {color: #FF0000;
font-size: 12px;
}
-->
#customers {
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
border-collapse: collapse;
width: 100%;
}

#customers td, #customers th {

border: 1px solid #BEEDFC;
padding: 8px;
}

#customers tr:nth-child(even){background-color:#fff;}

#customers tr:hover {background-color:#BEEDFC;}

#customers th {
padding-top: 12px;
padding-bottom: 12px;
text-align: left;
background-color: #4CAF50;
color: black;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

</div>
</form>
</body>
</html>

C#:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class health : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{

try
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

String str = "select * from product where category='Beauty

products'";
SqlCommand cm = new SqlCommand(str, con);
SqlDataReader reader;
con.Open();
// string cat = "", cat1 = "";
reader = cm.ExecuteReader();
Response.Write("<h1 align=center>Beauty products
Products</h1>");
Response.Write("<h1 align=center><a
href=guestpage.aspx>Home</a></h1>");

Response.Write("<table id=customers align=center

border=2><tr><td>Product Id</td><td>Product
Description</td><td>Rate</td><td>Photo</td><td>Category</td></tr><tr
>");

String s = "", pid = "", cat = "", pn = "", r = "", ph = "";

while (reader.Read())
{
for (int i = 0; i <= 4; i++)
 {
s = reader.GetString(i).Trim();
if (i == 3)
{
//Response.Write(s);
Response.Write("<td><img src=" + s + " width=100
height=100 ></img></td>");

}
else if (i == 0)
{
pid = s;
Response.Write("<td>" + s + " </td>");

}
else
{

Response.Write("<td>" + s + " </td>");

}
Response.Write("<td><a href=AddtoCart.aspx?id=" + pid + "
>Add to Cart</a></td>");

Response.Write("</tr>");
}
Response.Write("</table>");

con.Close();
}
catch (Exception ex)
{
Response.Write(ex);
}

}
}
4.Books:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
<!--
.style1 {color: #000000}
.style2 {color: #FF0000;
font-size: 12px;
}
-->
#customers {
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
border-collapse: collapse;
width: 100%;
}

#customers td, #customers th {

border: 1px solid #BEEDFC;
padding: 8px;
}

#customers tr:nth-child(even){background-color:#fff;}

#customers tr:hover {background-color:#BEEDFC;}

#customers th {
padding-top: 12px;
padding-bottom: 12px;
text-align: left;
background-color: #4CAF50;
color: black;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
 </div>
</form>
</body>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
public partial class books : System.Web.UI.Page
{
SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{

try
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

String str = "select * from product where category='Books'";

SqlCommand cm = new SqlCommand(str, con);
SqlDataReader reader;
con.Open();
// string cat = "", cat1 = "";
reader = cm.ExecuteReader();
Response.Write("<h1 align=center>Books Products</h1>");
Response.Write("<h1 align=center><a
href=guestpage.aspx>Home</a></h1>");

Response.Write("<table id=customers align=center

border=2><tr><td>Product Id</td><td>Product
Description</td><td>Rate</td><td>Photo</td><td>Category</td></tr><tr
>");

String s = "", pid = "", cat = "", pn = "", r = "", ph = "";

while (reader.Read())
{
for (int i = 0; i <= 4; i++)
{
s = reader.GetString(i).Trim();
if (i == 3)
{
Response.Write("<td><img src=" + s + " width=100
height=100 ></img></td>");
else if (i == 0)
{
pid = s;
Response.Write("<td>" + s + " </td>");

}
else
{

Response.Write("<td>" + s + " </td>");

}
Response.Write("<td><a href=AddtoCart.aspx?id=" + pid + "
>Add to Cart</a></td>");

Response.Write("</tr>");
}
Response.Write("</table>");

con.Close();
}
catch (Exception ex)
{
Response.Write(ex);
}
 }
}

5.Musical products:

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

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
<!--
.style1 {color: #000000}
.style2 {color: #FF0000;
font-size: 12px;
}
-->
#customers {
font-family: "Trebuchet MS", Arial, Helvetica, sans-serif;
border-collapse: collapse;
width: 100%;
}

#customers td, #customers th {

border: 1px solid #BEEDFC;
padding: 8px;
}

#customers tr:nth-child(even){background-color:#fff;}

#customers tr:hover {background-color:#BEEDFC;}

#customers th {
padding-top: 12px;
padding-bottom: 12px;
text-align: left;
background-color: #4CAF50;
color: black;
}
</style>
</head>
<body>
 <form id="form1" runat="server">
<div>

</div>
</form>
</body>
</html>

C#:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class music : System.Web.UI.Page

{
SqlConnection con;
SqlConnection con1;
protected void Page_Load(object sender, EventArgs e)
{
try
{
string strcon =
ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionStrin
g;
con = new SqlConnection(strcon);

String str = "select * from product where category='Musical

products'";
SqlCommand cm = new SqlCommand(str, con);
SqlDataReader reader;
con.Open();
reader = cm.ExecuteReader();
Response.Write("<h1 align=center>Musical products</h1>");
Response.Write("<h1 align=center><a
href=guestpage.aspx>Home</a></h1>");
 Response.Write("<table id=customers align=center
border=2><tr><td>Product Id</td><td>Product
Description</td><td>Rate</td><td>Photo</td><td>Category</td></tr><tr
>");
String s = "", pid = "", cat = "", pn = "", r = "", ph = "";
while (reader.Read())
{
for (int i = 0; i <= 4; i++)
{
s = reader.GetString(i).Trim();
if (i == 3)
{
Response.Write("<td><img src=" + s + " width=100
height=100 ></img></td>");
}
else if (i == 0)
{
pid = s;
Response.Write("<td>" + s + " </td>");
}
else
{

Response.Write("<td>" + s + " </td>");

}
}
Response.Write("<td><a href=AddtoCart.aspx?id=" + pid + "
>Add to Cart</a></td>");

Response.Write("</tr>");
}
Response.Write("</table>");

con.Close();
}
catch (Exception ex)
{
Response.Write(ex);
}

}
}
SCREEN VIEW
Home Page

Admin Login
Add Product
Admin Home Page

Admin Report Page

Edit product
Orders

Track Order
Order update

Guest Login
Guest contacts

Guest login
 Guest registration

Guest home page

Categories
My Cart
Place order
Payment successful

Shopping history
Track Order

Edit Profile
Feed back
Forgot password

Our store
 SYSTEM TESTING
INTRODUCTION:

Testing is the process of detecting errors. Testing performs a very

critical role for quality assurance and for ensuring the reliability of software.
The results of testing are used later on during maintenance also.

The aim of testing is often to demonstrate that a program works by

showing that it has no errors. The basic purpose of testing phase is to detect
the errors that may be present in the program. Hence one should not start
testing with the intent of showing that a program works, but the intent should
be to show that a program doesn’t work. Testing is the process of executing
a program with the intent of finding errors.

Testing Objectives
The main objective of testing is to uncover a host of errors,
systematically and with minimum effort and time. Stating formally, we can
say,

➢ Testing is a process of executing a program with the intent of finding

an error.

➢ A successful test is one that uncovers an as yet undiscovered error.

➢ A good test case is one that has a high probability of finding error, if it
exists.

➢ The tests are inadequate to detect possibly present errors.

Levels of Testing
In order to uncover the errors present in different phases we have the
concept of levels of testing. The basic levels of testing are as shown below…
 Acceptance
Testing
Client Needs

System Testing
Requirements

Integration Testing
Design

Unit Testing
Code

Testing Strategies:
A strategy for software testing integrates software test case design
methods into a well-planned series of steps that result in the successful
construction of software.

Unit Testing
Unit testing focuses verification effort on the smallest unit of software i.e. the
module. Using the detailed design and the process specifications testing is
done to uncover errors within the boundary of the module. All modules must
be successful in the unit test before the start of the integration testing begins.

Unit Testing in this project : In this project each service can be thought of a
module. There are so many modules like Login, New Registration, Change
Password, Post Question, Modify Answer etc. When developing the module
as well as finishing the development so that each module works without any
error. The inputs are validated when accepting from the user.

TEST PLAN:
A number of activities must be performed for testing software. Testing
starts with test plan. Test plan identifies all testing related activities that
needed to be performed along with the schedule and guidelines for testing.
The plan also specifies the level of testing that need to be done , by identifying
the different units. For each unit specifying in the plan first the test cases and
reports are produced. These reports are analyzed.
Test plan is a general document for entire project , which defines the
scope, approach to be taken and the personal responsible for different
activities of testing. The inputs for forming test plans are :
1. Project plan
2. Requirements document
3. System design

TEST CASE REPORT:

Test case 1:

Test case For Name field

Input If Name contains digits
Expected Result Message “Invalid Name”
Obtained Result alert message “Invalid Name”

Test case 2:

Test case For email-id field

Input If mail-id ends with @
Expected Message “Invalid mail-id”
Result
Obtained alert message “Invalid mail-id”
Result

Test case 3:

Test case For email-id field

Input If mail-id ends with “.”
Expected Message “Invalid mail-id”
Result
Obtained alert message “Invalid mail-id”
Result

Test case 4:

Test case For Date field

Input If date format is 03-05-2008
Expected Message “Invalid date foramat. Format is
Result yyyy-mm-dd”
Obtained alert message “Invalid date format”
Result

Test case 5:

Test case For Date field

Input If date format is 2008-13-05
Expected Message “Invalid month range.”
Result
Obtained alert message “Invalid month range”
Result

White Box Testing

White Box Testing mainly focuses on the internal performance of the product.
Here a part will be taken at a time and tested thoroughly at a statement level
to find the maximum possible errors. Also construct a loop in such a way that
the part will be tested with in a range. That means the part is execute at its
boundary values and within bounds for the purpose of testing.

White Box Testing in this Project : I tested step wise every piece of code,
taking care that every statement in the code is executed at least once. I have
generated a list of test cases, sample data, which is used to check all possible
combinations of execution paths through the code at every module level.

Black Box Testing

This testing method considers a module as a single unit and checks the unit
at interface and communication with other modules rather getting into details
at statement level. Here the module will be treated as a block box that will
take some input and generate output. Output for a given set of input
combinations are forwarded to other modules.

Black Box Testing in this Project: I tested each and every module by
considering each module as a unit. I have prepared some set of input
combinations and checked the outputs for those inputs. Also I tested whether
the communication between one module to other module is performing well
or not.
Integration Testing
After the unit testing we have to perform integration testing. The goal here
is to see if modules can be integrated properly or not. This testing activity can
be considered as testing the design and hence the emphasis on testing module
interactions. It also helps to uncover a set of errors associated with
interfacing. Here the input to these modules will be the unit tested modules.

Integration testing is classifies in two types…

1. Top-Down Integration Testing.

2. Bottom-Up Integration Testing.

In Top-Down Integration Testing modules are integrated by moving

downward through the control hierarchy, beginning with the main control
module.

In Bottom-Up Integration Testing each sub module is tested separately

and then the full system is tested.

Integration Testing in this project: In this project integrating all the modules
forms the main system. Means I used Bottom-Up Integration Testing for this
project. When integrating all the modules I have checked whether the
integration effects working of any of the services by giving different
combinations of inputs with which the two services run perfectly before
Integration.

System Testing
Project testing is an important phase without which the system can’t be
released to the end users. It is aimed at ensuring that all the processes are
according to the specification accurately.
System Testing in this project: Here entire ‘system’ has been tested against
requirements of project and it is checked whether all requirements of project
have been satisfied or not.

Alpha Testing

This refers to the system testing that is carried out by the test team with the
organization.

Beta Testing

This refers to the system testing that is performed by a select group of friendly
customers.

Acceptance Testing

Acceptance Test is performed with realistic data of the client to demonstrate

that the software is working satisfactorily. Testing here is focused on external
behavior of the system; the internal logic of program is not emphasized.

Acceptance Testing in this project: In this project I have collected some data
that was belongs to the University and tested whether project is working
correctly or not.

I conclude that this system is tested using all variety of tests… and found no
errors. Hence the testing process is completed.
 CONCLUSION

“Online Shopping System” software developed for human being to achieve

maximum efficiency in shopping online and to reduce the time taken to
purchase items. It is designed for people to shop online rather than searching
for things by visiting the shop. It is a 365/24 service. The system uses asp.net
as front end and SQL-Server as a backend for the database.
The system is strong enough to withstand regressive daily operations under
conditions where the database is maintained and cleared over a certain time
of span. The implementation of the system in the organization will
considerably reduce data entry, time and also provide readily calculated
reports.
 FUTURE ENHANCEMENT

Computer is a magic word of today's world. Here, the project "Tourism

Management System" is to provide useful automated system. It provides a
user-friendly interface for administering the customer and workers. It will
easily maintain the records properly.

The testing was carried out by dividing the project into difference modules.
The project has been satisfactory in the area of client requirements. The
project possesses all the details regarding Tourism. The special feature of the
project is that it matches the requirements of the clients.
 USER MANUAL

• In the Create a new project window, select C# from the Language

list. Next, select Windows from the platform list, and Web from the
project types list. After you apply the language, platform, and project
type filters, select the ASP.NET Core Web App template, and then
select Next.

• Open Visual Studio, and choose Create a new project in the Start
window. In the Create a new project window, select All languages,
and then choose C# from the dropdown list. Choose Windows from
the All platforms list, and choose Console from the All project types
list.

• SQL Server Management Studio.

 BIBLIOGRAPHY

Books

➢ “An Integrated Approach to Software Engineering”- Pankaj Jalote

➢ “Database Management System”- Elmasri and Navathe

WEB-SITES

1. WWW.Youtube.COM
2. WWW.Tuttorialspoint.COM
3. WWW.W3Schools.COM
4. WWW.Codingacademy.COM