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?

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.

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