ASP Tutorial HTML Form to Database Connectivity Database Connectivity (1 of 3) You can connect to the database in two ways. (You can access the following info to discuss the two options. http://www.powerasp.com/content/database/dsn_vs_dnsless.asp
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
ASP Tutorial HTML Form to Database Connectivity
http://www.powerasp.com/content/hintstips/permissions.asp -One more
<form method="POST" action="addrecord.asp"> area in the form, change the action=“addrecord.asp” to whatever name you want and include the .asp extension.
improve our site.</font></p>
(3 of 5)
(4 of 5)
(4 of 8)
7.‘Sets up the connection to the database(The entire line 9 must be on one line)
(5 of 8)
20. ‘Adds new data from the Form to the Table
22. rs("name") = request("name")
23. rs("comments") = request("comments")
24. rs("email") = request("email")
25. ‘Updates the Table and Moves to end of record
28. ‘Closes all the connections to the Database
29. set rs = nothing
30. set conn = nothing
(6 of 8)
34. <title>Thank you</title>
37. <center>Thank you</center><br>
38. <center>Please click <a href="/index.html">here</a>
39. to return to the home page.</center>
This is the response page that is displayed once the form is submitted. This page is generated by the ASP code shown in the previous slides. The message displayed above can be changed to show your own message.
This is what the database will look like after the form is submitted. The data from the form is saved in the database.
The built-in objects are special because they are built into ASP and need not to be declared or created before they can be used in scripts.