|
|
1-9 of 9 ASP Databases > Editing Records sites are shown.
|
|
Walks through the process of editing and updating records - contains sample code throughout.
|
|
|
|
|
|
|
This is the the final installment in our set of 3 database editing samples - focussing on updating and editing databases.
|
|
|
|
|
|
|
You can copy the data from one table to another table quite easily. Of course both tables must have the same field names and data types
|
|
|
|
|
|
|
ADO has a great batch update feature that not many people take advantage of. You can use it to update many records at once without making multiple round trips to the database. Here is how to use it.
|
|
|
|
|
|
|
we have two ways to update records; one with Connection Object using SQL update command and the other with the Recordset Object.
|
|
|
|
|
|
|
If you need to develop a set of web pages to allow new records to be added to a database table, this single ASP page lets you can do all of your database insertions in one go.
|
|
|
|
|
|
|
My purpose of this example is to show how to get existing records from a database and write out to an html form. Then updating the records submit the changes or from the form to an ASP page to update those records in the database.
|
|
|
|
|
|
|
Here is the script that updates one record after the submit button is pushed on the previous script
|
|
|
|
|
|
|
A guide to the principals of updating your database tables.
|
|
|
|
|
|