Results for "Category: String Manipulation"

example of use ADO to CONNECT to your database *.mdbfile on the hard disk without need ODBC and treat it like DAO in visual basic

Simple address book coded in C.

A simple bus reservation system, using dynamic 3D arrays and a simple class example! Don't hesitate to rate for it. I worked so hard for it!

This Project is basically a simple-to-use full-featured object-oriented spread sheet file data management system that will allow the user to open, save, browse, edit, make graphs, and apply functions to any kind of alphanumeric data. This product will run under the DOS operating system. Also, if you wait for 20 seconds, an automaitically BUILT IN SCREEN SAVER will be activated, that can be stopped by pressing the ENTER. REMEMBER THAT SCREEN SAVER WILL BE ACTIVATED AFTER 20 SECONDS. THEREFORE, YOU MUST ATLEAST MOVE YOUR MOUSE OR PERFORM THE KEY OPPERATIONS, IN ORDER TO AVOID THE ACTIVATION OF BUILT IN SCREEN SAVER. The spread sheet file based data management system, as it’s named suggested, is to be used by a user to handle any kind of data in a form of spread sheet. The user can view or edit a spread sheet with a complete facility of saving and retrieving files. The user interacts with the product’s functions (like filing, tools, etc.) by using the MOUSE, and clicking on the pull-down menus of File, tools, graph, and Help. Under each one of these pull-down selections, a user can select functions such as openning, closing, saving, new file, add row, add column, multiply row or column, displaying bar or pie charts, and displaying help. Now, to interact with the spread sheet made, the user can enter data on each cell (like 1st row and 1st column, 2nd row and 5th column, etc.) by selecting the required cell and entering the data that can be alphabetic, numeric or alphanumeric. PLEASE SAVE THIS FILE IN THE FOLLOWING PATH OF TURBO C AND MAKE SURE THAT BGI FOLDER IS ALSO INCLUDED IN THE "TC" DIRECTORY: C:\\TC\\BIN\\zar.cpp

This is a computerised digital dairy.

Looking for faster performance? If you have an older database driven ASP app, it probably uses an ODBC DSN in its connection string to reach the database. It probably looks alot like this: "DSN=myDSNName;". If you see this you should immediately upgrade the code to ADO/OLEDB--Microsoft's new standard. Not only will this help you keep the code current, but it will run faster and take up less memory. Below are the connection strings for OLEDB/ADO for both Access and SQL Server--the two most common databases for IIS platforms. If you are using another database, you'll need to consult your db's ADO Provider's documentation for the proper connection string.

Display a page that allows you to type in a SQL Query statement, and display the results in HTML Table format. The number of field parameters and field names are immaterial. It will display the results in an easy to read format. Great for customer reports. The Code will not allow an Update or Delete query.

Teaches you how to allow your users to build a dynamic sql statment for searching your database, paging (nice little auto paging function I wrote included), dynamic sorting, etc... Access 2000 sample database included.

Demonstrate how to use ADO and ASP, includes Paging, Editing, Searching, Stored Procedures with MS Access and more.

Simple ASP codes showing "Survey" and online quizes

This is a task manager online. What this does is allow a group of people working on a rather large, or even simple project to put down tasks or ideas that are related to their project. I use this for my school assignments and the current web site that a group of my friends are currently working on. This Task manager has a whole lot of features that have not yet been implemented but you have the ability to add tasks, asign yourself to tasks and also edit tasks (if you are working on them). On the main screen you will see a list of all the tasks sorted by importance. If you wish to sort the list by a different order, just click one of the headings ('In Charge' 'Date') etc. You will also notice that according to the level of importance, the colour differs (red for level 1, yellow for level 2, green for level 3). This code teaches how to use SQL statements to access, update and insert data into a database. It teaches how to use the server() function in asp, and also teaches how to use cookies for login purposes. This code is fully commented, and if you would like any more information or wish to contact me, please email me at [email protected]

You can use ADO GetRows to output and ADO recordset to an array. This is often useful in n-tier applications when you are moving data between tiers--or if you want to persist your data in another way. http://adozone.cnw.com/default.htm

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.

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.