Results for "Category: Databases/ Data Access/ DAO/ ADO"

A simple example of making a login for a program using ADO with an Access database. Also allows you to register new usernames and passwords. This program could be improved upon by adding a Primary Key to the database and a few others. I just wanted a simple login so I didn't take the time to put in any extras.

Builds complete ADO ot DAO application for all tables,queries and fields in Access database.mdb including code to recreate database

UPDATED. This class is made to access dbf file. This class can read and write to a .DBF file. This class can create a new file, and creating fields as well. Some additional functions are provided, such as, search record, find text, search distinct value, etc. Good or bad, please leave your comment and vote. :)

IVEDI Mesaj 1.0 Code Local Networkler için hazırlanmış örmek projedir. Ayrıntılı Bilgi İçin : gokhan1938@hotmail.com

Hi, there is a new version of SmallDBEngine. New version support indexing, and it's much faster (read/delete). Now RecordSet read records from file: MoveNext find pointer to next row and then reads only this row (v.1 reads all records and save them into array, what is slow and use much memory). There is also a class to export whole DB into sql file. This is only sample project, so don't expect so much from it. You can see one way to create indexing. NOTE: this project support only TEXT fileds (and also only indexing by text, if you want more effective search you must create column data types and create indexing for each data type). I'm created a template for project with custom data types, and I'll create a code when find some time for this.

it is hospital lab management system,manage the patient profile and their diffent Test record

A simple example of database use in VB. Not very well written but may help some people.

Clinic Management for Doctors

A 'vanilla' Media Library application sample to store, maintain and review CDs,DVDs,Books in a Media Library by barcode or unique media key. It's unique in that it is using a Binary Search Tree Nodes Class - an effective and very fast searching/database storage methodology. This is a self-contained binary tree class along with a non-gui listbox class to create, search and maintain any unique key data in a binary tree. A lot of databases use this methodology as the basis for their database engines. Now you can have the database power inside your application. For example, a search of 3,000 keys will only require an average of 7-11 tree visits/seeks regardless of the key your are trying to locate. Also included are member routines to output all the data keys in tree in alpha order or even in reverse alpha order. This has been extensively tested for reliabilty and fast response for searching, insertions, deletions and traversals of tree nodes in general. Included root node release, tree re-balancing and garbage threshold detection and collection. Also extensive notes and a built-in commented example project/form to build a couple of example binary trees which output to a gui listbox. Also to demonstrate some of the class member functions usage. You may be surprised to learn there is little emphasis on recursion so no worries of runaway stack levels. (c) David K Richmond

(NEW UPDATE May 21/05) A unique Media Disk/Memory Library application sample with DISK BASED LIBRARY ACCESS as well as MEMORY LIBRARY ACCESS. It can be used to store, maintain and review CDs,DVDs,Books in a Media Disk/Memory Library by barcode or unique media key. It's unique in that it is using a Binary Search Tree Nodes Class (UPDATED since an earlier article here @psc) to allow optional DISK based BS Trees as well as the established previous existing in MEMORY version). This is a self-contained binary tree class along with a non-gui listbox class to create, search and maintain any unique key data in a binary tree. A lot of databases use this methodology as the basis for their database engines. It's an effective and very fast searching/database storage methodology. For example, a search of 3,000 keys will only require an average of 7-11 tree visits/seeks per key search. BSTN class member routines include, the output all the data keys in tree in alpha order or even in reverse alpha order. This has been extensively tested in MEMORY MODE for reliabilty and fast response for searching, insertions, deletions and traversals of tree nodes in general. Included root node release, tree re-balancing and garbage threshold detection and beta level collection. This version has an updated BSTN Class (see other psc article) DISK ACCESS wrapper to overload the BSTN member functions/properties to allow direct access to a disk based node tree around the sample media library - sample included in this article. NOTE: The DISK ACCESS mode has NOT been extensively tested as yet (look out for release late May 2005), but the project was fit to publish. If you don't need the DISK ACCESS mode, it won't be turned on unless you choose to enable it but all the MEMORY functions will work as expected. You may be surprised to learn there is little emphasis on recursion so no worries of runaway stack levels. GARBAGE COLLECTION UPDATED under menu tools options. see Help How-To. (c) David K Richmond

Binary Search Tree Nodes Class - an effective and very fast searching/database storage methodology. This is a self-contained binary tree class along with a non-gui listbox class to create, search and maintain any unique key data in a binary tree. A lot of databases use this methodology as the basis for their database engines. Now you can have the database power inside your application. For example, a search of 3,000 keys will only require an average of 7-11 tree visits/seeks regardless of the key your are trying to locate. Also included are member routines to output all the data keys in tree in alpha order or even in reverse alpha order. This has been extensively tested for reliabilty and fast response for searching, insertions, deletions and traversals of tree nodes in general. Included root node release, tree re-balancing and garbage threshold detection and collection. Also extensive notes and a built-in commented example project/form to build a couple of example binary trees which output to a gui listbox. Also to demonstrate some of the class member functions usage. You may be surprised to learn there is little emphasis on recursion so no worries of runaway stack levels.(**IMPORTANT**: this latest version includes a major bug fix. When using the data index to reference external data, during a tree rebalance the data index was being lost or mixed up with another. It is a simple fix but significant to keeping the database integrity. This latest version is 1.1 and also includes the functions referenced in the supplemental article). ## LATEST: ## now includes a CD,DVD,Books Media Library application sample. ## (c) David K Richmond

THE ARTICLE IS REDUNDANT NOW - PLEASE SEE ORIGINAL ARTICLE [ Binary Search Tree Node Class (database engine) ] ALL NEW WORK AND CHANGES ARE INCLUDED THERE ........Supplements existing article by similar name and by this author. This is a new release and includes the extra member functions in cBSTNStorage.cls in order to allow node removal. (INCLUDES major bug fix to preserve data index during node removal).

This code copies a table from 1 ms access database to another using a Select Query....Easy to use and aptly commented...Check it out!!!

This is simple way to save and load your application into/from database.

This Sample Is Good Source For Learning How To Programming With Visual Basic And MS Access . This Program Can Control Users,Admin,User,Monthly Salary And ... This Application Is Finishid And Not Defective . Password For Login Tu System : 123456

A simple Hotel Booking Program. With its basic tasks: Reservation, Check-In, Check-out, an informative Room Status screen, and Reports.

This is a simple ADODC System for a Payroll

Complete DataBase Software Sample with Tutorial. includes Add, Find, Sort, Filter, Delete, Save, Records Navigation, SQL Queries, Reports, and Utilities. Minimum Code, Simple, Easy, and Commented. (Uses Access DataBase and ADO).

This is a well made system for computrisatio of library releated activites

Its a simple database project about apartment selling & its customer information database project.