ISU.COM ECommerce with ASP.NET

1
ISU.COM(E-Commerce with ASP.NET SQL
server)By Daeryong seo
Committee Member Dr. Richard J. Easton Dr. Robe
rt W. Sternfeld

• Project supervisor
• Dr. Henjin Chi

2
Objective

• To know and use web application and database
  skills such as ASP.NET ADO.NET
  
• To develop a website using graphic tools such as
  a Photoshop
  
• To design a website which provides a easy
  interface for users and administrators
  
• To understand the security of WebPages

3
Technology / Software / Hardware

• Windows 2003 server
• SQL server 2000 (Math server)
• SQL, HTML, JavaScript, Visual C
• Visual Studio.NET 2002, Dreamweaver, FrontPage
  
  
• SMTP
• Adobe Photoshop, Adobe Image Ready, Fireworks

• Windows XP professional
• SQL server 2005 beta 2 (CS4 server)
• SQL, HTML, JavaScript, Visual C
• Visual Studio.NET 2005 beta 2, Dreamweaver,
  FrontPage
  
• SMTP
• Adobe Photoshop, Adobe Image Ready, Fireworks

4
Project Design

• Study C, ASP.NET, SQL server, ADO.NET
• Installation Configuration Visual
  Studio.NET SQL server
  
• Web Application design coding Visual C
• Database design SQL
• Test

5
3-Tier architecture

• Client-tier the presentation of data, receiving
  user events and controlling the user interface
  
• Application-server-tier the business logic of
  the applications
  
• Data-server-tier data storage

6
The new features of SQL Server 2005 beta 2

• Security enhancements such as database
  encryption, secure default settings, password
  policy enforcement
  
• New SQL Server Management Studio New
  functionality to develop, deploy, and
  troubleshoot SQL Server databases, as well as
  enhancements to previous functionality
• Improved tools and wizards that will make data
  mining easier for businesses of any size
  
• Improved database mirroring

7
The new features of Visual Studio.NET 2005 beta 2

• Windows form, XML Web services, .NET components,
  mobile application, and ASP.NET application
  
• Many new wizards and smart tags for the
  simplicity of the process
  
• The Design page / The Source page
• New Login, LoginView, LoginStatus, Administrator
  page

8
Database design

• Consists of 7 tables
• Tables
• Project table The information of Users
• Shop table The entire contents of products
• Cart table The shopping cart
• Shipping table Shipping to the users address
• ISUguestbook table Freeboard
• ISUinformation table Updated news or
  information
  
• ISUquestion table Question / Answer

9
Database design II
10
WebPages design

• Membershipjoin page
• Login page
• Logout page
• Forget page
• Product page
• Detail page
• Shopping cart page
• Payment Shipping page
• Freeboard page
• Information page
• ISU Q/A page
• Webmaster page

11
WebPages design II
12
ISU.COM Demo
13
Conclusion Enhancement

• ASP.NET 2.0 Visual Studio.NET 2005 beta 2 to
  develop E-commerce web site (fast and easy)
  
• SQL Server 2005 beta 2 Increased scalability,
  availability and security to enterprise data
  
• Enhancement Payment system design, Organized
  webmaster page design, Product search page.

14
Thank you so much forwatching my
presentationQuestions / Suggestions