Electronic Shop Management System

ABSTRACT

This project entitled “JEWELLERY SHOP MANAGEMENT SYSTEM”

is carried out for Jewellers. The main aim of this project is to provide the customer
service with gold smith by the Company. Here the Gold Smith can transfer their
orders to inform admin and view Current status to remain the Order details.
This project also gives about the list of orders available and its status to the
clients. The gold smith status details are maintained by the admin for easy
remaining activity of the worker. The performances of the Gold smith are also
maintained. This project also gives the daily order details from the customer, sales
reports which are mainly used for the maintenance of the orders.

This Project Consist of several modules like Login Gold smith Module, Item
Module, Customer Module, Order Module, Stock Module, Sales Module,
Expenses Module etc. we can also take all the reports like monthly, date wise.
Customized Reports are taken about the modules involved in this project.
PROBLEM SPECIFICATION

Existing System

The existing system is performed manually. All the transactions are feed in the different
types of ledgers manually. The existing system is not user friendly, since it deals with list of
paper work. The current procedure involves a lot of manpower and consumers move stationary.
As all manual systems, this system is also proven to contain a number of demerits.

 It is a tedious process to maintain a bulk of records manually. Also it is tedious to search

for a particular set of records manually. It consumers more time and may lend to errors.
But it is easy to perform complex or repetitive calculations rapidly and accurately using
computers.
 Manual process may become monotonous and hence becoming less efficient.
 It is not possible to maintain the records in papers. The number of papers will be
increased in the subsequent days and needs a large storage space. But using computers,
we can store large amount of data and information for subsequent manipulations.
 It is complex to search the details of a particular item in manual system. It consumer
more time when searching for a particular data from a set of materials.
 The manual system is more tedious
 Mistakes are committed more frequently.
Proposed System

The proposed system should lower the difficulty in handling large amount of data. Data
should be retrieved, updated and processed in a very short time. The proposed design represents
the user with a revised function model.

The proposed system aims at a user oriented one. Even ordinary people can enter data
easily in the system. The proposed system will be very simple. The new system is a menu driven
one.

Objectives of the proposed system

The system objectives are to automate the important aspects of the system and to keep
track of the transaction status of the company. The system is designed in such a way by giving
prime importance of the following features.

 Efficiency
 Interactivity
 Fully menu driven
 User friendly
 To reduce time of processing
Advantages of the proposed system

The proposed system will reduce all the demerits of the existing system. The main merits
of the proposed system are:

 The proposed system will reduce a lot of paper work there by saving time and money.
 Managing of data that are stored in various tables is quietly easy.
 Data redundancy is avoided to some extent.
 A lot of errors that may occur during manual interaction can be avoided (i.e., high
standard of accuracy can be maintained).
 Storage of data can be done in a consistent manner.
 Reports can be generated easily.
 Provides user friendly entry screens to the end user as graphical user interface based.

 Quick retrieval of information.

SYSTEM REQUIREMENTS

Requirements analysis, also called requirements engineering, is the process of

determining user expectations for a new or modified product. These features, called
requirements, must be quantifiable, relevant and detailed. In software  engineering, such
requirements are often called functional specification s. Requirements analysis is an important
aspect of project management .

Hardware Requirement

Hardware environment for” Jewellery Shop Management System”is developed this is

client server based application.The configuration details of the server as welk as the client using
which,the project have been developed is given.

 Processor PENTIUM IV (450 MHZ)

 Memory 256 MB RAM

 Cpu Clock Speed 400 MHZ

 Hard disk 20 GB

 Floppy Drive 1.44MB

 Mouse Standard Serial Mouse

 Key board 108 Windows keyboard

 Monitor At & T 21” INCH

Software Requirement

This section tells as about the software environment in which “Electronic

Shop Management System” is developed.

 Operating System WINDOWS 7

 Front end Microsoft Visual Studio .Net

 Back end MS-Access

FEASIBILITY STUDY:

The initial investigation points to the question whether the project is feasible. A
feasibility is conducted to identify the best system that meets the all the requirements. This
includes an identification description, an evaluation of the proposed systems and selection of the
best system for the job. The requirements of the system are specified with a set of constraints
such as system objectives and the description of the out puts. It is then duty of the analyst to
evaluate the feasibility of the proposed system to generate the above results. Three key factors
are to be considered during the feasibility study.

OPERATION FEASIBILITY

An estimate should be made to determine how much effort and care will go into the
developing of the system including the training to be given to the user. Usually, people are
reluctant to changes that come in their progression. The computer initialization will certainly
affected the turn over, transfer and employee job status. Hence an additional effort is to be made
to train and educate the users on the new way of the system.

TECHNICAL FEASIBILITY

The main consideration is to be given to the study of available resources of the

organization where the software is to be implemented. Here the system analyst evaluates the
technical merits of the system giving emphasis on the performance, Reliability, maintainability
and productivity. By taking the consideration before developing the proposed system, the
resources availability of the organization was studied. The organization was immense computer
facilities equipped with sophisticated machines and the software hence this technically feasible.
ECONOMIC FEASIBILITY

Economic feasibility is the most important and frequently used method for evaluating the
effectiveness of the proposed system. It is very essential because the main goal of the proposed
system is to have economically better result along with increased efficiency. Cost benefit
analysis is usually performed for this purpose. It is the comparative study of the cost verses the
benefit and savings that are expected from the proposed system. Since the organization is well
equipped with the required hard ware, the project was found to be economically.
SOFTWARE DESCRIPTION

