Results for "Category: String Manipulation"

Sample application/*.sln for beginners and intermediates using OLEDb. Other controls used are ListView, ListBox, and MenuItems. Also uses ArrayList as a collection holder for the entries in the DB. Comes with *.mdb file. Pretty good beginning point for OOD. Complete with Update/Delete/Add/Refresh SQL Commands.

DataEasy: is an application written in C# which would allow the user to load any Microsoft Access file (file format '.mdb'). This application uses OleDb as a backhand communicator with the file to allow the user to : select, delete, insert and modify the database and then save all the changes to the original file. Along with the Data Grid control TextBoxs and Labels are generated automatically and dynamically at run time to allow easy and efficient data input according to the data in the .mdb file loaded. If the file has more than one table in its database, a combobox in the application will allow the user to choose which table to work on. By right clicking column headers who’s data type is either ‘integer’ or ‘DateTime’ the user can opt for either inserting Automatic numbering based on previous cell’s value incremented by 1 or insert that day’s date automatically in their respective column on adding new data. Also provided a Search and Filter capability, by right clicking the search form’s column headers the user can filter in the element (of the column clicked) he\she wants to view. Multiple filtering can be done by filtering more than one column. The user can also use a simple search, by typing in the search textbox to find data in the database. I have included a database file ‘textbooks.mdb’ file with the application so you can try the program. I hope this program will be useful in learning how to load and modify databases and link to ‘mdb’ files, your voting will be appreciated :).

This code is made up of 2 new VBScript classes, the other VBScript class - clsSortableTable.asp was submitted by another user and works great. The first new class - clsDynaEditForm.asp creates an HTML form based on any table/view in the database and can even validate selected fields. The other class - clsUpdateDB.asp is then used to update the database.

Often I use flat mdb files to post forms to on the webserver. This is a simple page to just grab a table from an mdb file on the server with a DSN-less connection and display it as an HTML table, so I can copy the table and paste it into Excel or Access, or just to get a quick look at the contents.

Simple Access database viewer! Just enter your database location, and it shows your tables and stuff. SQL Querys!

Download a binary large object (BLOB) from the database without temporary files or chunks.

Convert a SQL query into ASP code.

This code compares the table structures of 2 MDBs and returns in Red that values that are in one DB but not in the other.

This code is to display, in a simple and fast loading treeview, a database. You can have up to 10 level and the treview is loaded just once (not at each level). Each level can have a checkbox (in a form), link and many other that can be set it up in only one founction.

I wanted to add paging code in my project.I've seen all other codes on the site but they are not at all worth for me. Now I've written a code which is very easy to understand and can be used by any student or professional in their projects.

User can Login/Register and then update his/her profile. So Powerfull By Designing & Coding Wise At every step user is briefed that what;s going on and why. Easy to Learn for begginers. I asure after to read this code He/She will not be dependable of any one according to ASP Database

Saves time by NOT having to download your access database to Compact and Repair then re-upload again.

this is a wrapper for some of the more commonly used database functions. can help reduce your code dramitically.

This example demonstrates how to create subform in Internet Explorer like in MS Access. It works in same principles as a database.

This code is an ASP VBScript Class that allows you to find any acccess database on your server, and connect to any record in any table and edit,add or delete. It has a full grid function for paging through recordsets.

This simple code plots a bar graph based on total results of a selected field on a selected table from a selected database. See a demo at http://www.industriavirtual.com.br/codedemo/rsgraph/default.asp If you like the code, please VOTE!!!

only change to your database name. yazi.mdb to yourdb.mdb ( find and replace in notepad )

It can make, edit, delete news articles. It has a rich text editor (from htmlarea) and supports multiple users. In this new version there are some bug fixes and you can now make news templates so you don't have to type out the same thing all the time, the new version also includes a general connection string found in conn.asp.

This code pages a database recordsets in a very cool way, like the good seaches on the web. The ideia I designed was to show all pages, but not all of them (imagine in a case of 1000 pages). So, it shows only ten pages placed in the point you are only, and a link for the last and first ones... It helps who does not have the patience to see all pages, and also for the ones who does.

I may be reinventing the wheel here, but so far I have yet to find a built in Delphi function that will convert a string to proper case. I found this code somewhere on the web a while back, lost it, and managed to recreate it last night.