My purpose of this example is to show how to get records from an html form and submit that form to an ASP page. This ASP page will then use ADO to enter the records into the database When I started doing ASP, getting records from an ASP page to a database was my 1st thing I wanted to do. I quickly discovered there was a few ways you could do that. This example uses ADO to take data from a html form and submit to an ASP page that processes the data using ADO. A good book on ADO is by Wrox Press called ADO 2.0 Programmer's reference.) Below is the code I used in this example, go ahead and try entering something in.
1st page the Input form- This is just a standard html Input form
<%@ Language = "VBScript"%> <% 'Declare all local variables
dim conn dim rs dim strID dim strconn
'set a local variable to my DSN-less connection String strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("adoandsqladd.mdb")
'Create the Connection object set conn = server.createobject("adodb.connection") conn.open strconn
'Create the recordset object set rs = server.createobject("adodb.recordset") 'This statement opens the table so we can add a record notice the addnew 'The 2, 2 is how the table is opened there are many ways it can be opened rs.open "tblAdoAdd", conn, 2, 2
'Use the addnew method of the recordset object to add a record rs.addnew 'Set the table column = to my input text box from my form rs("FirstName") = request("FirstName") rs("LastName") = request("LastName") rs("FavoriteColor") = request("FavoriteColor") rs.update 'I do a movelast here to get the ID that is automatically generated 'I also set the value to a local variable so I can write out to the database rs.movelast strID = rs("ID")
%>
<html> <head> <title>sign on summary</title> </head> <body> <TABLE BORDER=1>
Your Record # is:<% = strID %> Your First Name is <% = request("FirstName") %> Your Last Name is <% = request("LastName") %> Your Favorite Color is <% = request("Favoritecolor") %>
</body></html> <%
'Always! Always set your objects to nothing. This clears them out of servers memory 'Your network admins will like this
Database Code 
/ 16 
Retrieving ID field after inserting a record into your Microsoft Access Database
