Easy Tutorial
Ado Ref Error Ado Sort Ado Ref Record Ado Display Ado Command Index Ado Ref Stream Ado Tutorial Ado Connect Ado Intro Ado Query Ado Examples Ado Summary Ado Datatypes Ado Ref Recordset Ado Ref Field Ado Getstring Ado Add Ado Recordset Ado Ref Connection Ado Ref Parameter Ado Ref Property Ado Delete Ado Update
❮ Ado Delete Home ❯

ADO Update Record

We can use SQL's UPDATE to update a specific record in a database table.

Updating Records in a Database Table

We want to update a specific record in the Customers table in the Northwind database. First, we need to create a table to list all the records in Customers.

If the user clicks a button in the "customerID" column, it will open a new file "demo_update.asp". This file contains the source code for creating input fields based on the fields of the record in the database, along with an "Update Button" to save the modifications.

❮ Ado Delete Home ❯