ASP programming introduction (twenty): Delete data records of ADO components

xiaoxiao2021-03-06  39

1. First, which record is clearly deleted. No more than the SQL statement, such as corresponding to a specific ID. ID = Request.form ("ID") SQL = "Select * from cnarticle where cn_id =" & idset = server.createObject ("adoDb.recordset") RS.Open SQL, CONN, 2, 32, very simple statement : Delete RS.Delete3, it is best to ask for confirmation before modification