ASP Database Fundamentals (Part 2) - Lets Get Technical
(Page 3 of 9 )
A recordset object is created in the same manner as a connection object. Follows is an example:
<%
ConnectionString = "DSN=MyDB”
set conn = server.createobject("adodb.connection")
conn.open ConnectionString
set rs = Server.CreateObject("ADODB.recordset")
%>
It is important to remember to close and destroy a recordset object when you are done with it, just as with a connection object. Here is an example:
<%
rs.close
set rs = nothing
Conn.close
Set conn = nothing
%>
Next: Getting Data From Your Database >>
More ASP Articles
More By Rich Smith