Microsoft .NET Framework

The .NET Framework is a new computing platform that simplifies application

development in the highly distributed environment of the Internet. The .NET Framework is
designed to fulfill the following objectives:

 To provide a consistent object-oriented programming environment whether object code is

stored and executed locally, executed locally but Internet-distributed, or executed
remotely.
 To provide a code-execution environment that minimizes software deployment and
versioning conflicts.
 To provide a code-execution environment that guarantees safe execution of code,
including code created by an unknown or semi-trusted third party.
 To provide a code-execution environment that eliminates the performance problems of
scripted or interpreted environments.
 To make the developer experience consistent across widely varying types of applications,
such as Windows-based applications and Web-based applications.
 To build all communication on industry standards to ensure that code based on the .NET
Framework can integrate with any other code.

The .NET Framework has two main components: the common language runtime and the
.NET Framework class library. The common language runtime is the foundation of the .NET
Framework. You can think of the runtime as an agent that manages code at execution time,
providing core services such as memory management, thread management, and remoting, while
also enforcing strict type safety and other forms of code accuracy that ensure security and
robustness. In fact, the concept of code management is a fundamental principle of the runtime.
Code that targets the runtime is known as managed code, while code that does not target the
runtime is known as unmanaged code. The class library, the other main component of the .NET
Framework, is a comprehensive, object-oriented collection of reusable types that you can use to
develop applications ranging from traditional command-line or graphical user interface (GUI)
applications to applications based on the latest innovations provided by ASP.NET, such as Web
Forms and XML Web services.

The .NET Framework can be hosted by unmanaged components that load the common
language runtime into their processes and initiate the execution of managed code, thereby
creating a software environment that can exploit both managed and unmanaged features. The
.NET Framework not only provides several runtime hosts, but also supports the development of
third-party runtime hosts.

For example, ASP.NET hosts the runtime to provide a scalable, server-side environment for
managed code. ASP.NET works directly with the runtime to enable Web Forms applications and
XML Web services, both of which are discussed later in this topic.

Internet Explorer is an example of an unmanaged application that hosts the runtime (in the
form of a MIME type extension). Using Internet Explorer to host the runtime enables you to
embed managed components or Windows Forms controls in HTML documents. Hosting the
runtime in this way makes managed mobile code (similar to Microsoft® ActiveX® controls)
possible, but with significant improvements that only managed code can offer, such as semi-
trusted execution and secure isolated file storage.

The following illustration shows the relationship of the common language runtime and the
class library to your applications and to the overall system. The illustration also shows how
managed code operates within a larger architecture.

Features of the Common Language Runtime

The common language runtime manages memory, thread execution, code execution, code
safety verification, compilation, and other system services. These features are intrinsic to the
managed code that runs on the common language runtime.

With regards to security, managed components are awarded varying degrees of trust,
depending on a number of factors that include their origin (such as the Internet, enterprise
network, or local computer). This means that a managed component might or might not be able
to perform file-access operations, registry-access operations, or other sensitive functions, even if
it is being used in the same active application.
 The runtime enforces code access security. For example, users can trust that an
executable embedded in a Web page can play an animation on screen or sing a song, but cannot
access their personal data, file system, or network. The security features of the runtime thus
enable legitimate Internet-deployed software to be exceptionally featuring rich.

The runtime also enforces code robustness by implementing a strict type- and code-
verification infrastructure called the common type system (CTS). The CTS ensures that all
managed code is self-describing. The various Microsoft and third-party language compilers
generate managed code that conforms to the CTS. This means that managed code can consume
other managed types and instances, while strictly enforcing type fidelity and type safety.

In addition, the managed environment of the runtime eliminates many common software
issues. For example, the runtime automatically handles object layout and manages references to
objects, releasing them when they are no longer being used. This automatic memory
management resolves the two most common application errors, memory leaks and invalid
memory references.

The runtime also accelerates developer productivity. For example, programmers can
write applications in their development language of choice, yet take full advantage of the
runtime, the class library, and components written in other languages by other developers. Any
compiler vendor who chooses to target the runtime can do so. Language compilers that target the
.NET Framework make the features of the .NET Framework available to existing code written in
that language, greatly easing the migration process for existing applications.

While the runtime is designed for the software of the future, it also supports software of
today and yesterday. Interoperability between managed and unmanaged code enables developers
to continue to use necessary COM components and DLLs.

The runtime is designed to enhance performance. Although the common language

runtime provides many standard runtime services, managed code is never interpreted. A feature
called just-in-time (JIT) compiling enables all managed code to run in the native machine
language of the system on which it is executing. Meanwhile, the memory manager removes the
possibilities of fragmented memory and increases memory locality-of-reference to further
increase performance.
 Finally, the runtime can be hosted by high-performance, server-side applications, such as
Microsoft® SQL Server™ and Internet Information Services (IIS). This infrastructure enables
you to use managed code to write your business logic, while still enjoying the superior
performance of the industry's best enterprise servers that support runtime hosting.

.NET Framework Class Library

The .NET Framework class library is a collection of reusable types that tightly integrate
with the common language runtime. The class library is object oriented, providing types from
which your own managed code can derive functionality. This not only makes the .NET
Framework types easy to use, but also reduces the time associated with learning new features of
the .NET Framework. In addition, third-party components can integrate seamlessly with classes
in the .NET Framework.

For example, the .NET Framework collection classes implement a set of interfaces that
you can use to develop your own collection classes. Your collection classes will blend
seamlessly with the classes in the .NET Framework.

