Any sample ASP script for adding new records into database?

[Beng79]

Good day to all,

My asp script requires users to enter data in textboxes and capture them into the database as new records.

Does anyone know of any sample ASP scripts or tutorials?

Thanks

 

[DotNetGnat]

here is the sample script in the simplests form...

<%
Dim conn, sql

conn="your connection string to access db"
conn.open()
sql = "insert into mytable(field1,field2)"&_
      " values ('"&request.form("textbox1")&"',"&_
      " '"&request.form("textbox2")&"') "
conn.execute(sql)
conn.close()
set conn=Nothing
%>

post back if you have any questions...

-DNG

 

[ChrisHirst]

http://www.asp101.com/samples/db_add.asp

Chris.

Indifference will be the downfall of mankind, but who cares?
Woo Hoo! the cobblers kids get new shoes.
People Counting Systems

So long, and thanks for all the fish.

 

[Beng79]

For the sample script, how do I ensure that the data from textbox1 goes to field1 in the database table and textbox2 goes to field2 subsequently?

If I have multiple text boxes which means more than one row of data to be captured, how do I do that?

 

[DotNetGnat]

to answer your first question...its pretty straight forward...the fields we specify in the insert statement and the values that need to be insert should be in the same order...i mean...when we say

insert into mytable (field1, field2) VALUES (field1val, field2val)

field1val and field2val are the values for field1 and field2 respectively...

and for the second question....you need to execute this same sql statement for multiple time with different values...

post back if you have more questions..

-DNG