Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

database

 Post Reply Post Reply
Author
beginner View Drop Down
Newbie
Newbie


Joined: 22 May 2003
Status: Offline
Points: 8
Post Options Post Options   Thanks (0) Thanks(0)   Quote beginner Quote  Post ReplyReply Direct Link To This Post Topic: database
    Posted: 29 May 2003 at 7:54am

HI,

I'm trying to create a form in asp that inserts records into a database. I have just started learning asp, and i was wondering if somebody can help me with this.What code do I need to create a form that inserts records into the database?

Back to Top
GregD View Drop Down
Newbie
Newbie


Joined: 21 May 2003
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote GregD Quote  Post ReplyReply Direct Link To This Post Posted: 29 May 2003 at 8:27am

Hi there,

First I think you should concentrate on establishing a connection between your ASP file and a database, and you can do this by checking out:

http://www.haneng.com/lessons_17.asp

(if you are running your asp code online as opposed to on your hard disk you can miss out the section entitled Making an ODBC connection)

You should note that not all web servers are the same you should check the following things with your host (usually in their FAQ section or email them):

1. What database type the webserver supports (Access or MySQL)
2. What type of provider you should put in when making the connection between ASP/db

In this example the guy is using a DSN file to connect to a database, but there are more direct approaches.

Here is also another example:
http://www.webwiz.net/asp/tutorials/connecting_to_a_database.asp

Once you have the connection established you should try out one of the web wiz apps to see it works properlly.

I started on this one:
http://www.webwiz.net/asp/sample_scripts/database_login_script.asp

Then once all that is working look for an add update remove record from database script on http://www.aspin.com
using their search facility.

Hope that helps.


 

Back to Top
GregD View Drop Down
Newbie
Newbie


Joined: 21 May 2003
Status: Offline
Points: 6
Post Options Post Options   Thanks (0) Thanks(0)   Quote GregD Quote  Post ReplyReply Direct Link To This Post Posted: 29 May 2003 at 8:33am
Back to Top
Bullschmidt View Drop Down
Groupie
Groupie


Joined: 31 May 2003
Location: United States
Status: Offline
Points: 72
Post Options Post Options   Thanks (0) Thanks(0)   Quote Bullschmidt Quote  Post ReplyReply Direct Link To This Post Posted: 31 May 2003 at 11:01pm
The Database examples are good at www.asp101.com in their Samples section.
J. Paul Schmidt, Freelance ASP Web Developer
www.Bullschmidt.com
Classic ASP Design Tips, ASP Web Database Sample (Freely Downloadable)
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.