As you would expect from an object-oriented class library, the .NET Framework types
enable you to accomplish a range of common programming tasks, including tasks such as string
management, data collection, database connectivity, and file access. In addition to these common
tasks, the class library includes types that support a variety of specialized development scenarios.
For example, you can use the .NET Framework to develop the following types of applications
and services:

 Console applications.
 Scripted or hosted applications.
 Windows GUI applications (Windows Forms).
 ASP.NET applications.
 XML Web services.
 Windows services.
 For example, the Windows Forms classes are a comprehensive set of reusable types that
vastly simplify Windows GUI development. If you write an ASP.NET Web Form application,
you can use the Web Forms classes.

Client Application Development

Client applications are the closest to a traditional style of application in Windows-based

programming. These are the types of applications that display windows or forms on the desktop,
enabling a user to perform a task. Client applications include applications such as word
processors and spreadsheets, as well as custom business applications such as data-entry tools,
reporting tools, and so on. Client applications usually employ windows, menus, buttons, and
other GUI elements, and they likely access local resources such as the file system and peripherals
such as printers.

Another kind of client application is the traditional ActiveX control (now replaced by the
managed Windows Forms control) deployed over the Internet as a Web page. This application is
much like other client applications: it is executed natively, has access to local resources, and
includes graphical elements.

In the past, developers created such applications using C/C++ in conjunction with the
Microsoft Foundation Classes (MFC) or with a rapid application development (RAD)
environment such as Microsoft® Visual Basic®. The .NET Framework incorporates aspects of
these existing products into a single, consistent development environment that drastically
simplifies the development of client applications. The Windows Forms classes contained in
the .NET Framework are designed to be used for GUI development. You can easily create
command windows, buttons, menus, toolbars, and other screen elements with the flexibility
necessary to accommodate shifting business needs.

For example, the .NET Framework provides simple properties to adjust visual attributes
associated with forms. In some cases the underlying operating system does not support changing
these attributes directly, and in these cases the .NET Framework automatically recreates the
forms. This is one of many ways in which the .NET Framework integrates the developer
interface, making coding simpler and more consistent.
 Unlike ActiveX controls, Windows Forms controls have semi-trusted access to a user's
computer. This means that binary or natively executing code can access some of the resources on
the user's system (such as GUI elements and limited file access) without being able to access or
compromise other resources. Because of code access security, many applications that once
needed to be installed on a user's system can now be safely deployed through the Web. Your
applications can implement the features of a local application while being deployed like a Web
page.

Server Application Development

Server-side applications in the managed world are implemented through runtime hosts.
Unmanaged applications host the common language runtime, which allows your custom
managed code to control the behavior of the server. This model provides you with all the features
of the common language runtime and class library while gaining the performance and scalability
of the host server.

The following illustration shows a basic network schema with managed code running in
different server environments. Servers such as IIS and SQL Server can perform standard
operations while your application logic executes through the managed code.

PROGRAMMING TOOLS
First, we must look at the different tools that we have to work with. When you are
creating a program you must interact with four main windows. They are the Tool bar, Tool box,
Project box, and the Properties window.

TOOL BAR
The tool bar is the bar is at the very top of the editing window. It consists of the
dropdown menus: File, Edit, View, Project, Build, Debug, Data, Tools, Window, and Help.
Below those options are the “quick buttons”. These buttons, reading from left to right are: New
Project, New Form, Open File, Save File, Save All, Cut, Copy, Paste, Undo, Redo, Navigate
Backward, Navigate Forward, Solution Configurations, Find, Solution Explorer, Properties,
Toolbox, and Class View.
TOOL BOX
The Tool box contains the tools you use to place various controls on your forms. It
displays all the standard Visual Basic controls plus any custom controls and objects you have
added to your project with the Custom Controls dialog box.

There are basic tools in the VB.Net:

Pointer:
This is the only item in the Toolbox that doesn't draw a control. It is used to resize or
move a control after it's been drawn on a form.
Label:
Used for text that you don't want the user to change, such as a caption under a graphic.
Link Label: A Hyperlink label
Command Button:
Used to create a button that the user can choose to carry out a command.
Text Box:
Used to hold text that the user can either enter or change.
Main Menu:
Adds menus under the titles bar of the form. i.e. File, Edit, …
Check Box:
Used to create a box that the user can easily choose to indicate if something is true or
false, or to display multiple choices when the user can choose more than one.
Radio Button:
Used in a group of option buttons to display multiple choices from which the user can
choose only one.
Group Box:
Typically used to serve as a border for control with similar needs
Picture Box: Used to display graphical images (either decorative or active), as a container that
receives output from graphics methods, or as a container for other controls.
Panel:
Used to host or hold other controls that belong to the same group
Datagrid:
 Allows users see and edit multiple rows of data simultaneously, also useful for rapid
