Solved

On-line shopping ASP and SQL advice

Posted on 2004-09-22
8
398 Views
Last Modified: 2010-04-06
Hello,

I would like some advice on ASP and SQL and its use on a web site for on-line shopping – i.e. shopping cart.

This is for internal use in a company and it looks like ASP and SQL are the only compatible languages we can use.

Could someone please advise on this.

Is this a suitable language to use for this. If so why is this a good or bad one to use for this ? and what would our alternatives be if this is not suitable.

Additionally has anyone any advise on how to approach this or web site or books which would be good to use ?

Many thanks

Groupis.

0
Comment
Question by:gisvpn
  • 5
  • 2
8 Comments
 
LVL 6

Assisted Solution

by:Leviter
Leviter earned 50 total points
ID: 12130759
You can choose a lot of languages and backend systems.... ASP with SQL Server (I assumed with 'SQL' you meant 'SQL Server') is a good choice and there are a lot of samples and information on various websites.

Here is one sample... It should help you get started: http://www.asp101.com/samples/shopping.asp
0
 
LVL 6

Expert Comment

by:Leviter
ID: 12130792
I forgot to say......

I would also use ASP + SQL Server, but that is because I have more experience with this combination than with other systems, like PHP + MySQL. The choice of system would (for me at least) depend on the knowledge I already have.

I would run ASP on an IIS server... enable sessions and store the 'ordered' products in the session. This would be the easiest way to work. No hassle of cookies....   :-)
0
 
LVL 5

Accepted Solution

by:
aspmaestro earned 450 total points
ID: 12131826
You can go for ASP or ASP.Net/PHP/JSP for development of your shopping cart application with the backend as SQL server/MySQL/Oracle. So, if you say that ASP/SQL are the only compatible tools for you then you are wrong. You can go for ASP.Net or PHP or JSP as well. That depends on the programming expertise  and personal taste.

However, I think that if you go for ASP.NET or ASP with SQL/Oracle it would be a smooth ride for you as a lots of resources are widely available on Internet for that, along with forums/community support for that. ASP.Net will need VB.net or C# or Jscript.net as the language and asp.net has lots many advantages over Classical ASP like event driven model, faster execution, ease of maintenance, better state management .. to state a few.

Im suggesting the following books for ASP 3.0 :
1> Beginning ASP by Wrox
2> E commerce prog. using ASP in 21 days (Techmedia)

For ASP.Net :
1> Beginning ASP.NET ( with vb.net or c# -- both are available) by Wrox
2> Professional ASP.Net (-do-)
3> ASP.NET Unleashed

As for the online help and community support, following sites are useful:

1>. www.4guysfromrolla.com
2>. a yahoo group called active-server-pages
3>. www.asp101.com
4>. www.w3schools.com
5> Not to forget our own super support site experts-exchange.com :)

Would you like to know anything more ! happy programming !
0
 

Author Comment

by:gisvpn
ID: 12132400
Leviter,

Many thanks for your post, the web site look brilliant thank you for the link will be very useful.

aspmaestro,

Thank you for your post, excellent ! Could i ask what are the differences between ASP and ASP.NET, is ASP.NET a new replacement of ASP ?

Also we are designing a basic on-line shopping site. Would ASP or ASP.NET be more suitable than the other ?

Many thanks again
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 5

Expert Comment

by:aspmaestro
ID: 12132724
hi gisvpn,
asp.net is part of the .net family intended for developing enterprise web projects. asp.net has not been developed to replace asp as it has been created from the ground up and contains a loads of new features and performance benefits compared to the classic asp.

-asp.net makes use of the rich languages like vb.net, C# instead of the limited functional language - vbscript for asp.

-asp.net code is compiled whereas the asp code is interpreted (hence the performance boost in asp.net )

-asp.net makes use of the object oriented concepts of overloading/inheritance etc. and also supports exception handling

-ASP .NET has better language support, a large set of new controls and XML based components, and better user authentication.

-better state management in asp.net and the sessions can span across web servers as in the web farms.

-asp.net has rich server controls and is event driven. also contains lots of validation controls for client side validation.

You can find a detailed set of differences bet. asp/asp.net on this link:
http://www.w3schools.com/aspnet/aspnet_vsasp.asp

For your basic shopping cart application, asp would suffice but asp.net would always be better than asp ! you can also find lots of support for commerce applications in asp.net like the "Commerce starter kit" on www.asp.net (http://www.asp.net/Default.aspx?tabindex=8&tabid=47).

Let me know if you need more help ! Bye.
0
 
LVL 5

Expert Comment

by:aspmaestro
ID: 12132775
Following are good sites for asp.net resources:

1. www.asp.net
2. www.gotdotnet.com
3. microsoft site
4. www.dotnetspider.com
5. aspnet.4guysfromrolla.com

these sites will always be helpfull for development resources for asp.net.
0
 
LVL 5

Expert Comment

by:aspmaestro
ID: 12141832
0
 
LVL 5

Expert Comment

by:aspmaestro
ID: 12143607
glad to help you ! feel free to post your projects' doubts/problems .. bye
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Preface In the first article: A Better Website Login System (http://www.experts-exchange.com/A_2902.html) I introduced the EE Collaborative Login System and its intended purpose. In this article I will discuss some of the design consideratio…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now