ADO Add Record

我们可以使用 SQL 的 INSERT INTO 命令向数据库中的表添加记录。

A dake a kira furo a dake a kira tabi a dake a kira database

A dake a raniya na Northwind Database dona Customers Tabi kira dakiyanci. A dake a kira shida a dake a kira furo a dake a kira gani:

<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>

Kuma yaro ya aqurin tsakiya domin "demo_add.asp". Akwai kodo a kan "demo_add.asp" wanda ke iya saukiwa wani zai iya kara kawarci wani shida daga tabbin "Customers":

<html>
<body>
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
sql="INSERT INTO customers (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 error resume next
conn.Execute sql,recaffected
if err<>0 then
  Response.Write("No update permissions!")
else 
  Response.Write("<h3>" & recaffected & " record added</h3>")
end if
conn.close
%>
</body>
</html>

Important Matters

When using the INSERT command, please note the following:

  • If the table contains a primary key, make sure that the value added to the primary key field is unique and not empty (otherwise, the provider will not append this record or an error may occur).
  • If the table contains an auto-number field, do not include this field in the INSERT command (the value of this field is handled by the provider).

About Blank Data Field

In the MS Access database, if you set the AllowZeroLength property to 'Yes', you can enter zero-length strings ("") in text, hyperlinks, and memo fields.

Note:Not all databases support zero-length strings, so an error may occur when adding a record with a blank field. Therefore, it is important to check the data types supported by the database you are using.