entry of large amounts of data
List Box:
Used to display a list of items from which the user can choose one. The list can
be scrolled if it has more items than can be displayed at one time
Checked List Box:
Allows the user to select multiple items in a list by providing a check box for each item.
Combo Box: Used to draw a combination list box and text box. The user can either choose an
item from the list or enter a value in the text box.
List View:
Displays a list of items with icons, similar to Windows explorer.
Tree View:
Displays a hierarchy of nodes, like files and folders.
Tab Control:
Allows the user to add multiple tabs to a form, like dividers in a notebook.
Date Time Picker:
Allows the user to select a single item from a list of dates or times.
Month Calendar:
Displays a calendar that allows the user to change months and select a date.
Horizontal Scroll Bar:
Used to provide a graphical tool for quickly navigating through a long list of items or a
large amount of information, for indicating the current position on a scale, or as an input device
or indicator of speed or quantity.
Vertical Scroll Bar:
Used to provide a graphical tool for quickly navigating through a long list of items or a
large amount of information, for indicating the current position on a scale, or as an input device
or indicator of speed or quantity.
Timer:
Used to generate timer events at set intervals. This control is invisible at run time.
Splitter:
To resize docked controls at runtime.
Domain Up Down:
Basically a textbox with two buttons for moving up and down in a list.
Numeric Up Down:
Same as DomainUpDown, except the list is composed of numbers and the up and down
arrows adjust the value of the control
Track Bar:
Also called a slider. Used to move through vast amounts of data, or visually adjust a
number.
Progress Bar:
Set to indicate the progress of a process by displaying the status in the form of small
rectangles in a long rectangle.
Rich Text Box:
A textbox that uses .rtf format.
Image List:
Just like it sounds, a list of images. The list can be navigated by a button that scrolls
through the images
Help Provider:
Brings up the help window.
Tool Tip:
Used to display text when the user moves the mouse over a control.
Context Menu:
Displays a menu of frequently used commands associated with the selected item.
Tool Bar:
Allows the programmer to add a toolbar to his form
Status Bar:
Used to allow an application to display various information about its status
Notify Icon:
Used for processes that run in the background, and most of the time don’t

need an interface with the user. A good example would be virus protection

software.

Open File Dialog:

Brings up the window that allows the user to select a file for opening.

Save File Dialog: Opens the window that lets the user select the location and name of the

current open file.

Modules

1. Login

2. Sales Details

3. Stock Details

4. Order Details

5. Report

Module Specifications

1. Login

Login system is the module which checks for a valid candidate when the user enters his login-id,
user-id, password and link to the main page. As user id rules the system so a person is known by
his uniqueness of his user id. As it is to provide the viable candidate system, so the user id is
being validated with password in different cases to validate the genuinely of the candidate.

2. Sales Details

This module defines the sales entry and information of item .the main features of these
modules are unique identity the sales date and item name. Item name is the references of item
information table and customer detail is the references in customer table.

3. Stock Details

Administration details are record in the module. To enter all the details about the

administration of the electronic shop. Then record all the electronic stock details of the shop like,

raw materials, material details.

4. Order Details

This module defines the order information on all the jewels those are manufacturing the
order date based upon the customer requirement .The main features of this module clearly
explains all the item name that are uniquely identified by the item and customer information.

5. Report

These module define all the Expense report of shop information even Sales Details, order
details and other related based on the shop informations.
SYSTEM DESIGN

Architecture Design
Data Flow Diagram

Data flow diagram is one of the structure analysis tools. It is a way of expressing system
requirements in a graphical form. A data flow diagram clarifies system requirements and
identifies major transformation that happens in system design.

Symbols in Data Flow Diagram

A parallelogram defines the input given to the system

- A square defines a source or destination of system data.

An arrow identifies data flow in motion. It is a pipeline through

which in sequence flow.

Level 0

Login User name

Database

Password
Level 1:

Sales Entry
Login

Sales Details Database

Level 2:

Product Entry
Login

Product Details Database

Level 3:

Order Entry
Login

Order Details Database

Report
Table Deign

Sales

Order
Stock
 Entity Relationship Diagram

cname

pname pid mob

addr
pid

pname
ProductDetails SalesEntry

cname
cname
amt
Electronic Shop
Management System qty

qty

cname

orderdate
addr

amount

OrderDetails
pname

mob
qty
cname
category

amt
TESTING & MAINTENANCE

Testing Objectives

Testing is the process of executing a program with the intention of finding an error. A
good test is the one that has a high probability of finding an as-yet undiscovered error successful
test is that which uncovers an as-yet undiscovered error. A successful test is that in which no
errors are found. The objective is to design tests that systematically uncover different classes of
errors and do so with a minimum amount of time and effort.

Unit Testing

Unit testing involves only those characteristics that are vital to the performance of the
unit under test. This encourages developers to modify the source code without immediate
concerns about how such changes might affect the functioning of other units or the program as a
whole. Once all of the units in a program have been found to be working in the most efficient
and error-free manner possible, larger components of the program can be evaluated by means of
integration testing.

Black Box Testing

Black box testing explains the users not able to view the entire process of the context
based Image Retrival.Through keywords search the image. It does not allow the user to view
inside.

Functional Testing

Functional test cases involves exercising the code with normal with values for which the
expected results are known as well as boundary values and special values such as logically
related inputs.

In this project this test can be performed using the Keywords for the image. For example
the users modify the key word for the image.
White Box Testing

In immigration consultancy portal, white-box testing refers to a methodology of the users

can view the entire process of the admin.The user get the internal knowledge of the image
retrival.

Acceptance Testing

Acceptance testing involves planning and execution of functional tests. Performance

tests, and the stress tests to verify that the implemented system its requirements. Acceptance tests
are typically performed by the quality assurance and/or customer organizations.

This testing generally involves running a suite of tests on the completed system. Each
individual test, known as a case, exercises a particular operating condition of the user's
environment or feature of the system, and will result in a pass or fail.In this we can able to
develop the plan of user or the customer.

Integration Testing

The purpose of integration testing is to verify functional, performance, and reliability

requirements placed on major design items.

