How does ADO add, modify, and delete records in the database?

First, the record of the new database First, use the ADO to link to the access database, use the sql command to open the record of the table product, and send the result back to the recordset of rs1, the asp code is as follows: set conn1 = dbq= ; driver=;set rs1 = product,conn1,1,3 Use the addnew method to add a new record, the asp code is as follows: To set the values of each field in the record table, you can use the following three syntax:

rs1 (field name).value = value rs1 (field name) = value rs1 (field order) = value For example, the asp code is as follows: rs1(name).

value = laptop rs1(quantity) = 100 rs1(0) = 12345 Finally, the next update method is to save the new records to the table. Add Record: Name = Laptop ) Modify Database Records To modify the records of the database, first use the ADO link to the Access database, run the SQL command to find the record to be modified, and send the result back to the RS1 RecordSet, the ASP code is as follows:

set rs1 = sql = select * from product where name='Laptops'sql,conn1,1,3 If you find the record to be modified, set the value of each field in the table, and finally the next update method, that is, save the new record to the table, the asp code is as follows: if not then randomize no1 = round(rnd() 10) new1 = laptop - no1 rs1(name).value = new1 The change record is:

Name = rs1 (name) )end if Delete the records of the database To delete the records of the database, first use the ado link to the access database, run the sql command to find the records to be deleted, and send the results back to the recordset of rs1, the asp code is as follows: set rs1 = sql = select * from product where name=' new1 'sql,conn1,1,3 If you find the record to be deleted, you can delete the record in the table with the next delete method, and the asp code is as follows: If not then delete the record:

Name = new1) end if

First, use the ADO to link to the access database, use the SQL command to open the record of the table product, and send the result back to RS1.

Recordset, the asp code is as follows:

set conn1 = "")

dbq="& "") &";driver=;"

set rs1 = "")

products",conn1,1,3

Use the addnew method to add a new record, the asp code is as follows:

To set the values of each field in the record table, you can use the following three syntax:

rs1("The name of the field").value = value.

rs1("The name of the field") = value.

rs1 (field order) = value.

For example, the ASP code is as follows:

rs1("Name").value = "Laptops"

rs1("Quantity") = 100

rs1(0) = "12345"

Finally, the next update method is to store the new records in the table.

Add Record: Name = Laptop.

Modify the records of the database.

If you want to modify the records in the database, first use the ADO link to the access database, and run the SQL command to find the record to be modified.

If you send it back to the RS1 RecordSet, the ASP code is as follows:

set rs1 = "")

sql = "select * from product where name='Laptops'"

sql,conn1,1,3

If you find the record to be modified, set the value of each field in the table, and finally the next update method, that is, save the new record to the table, asp code.

Here's what: if not then

randomize

no1 = round(rnd() 10)

new1 = "Laptops" & no1

rs1("Name").value = new1

The change is recorded as: name=" & rs1("Name") &"")

end if

Delete the records in the database.

If you want to delete the records in the database, first use the ADO link to the access database, run the SQL command to find the records to be deleted, and send the result back to the RS1 recordset, the asp code is as follows:

set rs1 = "")

sql = "select * from product where name='" & new1 & "'"

sql,conn1,1,3

If you find the record to be deleted, you can delete the record in the table with the next delete method, and the asp code is as follows:

if not then

Delete Record: Name =" & new1)

end if

There are two ways:

1. Delete by SQL statement

SQL has a dedicated delete query in the format:

delete from [table name] where [condition] e.g. delete from transcript where [gender]= female"

The above is the usage of SQL, if Douzi is used in VB, just add "on it" in front of it.

delete from transcript where [gender]= female' "

2. Realized through ADO.

dim rs as new

The name of the data table", adlockoptimistic and then iterate through all the data and delete the items that match the criteria:

Skip to the first data.

while = false -- sets the loop condition.

if rs![Condition Field] =then -- Deletes records that meet the criteria.

Skip to the next record.

wend -- ends the loop.

Compared with the two methods, the first method is faster and more efficient.