ADO 2.7 Samples

AddNew Method Example (JScript)

This example uses the AddNew method to create a new record with the specified name. Cut and paste the following code to Notepad or another text editor, and save it as AddNewJS.asp.

<!-- BeginAddNewJS -->
<%@LANGUAGE="JScript" %>
<!-- Include file for JScript ADO Constants -->
<%// use this meta tag instead of adojavas.inc%>
<!--METADATA TYPE="typelib" uuid="00000205-0000-0010-8000-00AA006D2EA4" -->

<html>

<head>
   <title>Add New Method Example (JScript)</title>
<style>
<!--
body {
   font-family: 'Verdana','Arial','Helvetica',sans-serif;
   BACKGROUND-COLOR:white;
   COLOR:black;
    }
-->
</style>
</head>

<body>
<h1>AddNew Method Example (JScript)</h1>

<%
   if (Request.Form("Addit") == "AddNew")
   {
      // connection and recordset variables
      var Cnxn = Server.CreateObject("ADODB.Connection")
      var strCnxn = "Provider=sqloledb;Data Source=" + Request.ServerVariables("SERVER_NAME") + ";" +
         "Initial Catalog=Northwind;User Id=sa;Password=;"
      var rsEmployee = Server.CreateObject("ADODB.Recordset");
      //record variables
      var EmpID = String(Request.Form("EmpID").Value);
      var FName = String(Request.Form("FirstName").value);
      var mInit = String(Request.Form("MInit").Value);
      var LName = String(Request.Form("LastName").Value);
   
      // open connection
      Cnxn.Open(strCnxn)
      
      // open Employee recordset using client-side cursor
      rsEmployee.CursorLocation = adUseClient;
      rsEmployee.Open("Employees", strCnxn, adOpenKeyset, adLockOptimistic, adCmdTable);
   
      rsEmployee.AddNew();
         rsEmployee("FirstName") = FName;
         rsEmployee("LastName") = LName;
      rsEmployee.Update;
      
      // of course, you would normally do error handling here
      Response.Write("New record added.")
      
      // clean up
      rsEmployee.Close;
      Cnxn.Close;
   }
%>

<form method="post" action="AddNewJS.asp" id=form1 name=form1>
<table>
<tr>
   <td colspan="2">
   <h4>Please enter the record to add:</h4>
   </td>
</tr>
<tr>
   <td>
      First Name:
   </td>
   <td>
      <input name="FirstName" maxLength=20>
   </td>
</tr>
<tr>
   <td>
      Last Name:
   </td>
   <td>
      <input name="LastName" size="30" maxLength=30>
   </td>
</tr>
<tr>
   <td align="right">
      <input type="submit" value="Submit" name="Submit">
   </td>
    <TD align="left">
      <INPUT type="reset" value="Reset" name="Reset">
    </TD>
</tr>
</table>
<INPUT type="hidden" value="AddNew" name="Addit">
</form>
</body>
</HTML>
<!-- EndAddNewJS -->

See Also

AddNew Method | Recordset Object

© 1998-2001 Microsoft Corporation. All rights reserved.