• Home
 · 
• Active Server Pages
 · 
• How to change information in a database using Active Server Pages (ASP). This method creates a reco

How to change information in a database using Active Server Pages (ASP). This method creates a reco

How to change information in a database using Active Server Pages (ASP). This method creates a recordset and then inserts/updates its records

Rate How to change information in a database using Active Server Pages (ASP). This method creates a reco

• 1
• 2
• 3
• 4
• 5

(3(3 Vote))

         Set conn = Server.CreateObject("ADODB.Connection")
         conn.Open Session("DSN=MyDSN")
         Set rs = Server.CreateObject("ADODB.Recordset")
         rs.Open "MyTable", conn, 1, 3, 2  ' Make sure the LockType
                                           ' allows for insertions and updates
         ' Insert a record
         rs.AddNew
         rs("Field1") = Value1
         rs.Update

         ' Update the current record
         rs("Field1") = Value2
         rs.Update

         rs.Close
%>