This may be carried out in 2 ways. They are,

Bottom up Integration:

Bottom-up integration consists of unit testing by subsystem testing. followed by testing

of the entire system.

Instead of testing from the first module this project uses the bottom-up strategy for
testing. First all the individual forms are tested and then the module and with the entire project
the testing was carried out (Example: Registration Form, Keyword modification form).
Top-Down Integration:

Top-down integration starts with the main routine and one or two immediately
subroutines in the system structure.

This project has been tested starting from the dealers Register form, Login form. The user
can view the image and modify the keyword. Using that the user can generate the new keyword
and search the image.

Validation Testing

Tests to determine whether an implemented system fulfills its requirements. The

checking of data for correctness or for compliance with applicable standards, rules, and
conventions. The process of applying specialized security test and evaluation procedures, tools,
and equipment needed to establish acceptance for joint usage of an AIS by one or more
departments or agencies and their contractors.

System Testing

System testing is performed on the entire system in the context of a Functional

Requirement Specification (FRS) and/or a System Requirement Specification (SRS). System
testing is an investigatory testing phase, where the focus is to have almost a destructive attitude
and tests not only the design, but also the behaviour and even the believed expectations of the
customer. It is also intended to test up to and beyond the bounds defined in the
software/hardware requirements specification.

Security Testing

Security testing is a process to determine that an information system protects data and
maintains functionality as intended. USER ID and PASSWORD to the dealers. The dealers
should follow the security rules and restrictions.
Performances Testing

Performance Testing covers a broad range of functional evaluations where a material,

product, system, or person is not specified by detailed material or component specifications:
rather, emphasis is on the final measurable performance characteristics. Testing can be a
qualitative or quantitative procedure.
CONCLUSION

“ Jewellery shop management system “ is a standalone vb.net software useful for

jewellery show rooms for handling data management works. Project Design Details: Admin is
the primary who will have permissions to access software. Admin is provided with unique user
name and password for performing operations. Main form: Using this form admin can navigate
to other forms. Main form consist of utilities , transactions, reports and help options on menu tab.
Utilities Forum consists of database back up form: Using this features admin can take back up of
old records and clear database. These details are stored in table_customer, table_ supplier
database tables.
BIBLIOGRAPHY

BOOK REFERENCES

1. Net In 60 Days a Minute - Bruce Brawstow & Tony Martin

2. Net Programming Bible - Tony Martin
3. Net Developer’s Guide - Greg Buczek
- Tata Msgraw-Hill-Edition
4. SQL 2005 Bible - Cryn.Prague & Michae R.Irwin

WEBSITES REFERENCES:

1. Www.Dotnettutorial.Com
2. Www.Microsoftdotnet.Com
APPENDIX

Source Code

//Default.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs"

Inherits="_Default" %>

<!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>

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

<title>Web</title>

<style type="text/css">

<!--

