Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

On-line shopping ASP and SQL advice

Posted on 2004-09-22
8
Medium Priority
?
416 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 200 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 1800 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It's sometimes a bit tricky to use date functions in Oracle BPEL. I'll explain quickly how you can add N days to the current date. In a BPEL process this can be useful, and you can adapt it to fit your needs. First of all, let's see how to add 1 …
Introduction Knockoutjs (Knockout) is a JavaScript framework (Model View ViewModel or MVVM framework).   The main ideology behind Knockout is to control from JavaScript how a page looks whilst creating an engaging user experience in the least …
The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Suggested Courses

885 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