Results for "Category: String Manipulation"

Transactions are atomic operations that allow you to do multiple operations on a database as one operation. For example, if you were creating a banking application in which you deducted $100 from one account and added it to another account, you wouldn't want the operation to fail right in the middle, because the money would be 'lost'! The solution is to wrap the SQL in a transaction. If the operation is aborted in the middle (the pc gets shut off for example) the database will rollback the changes so that the initial account was never debited the $100. This will make you feel good, especially if its your bank account!

Since ASP is especially good at reading and writing to databases, let's start with a very simple database and scripts that we'll eventually build into a guestbook... Reprinted with permission from http://www.web-savant.com/users/kathi/asp

This is not real RDS but a simulation (Like Access's Not_In_List event). This functions gives the user the ability to 1) Add a new Value into a Database table and 2) update and select the value in the combobox WITHOUT REFRESHING the page from the server. I found this to be a life saver with large ASP pages with comboboxes on them that need to be dinamicaly filled. (You don't have to worry about the controls on the pages)

To return a group of Random Records from a database. For example, a group of random questions for a quiz/test.

If you are looking for a simple solution to display data and be able to sort and query it, you are on the correct page. Complex relationships between recordsets can be viewed using this technique. It is easier to use compared to ASPDB solution. Download Complete source code and explanation.

This article not only includes the complete source code for a database driven web site that the author created, but includes a detailed description on how it works!

This article shows various connection strings, used to connect to various databases in Windows, as well as methods to access and modify data. Some connection strings may require client software to be installed, but most work with Windows 2000.

I modified some database paging code I found on Planet Source Code so that it was a little more straight forward. Included is a sample code file and a sample MS Access 2000 database. Paging allows you to display a specific number of records from a database at a time. For example, if you have 1000 records, you can allow it to display 10 records at a time so you don't have a huge page display. If you're smart, you can add sorting features like the ability to display records starting with 'A' only, but this will get you started.

This page allows you to view and sort all of your tables in an SQL database

This script displays records retrieved from the database. You can sort each field and jump to any page in the database. You can customize the records per page and all the colors. You may also attatch a style sheet to change the colors of each class type. this script is very close to being XML compatable. (still in the works).

After getting great reviews on the previous version, I finally got time to do the rewrite that I promised everyone. This code allows you to easily create lists of your data with pagination, sorting, and filtering. The end result is a very nice layout of your data. You choose which fields come back (an the captions for each one in the header). Choose which fields are searched. Setup the default field that is sorted when visitor first views page. Now supports databases with list ordering. This time I have included a database so it should work as soon as you add the files to your website.

Add search to your site using a database.

reads SQL Stored procedure meta data to provide a complete reporting solution including user input forms for criteria and sortable, pageable html reports.

This piece of code demonstrate the way of accessing database (basic reading and writing). Good for beginners who wish to learn ASP. Nearly every line is documented.

This code is in Beta stage and used like a QueryAnalyzer, it got a update feature but it wont work for the moment. The code will only work with MS SQL server and is only tested with IE 5.5. You have to set write permissions on the servers catalog. Please email me the bugs and other request asap.

Judge not lest ye be... Anyway, no how could I have written this. It's the complete code for an earlier submission from MUKUNTHAN (REally, Dino Espositio at ASPtoday I am told) that allows for display of images from an access database. Feel free to email me for more if it doesn't come through. Thanks to Fabrizio Ricciarelli, Eric Gionet, Jos Hardy, Tim Krause and special thanks to my Moms...

This code shows the use of a dynamic array for the storage of data. Recordsets are memory hogs, and shouldn't be passed across the server, so why even use one? What I was doing with this code was displaying a list of users on my website. After getting the data, I would have it build a table for the information and create hyperlinks for the appropriate fields. I've seen others do this, but they use recordsets to build them, which defeats its purpose. All the code is done with one trip to the server, so you won't see all those carrot tags being opened and closed throughout my work : )

Allows midi songs to be played on your web-site. Songs are stored in an Access 2k database. Code will play a random song or allows user to choose a midi song from a drop-down list. Code calls same page to play midi with ms media player. Could use mp3's but mp3's drag down server. I use this as a sidebar on my default web page. Let me know if you find any issues.

Shows how to dynamically create a HTML table from a recordset. All you need is the connection string and the table name.

ASP Online Exam, this is a quizzing website pulling question from question bank database [Access]. it also has a very useful set of administrator tools where in the admin can create new new Exams, monitor students performance generate reports and update question bank database. code is quite neat and fully commented, will be helpful for ASP Database beginners.