|
|
|
|
|
Total Hits: 2547 | 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: 3144 | Today: 1 |
|
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: 1825 | Today: 1 |
|
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: 2937 | Today: 1 |
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: 596 | 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: 1684 | 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....
|
|
|
|
Total Hits: 1610 | 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: 1314 | 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: 1407 | 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: 1049 | 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: 1087 | Today: 0 |
|
Rating:
|
|
|
Here is the script that updates one record after the submit button is pushed on the previous script....
|
|
|
|
Total Hits: 515 | 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: 1660 | Today: 0 |
|
Rating:
|
|
|
Learn to add, remove and modify data from an Access database.I have buildt a sample application to show you the basics of the SQL statements used with Access. The application is an online pricelist where you can add, delete and update all the items. It's important that the path you specify in the DSN-less connection is correct, and that you have write access to that directory. (Often cgi-bin folder has the correct attributes). The code will not be explained further, as I belive that you will lea...
|
|
|
|
Total Hits: 701 | 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: 1625 | 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: 1363 | Today: 0 |
|
Rating:
|
|
|
When updating records you basically have two choices. You can build a SQL statement like or you can open a recordset and call oRS....
|
|
|
|
Total Hits: 2060 | 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: 2705 | 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: 3940 | 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: 1872 | Today: 1 |
|
Rating:
|
|
|
Anytime you have a user login application on the web, you need to be able to give the user the ability to update their profile. One way to do this is with a form that populates itself with the users information which is stored in a database....
|
|
|
|
|
|
|
