WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

ADO Add Records


We may utilize the SQL INSERT INTO order to add a record to a table in a database. 


Add a Record to a Table in a Database

We need to add another record to the Customers table in the Northwind database. We initially make a structure that contains the fields we need to gather information from:

<html>
<body>

<form method="post" action="demo_add.asp">
<table>
<tr>
<td>CustomerID:</td>
<td><input name="custid"></td>
</tr><tr>
<td>Company Name:</td>
<td><input name="compname"></td>
</tr><tr>
<td>Contact Name:</td>
<td><input name="contname"></td>
</tr><tr>
<td>Address:</td>
<td><input name="address"></td>
</tr><tr>
<td>City:</td>
<td><input name="city"></td>
</tr><tr>
<td>Postal Code:</td>
<td><input name="postcode"></td>
</tr><tr>
<td>Country:</td>
<td><input name="country"></td>
</tr>
</table>
<br><br>
<input type="submit" value="Add New">
<input type="reset" value="Cancel">
</form>

</body>
</html>

When the client presses the submit catch the structure is sent to a record called "demo_add.asp". The "demo_add.asp" document contains the code that will add another record to the Clients table:

<html>
<body>

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"

sql="INSERT INTO clients (customerID,companyname,"
sql=sql & "contactname,address,city,postalcode,country)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("custid") & "',"
sql=sql & "'" & Request.Form("compname") & "',"
sql=sql & "'" & Request.Form("contname") & "',"
sql=sql & "'" & Request.Form("address") & "',"
sql=sql & "'" & Request.Form("city") & "',"
sql=sql & "'" & Request.Form("postcode") & "',"
sql=sql & "'" & Request.Form("country") & "')"

on blunder continue next
conn.Execute sql,recaffected
on the off chance that err<>0 then
  Response.Write("No refresh permissions!")
else
  Response.Write("<h3>" & recaffected & " record added</h3>")
end if
conn.close
%>

</body>
</html>

Important

If you utilize the SQL INSERT direction know about the following:

  • If the table contains an essential key, make a point to attach an exceptional, non-Null incentive to the essential key field (if not, the supplier may not annex the record, or a blunder occurs)
  • If the table contains an AutoNumber field, do exclude this field in the SQL INSERT direction (the estimation of this field will be dealt with consequently by the provider)

What about Fields With no Data?

In a MS Access database, you can enter zero-length strings ("") in Text, Hyperlink, and Memo fields IF you set the AllowZeroLength property to Yes.

Note: Not all databases bolster zero-length strings and may cause an mistake when a record with clear fields is included. It is critical to check what information types your database supports.