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

Whith this class you can load a lisview control with a recorset, and export the data to the TXT, CSV and HTML Format, you can use or not the progressbar.

Here is my first submission on www.pscode.com, This project prepared to help you to convert your Ms Access Database into MySQL data source format. On this project, I'm using some API function to Draw caption or Picture, so it is helpfull for newbie in VB to learn about API programming. I'm using osenxpsuite controls, to improve my GUI application. if you does not have osenxpsuite controls, you can download it from: http://download.osenxpsuite.com/osenxpsuite.zip I WAS TESTED THIS APP IN MY PC P-III 730 Mhz, and It work fine. It can convert nwind.mdb to MySQL data source for 7.07 seconds If this project usefull for you, PLEASE VOTE THIS APPLICATION IN www.pscode.com Note: - MDAC 2.5 needed - OsenXPSuite controls (http://download.osenxpsuite.com/osenxpsuite.zip) needed - MySQL oDBC 3.51 Driver needed DOES NOT SUPPORT: • cREATE INDEX • CREATE PRIMARY KEY • CREATE FOREIGN KEY • CONVERT BINARY DATA VALUES (BLOB) IF ANY IDEA HOW TO SOLVE SOME TROUBLE ABOVE, PLEASE LET ME KNOW. I REALLY NEED HELP ADVANCE VB DEVELOPER TO SOLVE MY APP THANK YOU

This is a program that uses the ADODB connections to link to an Access database. All connections are created/opened at runtime. Security,passwords,usernames are in Database. Users are in two user groups. Uses SQL statements such as INsert, SElect etc. Links to website uses MDI form and Child Forms. Toolbar with Image list. Status bar that displays a random message. Data Reports using Datareport control. Class Module Example. ISnumeric validation. Search facility for searching the database. examples of using the List View Control

links to the bible allowing searching and indexing of indervidual passages, works using sql and select statements. Program also demonstrates web browser integration and use of the flex grid and shaped forms. you can either select a bible passages or sub chapter etc... or you can enter a passage using the global format, example: Genesis 5(5:9) NOTE ALL BOOKS HAVE A CAPITAL LETTER AND SEARCHES ARE CASE SENSITIVE.There are a few bugs still in this program in relation to back to menu buttons mid wizard and stuff, so be carefull.

Database! Reviewer for exams! It uses randomize for questions and answers, and calculate percentages for correct answers. could be useful for quizzes.

Using datareport without data environment its only a adodc connection

It was design to handle complicated computation and relational, hope you find it usefull in your learning, i use SQL SERVER 2000 For the database which can be use in LAN / StandAlone, hope you enjoy this.. pls give a vote on this one =)

This in an Online Quiz System. The instructor can let the students take the quizzes online. There are two programs: Faculty Server and Student Client programs. The FAculty Server program needs to be run in a server unit. The Student Client program, which is stored in QUIZCLIENT subfolder needs to be run in several client computers (like 30 computers). It uses Winsock and MS Access 2000. Connect the database thru ODBC. String manipulation is "heavy" which includes chracter sentinels to break the data being sent and received. If you have questions just email me. Thanks.

Would you like to add an XP style login to your application? This login will allow you to register and will not allow duplicate usernames. You can also change the color scheme at login. You will need OsenXPSuite for this app. Uses ADO to connect to the Access database.

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