|
|
|
|
|
Total Hits: 3586 | Today: 0 |
Author: ASP101
|
Rating:
|
|
|
Here's a quick sample that ties together a number of database functions into a simple little script for adding, deleting, and editing data in a database table. It's a pretty simple little script, but it illustrates a number of useful techniques and should help tie all the pieces together into one script...
|
|
|
|
Total Hits: 1792 | Today: 0 |
Author: Nick Stilwell
|
Rating:
|
|
|
This class allows you to browse folders to find access databases, and then connect to them automatically, return grids of records from tables, and edit individual rows, delete or add....
|
|
|
|
Total Hits: 3699 | Today: 0 |
|
Rating:
|
|
|
Here's a quick sample that combines a number of database functions into one script that adds, deletes, and edits records in a database table....
|
|
|
|
Total Hits: 1488 | Today: 0 |
|
Rating:
|
|
|
This code basically shows you how to update a Recordset when multiple records for one user is in the database....
|
|
|
|
Total Hits: 1741 | Today: 0 |
|
Rating:
|
|
|
Once you have a record in your database, chances are you may need to update it at some point. When would you want to do this? Let's say you have a membership based website that is secured with a username and password combination....
|
|
|
|
Total Hits: 1270 | Today: 0 |
Author: Faisal Khan
|
Rating:
|
|
|
Complete tutorial on editing and updating records in the database. Updating via Connection and Recordset Objects discussed. Each step explained for beginners....
|
|
|
|
Total Hits: 1288 | Today: 0 |
Author: Danny Lesandrini
|
Rating:
|
|
|
Create a new page based on the same recordset, through which you can both Add and Delete records.we will create a new page based on the same recordset, through which we can both Add and Delete records....
|
|
|
|
Total Hits: 657 | Today: 0 |
|
Rating:
|
|
|
Here is the script that shows one record based on being linked to from the table....
|
|
|
|
Total Hits: 641 | Today: 0 |
Author: Bill Wilkinson
|
Rating:
|
|
|
Demonstrates using a field in our database called ZIP_FILE. This is a nice way to keep your pages clean, without having empty variables/values floating around your page....
|
|
|
|
Total Hits: 440 | Today: 0 |
|
Rating:
|
|
|
an article that shows you how to simplify the process of inserting rows into simple database tables with a reusable ASP script....
|
|
|
|
Total Hits: 919 | Today: 0 |
|
Rating:
|
|
|
To allow for multiple updates, we need some way to identify each product cost with a ProductID. Also, since the number of products the user can update is dynamic, we have to pass this number to the ASP page that will actually carry out the database updates. We need to modify ListProducts.asp from our previous article. This modification will need to include several new changes. First, we will need to add a text box for the currency. We will also need to create a new button, Update Product Costs. ...
|
|
|
|
Total Hits: 2048 | Today: 0 |
|
Rating:
|
|
|
This piece of code demonstrate the way of accessing database (basic reading and writing). Good for beginners who wish to learn ASP....
|
|
|
|
Total Hits: 578 | Today: 0 |
|
Rating:
|
|
|
Learn how to edit records with an SQL statement instead of a Recordset. Here are two examples. One will use a query string and the other gets the info from a form. Both examples include an example of a DSN-LESS connection....
|
|
|
|
Total Hits: 2250 | Today: 1 |
|
Rating:
|
|
|
update statement like insert statement takes 3 arguments. table_name is the name of the table you want to update, field1 is the name of the field ( column ) whose value you want updated and 'new value' is the new value that field1 will contain. Note where clause is optional, it is used to pick one specific record to update from the whole column....
|
|
|
|
Total Hits: 2419 | Today: 0 |
|
Rating:
|
|
|
This code illustrates various database operations (Select, Update, Insert, Delete) on the MS Access Database. It includes a business object mapped to the Customers table and a test driver that instantiates the object and manipulates it to perform various functions....
|
|
|
|
Total Hits: 2927 | Today: 0 |
|
Rating:
|
|
|
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....
|
|
|
|
Total Hits: 4224 | Today: 0 |
|
Rating:
|
|
|
OK, so people are filling out forms on my website. How do I keep track of all these people and just add them to my database? Using the AddNew method, that's how! If ya wanna just update a specific record, all ya gotta do is comment out (') the .AddNew line, and it will update the record instead of adding a new one. Jeez, this is easy..
...
|
|
|
|
Total Hits: 3261 | Today: 0 |
Author: Bruce Corkhill
|
Rating:
|
|
|
To create a database your first need to open Microsoft Access and choose 'Blank Access Database' from the starting menu. You will be prompted for a name for the database and where you want it saved. Call the database 'guestbook.mdb' and save it in the same directory as the web page connecting to the database is going to be....
|
|
|
|
Total Hits: 836 | Today: 0 |
|
Rating:
|
|
|
This short example provides you with the sample code which will allow you to edit your database records from an ASP page....
|
|
|
|
Total Hits: 1871 | Today: 0 |
|
Rating:
|
|
|
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....
|
|
|
|
|
|
|
