form entries to sql server with asp

[mavi]

survey form entries on the web page should be written to the sql server database by using asp.
How can i do this procedure...
please help
Thanks a lot...

[buntine]

Do you have any experience with ASP (or any other server-side language)? This is not a hard task, though, you will need to understand whats happening.

First of all, we grab the values the user has entered into the form via the Form collection. For example:

Dim strName
strName = Request.Form("frmName")

frmName refers to the name of the form object in the referring HTML page.

From there, we have to setup the connection to the database and assemble our SQL statement. Incase you not familiar with SQL, the format for inserting a record into a database is as follows:

INSERT INTO tableName (column1, column2, etc) VALUES (value1, value2, value3);

The connection string will be different for each database. The following is a code sample for inserting data into a SQL Server database.

- http://asp101.com/samples/viewasp.asp?file=db%5Fadd%2Easp
Dont let the example intimidate you. Most of it is just comments

Regards.

[Bullschmidt]

And www.asp101.com has some good, short database examples in its Samples area.