Kuingiza Mawasiliano ya ADO

Tunaweza kutumia amri ya INSERT INTO ya SQL kuongeza rekodi kwenye tabia ya database.

Kuingia rekodi kwenye tabia ya database

Tunapendwa kuongeza rekodi mpya kwenye tabia Customers katika database ya Northwind. Tunahitaji kuwaingia chombo cha forms ambacho kina sehemu za kuingia zilizotakiwa kutumika kusafirisha data:

<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="Ongeza Mpya">
 
<input type="reset" value="Taka">

</form>

Kama mtu anapiga gadaa kumpatikana, formu hii inaitwa kwa menginekano ya "demo_add.asp". Kitabu "demo_add.asp" kinahatua kuingiza rekodi kwenye tablica ya 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("Hakuna ruhusa ya usasishaji!")
else 
  Response.Write("<h3>" & recaffected & " rekordi zingizwa</h3>")
end if
conn.close
%>

重要事项

在您使用 INSERT command 命令时，请注意以下事项：

  • 如果表含有一个主键，请确保向主键字段添加的值是唯一且非空的（否则，provider 就不会追加此记录，亦或发生错误）
  • 如果表含有一个自动编号的字段，请不要在 INSERT 命令中涉及此字段（这个字段的值是由 provider 负责的）

关于无数据字段

在 MS Access 数据库中，假如您将 AllowZeroLength 属性设置为 “Yes”，您可以在文本、超链接以及备忘字段输入零长度的字符串 ("")。

Mwongozo:Hakuna tabia za database zingefikia ukurasa wa kina cha kipya, kwa hivyo kumekua mawasiliano yenye eneo lingana na ukurasa hauwezi kumfanya kufikia kinyume. Kwa hivyo, kuangalia aina ya data ambayo tabia ya database inasaa ni muhimu sana.