.style1 {

font-size: 28px;

font-weight: bold;

color: #FFFFFF;

.border {

border: 1px solid #000000;

a {

font-size: 14px;

color: #FFFF00;

font-weight: bold;

a:visited {

color: #FFFF00;
}

a:hover {

color: #FFFF00;

a:active {

color: #FFFF00;

.style2 {

color: #990000;

font-weight: bold;

font-size: 18px;

.style3

height: 54px;

.style4

width: 374px;

.style5

width: 209px;

-->

</style>

</head>
<body>

<table width="102%" height="0%" border="0" class="border">

<tr>

<td height="114" align="center" bgcolor="#CC6600" class="style1">Electronic Shop

Management System </td>

</tr>

<tr>

<td height="29" bgcolor="#990000"><a href="Default.aspx">Login</a> &nbsp; </td>

</tr>

<tr>

<td align="center" bgcolor="#FFCC66"><p>&nbsp;</p>

<p>&nbsp;</p>

<p class="style2">Authorized User Login</p>

<form id="form1" runat="server">

<table width="289" height="126" border="0" align="center" class="border">

<tr>

<td height="38" align="left" class="style5"><strong>User Name</strong></td>

<td class="style4">

<asp:TextBox ID="txtuname" runat="server" Width="182px"></asp:TextBox>

</td>

</tr>

<tr>

<td height="43" align="left" class="style5"><strong>Password</strong></td>

<td class="style4">

<asp:TextBox ID="txtpword" runat="server" TextMode="Password"

Width="183px"></asp:TextBox> </td>

</tr>

<tr>

<td colspan="2" class="style3" align="center">

 <asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Login"

Width="76px" /> </td>

</tr>

</table>

</form>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p></td>

</tr>

</table>

</body>

</html>

//Default.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

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

{
 protected void Page_Load(object sender, EventArgs e)

protected void Button1_Click(object sender, EventArgs e)

if (txtuname.Text == "admin" && txtpword.Text == "admin")

Response.Redirect("CustomerRegister.aspx");

else

Response.Write("<script language = 'javascript'> alert('Invalid Login

');</script>");

//CustomerRegister.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="CustomerRegister.aspx.cs"

Inherits="CustomerRegister" %>

<!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>

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

<title>Web</title>
<style type="text/css">

<!--

.style1 {

font-size: 28px;

font-weight: bold;

color: #FFFFFF;

.border {

border: 1px solid #000000;

a {

font-size: 14px;

color: #FFFF00;

font-weight: bold;

a:visited {

color: #FFFF00;

a:hover {

color: #FFFF00;

a:active {

color: #FFFF00;

.style2 {

color: #990000;

font-weight: bold;

font-size: 18px;
}

.style3

width: 155px;

.style4

width: 168px;

.style5 {width: 155px; font-weight: bold; }

.style6

width: 155px;

height: 75px;

.style7

width: 168px;

height: 75px;

-->

</style>

</head>

<body>

<table width="102%" height="0%" border="0" class="border">

<tr>

<td height="114" align="center" bgcolor="#CC6600"><span class="style1">Electronic

Shop
 Management System </span></td>

</tr>

<tr>

<td height="29" colspan="2" bgcolor="#990000"><a href="CustomerRegister.aspx">Add

Sales</a> &nbsp; &nbsp;

<a href="AddStock.aspx"> Add Stock</a>

&nbsp; &nbsp;

<a href="OrderEntry.aspx"> Order

Entry</a> &nbsp; &nbsp;

<a href="Report.aspx"> Report</a>

&nbsp; &nbsp;

<a href="Default.aspx"> Logout</a>

&nbsp; &nbsp;

</td>

</tr>

<tr>

<td colspan="2" align="center" bgcolor="#FFCC66"><p>&nbsp;</p>

<p class="style2">Customer Registration </p>

<form id="form1" runat="server">

<table width="376" height="356" border="0" align="center" class="border">

<tr>

<td height="38" align="left" class="style3"><strong>Customer Name </strong></td>

<td align="left" class="style4">

<asp:TextBox ID="cname" runat="server" Width="190px" required></asp:TextBox>

</td>

</tr>

<tr>

<td align="left" class="style6"><strong>Address</strong></td>

<td align="left" class="style7">

<asp:TextBox ID="addr" runat="server" Height="58px" Width="190px"

TextMode="MultiLine" required></asp:TextBox>
 </td>

</tr>

<tr>

<td height="43" align="left" class="style3"><strong>Contact Number </strong></td>

<td align="left" class="style4">

<asp:TextBox ID="cno" runat="server" Width="184px" required></asp:TextBox>

</td>

</tr>

<tr>

<td height="43" align="left" class="style5">Product Name</td>

<td align="left" class="style4">

<asp:DropDownList ID="DropDownList1" runat="server" Height="23px"

Width="182px"

onselectedindexchanged="DropDownList1_SelectedIndexChanged"

AutoPostBack=true>

</asp:DropDownList>

</td>

</tr>

<tr>

<td height="43" align="left" class="style5">Company Name</td>

<td align="left" class="style4">

<asp:DropDownList ID="DropDownList2" runat="server" Height="20px"

Width="182px">

</asp:DropDownList>

</td>

</tr>

<tr>

<td height="43" align="left" class="style5">Quantity</td>

<td align="left" class="style4">

 <asp:TextBox ID="quantity" runat="server" Width="184px"
required></asp:TextBox>

</td>

</tr>

<tr>

<td height="40" colspan="2">

<center>

<asp:Button ID="Button1" runat="server" onclick="Button1_Click"

Text="Add" Height="29px" Width="86px" /></center>

</td>

</tr>

</table>

</form>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p></td>

</tr>

</table>

</body>

</html>

//CustomerRegister.aspx.cs

using System;

using System.Collections.Generic;
using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.OleDb;

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

OleDbConnection con=null;

OleDbCommand cmd = null;

OleDbDataReader dr,dr1,dr2;

protected void Page_Load(object sender, EventArgs e)

con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data

Source=E:\\Projects\\Dotnet\\ElectronicShop\\App_Data\\Database1.accdb");

cmd = con.CreateCommand();

con.Open();

cmd = new OleDbCommand("select distinct pname from stock", con);

dr = cmd.ExecuteReader();

DropDownList1.Items.Add("Select");

while (dr.Read())

DropDownList1.Items.Add(dr["pname"].ToString());

//con.Close();

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

DropDownList2.Items.Add("Select");
 cmd = new OleDbCommand("select distinct cname from stock where
pname='"+DropDownList1.SelectedItem.ToString()+"'", con);

dr1 = cmd.ExecuteReader();

while (dr1.Read())

DropDownList2.Items.Add(dr1["cname"].ToString());

protected void Button1_Click(object sender, EventArgs e)

string pid, qty="", amt="",q="";

cmd = new OleDbCommand("select * from stock where pname='" +

DropDownList1.SelectedItem.ToString() + "' and cname='" +
DropDownList2.SelectedItem.ToString() + "'", con);

dr2 = cmd.ExecuteReader();

if (dr2.Read())

pid=dr2["cname"].ToString();

qty = dr2["qty"].ToString();

amt = dr2["amt"].ToString();

q = quantity.Text;

int quant = int.Parse(q);

if (int.Parse(qty)>quant)

int amount = quant * int.Parse(amt);

cmd = new OleDbCommand("insert into sales values ('" + cname.Text + "','" +

addr.Text + "','" + cno.Text + "','" + DropDownList1.SelectedItem.ToString() + "','" +
DropDownList2.SelectedItem.ToString() + "','"+quant+"','"+amount+"')", con);

cmd.ExecuteNonQuery();
 Response.Write("<script language = 'javascript'> alert('Sales Details Added
');</script>");

else

Response.Write("<script language = 'javascript'> alert('Stock Not Enough

');</script>");

//OrderEntry.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="OrderEntry.aspx.cs"

Inherits="OrderEntry" %>

<!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>

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

<title>Web</title>

<style type="text/css">

<!--

.style1 {

font-size: 28px;

font-weight: bold;

color: #FFFFFF;

.border {

border: 1px solid #000000;

}

a {

font-size: 14px;

color: #FFFF00;

font-weight: bold;

a:visited {

color: #FFFF00;

a:hover {

color: #FFFF00;

a:active {

color: #FFFF00;

.style2 {

color: #990000;

font-weight: bold;

font-size: 18px;

.style3

width: 155px;

.style4

width: 168px;

}
.style5 {width: 155px; font-weight: bold; }

.style6

width: 155px;

height: 75px;

.style7

width: 168px;

height: 75px;

-->

</style>

</head>

<body>

<table width="102%" height="0%" border="0" class="border">

<tr>

<td height="114" align="center" bgcolor="#CC6600"><span class="style1">Electronic

Shop

Management System </span></td>

</tr>

<tr>

<td height="29" colspan="2" bgcolor="#990000"><a href="CustomerRegister.aspx">Add

Sales</a> &nbsp; &nbsp;

<a href="AddStock.aspx"> Add Stock</a>

&nbsp; &nbsp;

<a href="OrderEntry.aspx"> Order

Entry</a> &nbsp; &nbsp;

<a href="Report.aspx"> Report</a>

&nbsp; &nbsp;
 <a href="Default.aspx"> Logout</a>
&nbsp; &nbsp;

</td>

</tr>

<tr>

<td colspan="2" align="center" bgcolor="#FFCC66"><p>&nbsp;</p>

<p class="style2">Add Order Details</p>

<form id="form1" runat="server">

<table width="376" height="356" border="0" align="center" class="border">

<tr>

<td height="38" align="left" class="style3"><strong>Customer Name </strong></td>

<td align="left" class="style4">

<asp:TextBox ID="cname" runat="server" Width="190px" required></asp:TextBox>

</td>

</tr>

<tr>

<td align="left" class="style6"><strong>Address</strong></td>

<td align="left" class="style7">

<asp:TextBox ID="addr" runat="server" Height="58px" Width="190px"

TextMode="MultiLine" required></asp:TextBox>

</td>

</tr>

<tr>

<td height="43" align="left" class="style3"><strong>Contact Number </strong></td>

<td align="left" class="style4">

<asp:TextBox ID="cno" runat="server" Width="184px" required></asp:TextBox>

</td>

</tr>

<tr>
 <td height="43" align="left" class="style5">Product Name</td>

<td align="left" class="style4">

<asp:DropDownList ID="DropDownList1" runat="server" Height="23px"

Width="182px"

onselectedindexchanged="DropDownList1_SelectedIndexChanged"

AutoPostBack=true>

</asp:DropDownList>

</td>

</tr>

<tr>

<td height="43" align="left" class="style5">Company Name</td>

<td align="left" class="style4">

<asp:DropDownList ID="DropDownList2" runat="server" Height="20px"

Width="182px">

</asp:DropDownList>

</td>

</tr>

<tr>

<td height="43" align="left" class="style5">Quantity</td>

<td align="left" class="style4">

<asp:TextBox ID="quantity" runat="server" Width="184px"

required></asp:TextBox>

</td>

</tr>

<tr>

<td height="40" colspan="2">

<center>

<asp:Button ID="Button1" runat="server" onclick="Button1_Click"

Text="Add" Height="29px" Width="86px" /></center>

</td>
 </tr>

</table>

</form>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p></td>

</tr>

</table>

</body>

</html>

//OrderEntry.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.OleDb;

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

OleDbConnection con = null;

 OleDbCommand cmd = null;

OleDbDataReader dr, dr1, dr2;

protected void Page_Load(object sender, EventArgs e)

con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data

Source=E:\\Projects\\Dotnet\\ElectronicShop\\App_Data\\Database1.accdb");

cmd = con.CreateCommand();

con.Open();

cmd = new OleDbCommand("select distinct pname from stock", con);

dr = cmd.ExecuteReader();

DropDownList1.Items.Add("Select");

while (dr.Read())

DropDownList1.Items.Add(dr["pname"].ToString());

protected void Button1_Click(object sender, EventArgs e)

string pid, qty = "", amt = "", q = "";

cmd = new OleDbCommand("select * from stock where pname='" +

DropDownList1.SelectedItem.ToString() + "' and cname='" +
DropDownList2.SelectedItem.ToString() + "'", con);

dr2 = cmd.ExecuteReader();

if (dr2.Read())

pid = dr2["cname"].ToString();

qty = dr2["qty"].ToString();

amt = dr2["amt"].ToString();

q = quantity.Text;
 int quant = int.Parse(q);

if (int.Parse(qty) > quant)

int amount = quant * int.Parse(amt);

cmd = new OleDbCommand("insert into orders values ('" + cname.Text + "','" +

addr.Text + "','" + cno.Text + "','" + DropDownList1.SelectedItem.ToString() + "','" +
DropDownList2.SelectedItem.ToString() + "','" + quant + "','" + amount + "')", con);

cmd.ExecuteNonQuery();

Response.Write("<script language = 'javascript'> alert('Sales Details Added

');</script>");

else

Response.Write("<script language = 'javascript'> alert('Stock Not Enough

');</script>");

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)

DropDownList2.Items.Add("Select");

cmd = new OleDbCommand("select distinct cname from stock where pname='" +

DropDownList1.SelectedItem.ToString() + "'", con);

dr1 = cmd.ExecuteReader();

while (dr1.Read())

DropDownList2.Items.Add(dr1["cname"].ToString());

}
//Report.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Report.aspx.cs" Inherits="Report"

%>

<!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>

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

<title>Web</title>

<style type="text/css">

<!--

.style1 {

font-size: 28px;

font-weight: bold;

color: #FFFFFF;

.border {

border: 1px solid #000000;

a {

font-size: 14px;

color: #FFFF00;

font-weight: bold;

a:visited {

color: #FFFF00;

a:hover {
 color: #FFFF00;

a:active {

color: #FFFF00;

.style2 {

color: #990000;

font-weight: bold;

font-size: 18px;

-->

</style>

</head>

<body>

<table width="102%" height="0%" border="0" class="border">

<tr>

<td height="114" align="center" bgcolor="#CC6600"><span class="style1">Electronic

Shop

Management System </span></td>

</tr>

<tr>

<td height="29" colspan="2" bgcolor="#990000"><a href="CustomerRegister.aspx">Add

Sales</a> &nbsp; &nbsp;

<a href="AddStock.aspx"> Add Stock</a>

&nbsp; &nbsp;

<a href="OrderEntry.aspx"> Order

Entry</a> &nbsp; &nbsp;

<a href="Report.aspx"> Report</a>

&nbsp; &nbsp;
 <a href="Default.aspx"> Logout</a>
&nbsp; &nbsp;

</td>

</tr>

<tr>

<td colspan="2" align="center" bgcolor="#FFCC66"><p>&nbsp;</p>

<p class="style2">Sales Details</p>

<form id="form1" runat="server">

<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333"

Width="838px" AutoGenerateColumns="False">

<RowStyle BackColor="#FFCC66" Font-Bold="True"/>

<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />

<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />

<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />

<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />

<EditRowStyle BackColor="#7C6F57" />

<AlternatingRowStyle BackColor="White" />

<Columns>

<asp:TemplateField HeaderText ="Customer Name" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("cname")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>
 <asp:TemplateField HeaderText ="Address" HeaderStyle-
CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("address")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Contact No." HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("cno")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Product Name" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("prodname")

%>'></asp:Label>

</ItemTemplate>
 </asp:TemplateField>

<asp:TemplateField HeaderText ="Company Name" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("compname")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Quantity" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("qty")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Amount" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >
 <asp:Label ID="Label1" runat="server" Text='<%#Eval("amt")
%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<br />

<br />

<p class="style2">Order Details</p><br />

<br />

<asp:GridView ID="GridView2" runat="server" CellPadding="4" ForeColor="#333333"

Width="838px" AutoGenerateColumns="False">

<RowStyle BackColor="#FFCC66" Font-Bold="True"/>

<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />

<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />

<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />

<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />

<EditRowStyle BackColor="#7C6F57" />

<AlternatingRowStyle BackColor="White" />

<Columns>
 <asp:TemplateField HeaderText ="Customer Name" HeaderStyle-
CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("cname")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Address" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("address")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Contact No." HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("cno")

%>'></asp:Label>

</ItemTemplate>
 </asp:TemplateField>

<asp:TemplateField HeaderText ="Product Name" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("prodname")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Company Name" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("compname")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Quantity" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("qty")

%>'></asp:Label>
 </ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Amount" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("amt")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<br />

<br />

<p class="style2">Stock Details</p><br />

<br />

<asp:GridView ID="GridView3" runat="server" CellPadding="4" ForeColor="#333333"

Width="838px" AutoGenerateColumns="False">

<RowStyle BackColor="#FFCC66" Font-Bold="True"/>

 <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />

<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />

<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />

<HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />

<EditRowStyle BackColor="#7C6F57" />

<AlternatingRowStyle BackColor="White" />

<Columns>

<asp:TemplateField HeaderText ="Product ID" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("pid")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Product Name" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("pname")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>
 <asp:TemplateField HeaderText ="Company Name" HeaderStyle-
CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("cname")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Quantity" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("qty")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Amount" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("amt")

%>'></asp:Label>

</ItemTemplate>
 </asp:TemplateField>

<asp:TemplateField HeaderText ="Quantity" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("qty")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

<asp:TemplateField HeaderText ="Amount" HeaderStyle-

CssClass="aligncenter">

<ItemTemplate >

<asp:Label ID="Label1" runat="server" Text='<%#Eval("amt")

%>'></asp:Label>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>
 </form>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p>

<p>&nbsp;</p></td>

</tr>

</table>

</body>

</html>

//Report.aspx.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.OleDb;

using System.Data;

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

{
 protected void Page_Load(object sender, EventArgs e)

if (!IsPostBack)

OleDbConnection con = null;

OleDbDataAdapter da = null,da1=null,da2=null;

con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data

Source=E:\\Projects\\Dotnet\\ElectronicShop\\App_Data\\Database1.accdb");

con.Open();

da = new OleDbDataAdapter("Select * from sales ", con);

DataSet ds = new DataSet();

da.Fill(ds);

GridView1.DataSource = ds;

GridView1.DataBind();

GridView1.AllowPaging = true;

da1 = new OleDbDataAdapter("Select * from orders ", con);

DataSet ds1 = new DataSet();

da1.Fill(ds1);

GridView2.DataSource = ds1;

GridView2.DataBind();

GridView2.AllowPaging = true;

da2 = new OleDbDataAdapter("Select * from stock ", con);

DataSet ds2 = new DataSet();

da2.Fill(ds2);

GridView3.DataSource = ds2;

GridView3.DataBind();
 GridView3.AllowPaging = true;

}
Screen Shot