Print Page | Close Window

database

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=3110
Printed Date: 29 March 2026 at 10:14am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: database
Posted By: beginner
Subject: database
Date 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?




Replies:
Posted By: GregD
Date 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 - 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 - 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 - 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 - http://www.aspin.com
using their search facility.

Hope that helps.


 



Posted By: GregD
Date Posted: 29 May 2003 at 8:33am

http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=7979 - http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=7979

There ya go try this one...



Posted By: Bullschmidt
Date Posted: 31 May 2003 at 11:01pm
The Database examples are good at http://www.asp101.com - www.asp101.com in their Samples section.

-------------
J. Paul Schmidt, Freelance ASP Web Developer
www.Bullschmidt.com - www.Bullschmidt.com
Classic ASP Design Tips, ASP Web Database Sample (Freely Downloadable)



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net