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

Although unfinsihed but the codes and database i used here will truly help beginner programmers to understand the use of standard forms, listview, MS access database conenction, and other technicques. I wrote this project for an unknown friend over the net who just requested me to help him. Likewise, i made it to be public for others who may also wish to get little techniques out of this codes. I have more projects available for request.

*****UPDATE: Now read is much faster (before 17 sec for 10000 records, now 0,3 sec)***** DESCRIPTION: This is sample of small database engine. It support few SQL queries, add muliple tables, add and DELETE records, username and password for access to databes data... There is also RecordSet class so this make it easiest to use. Deleted items is only 'invisible' for reading, but they are still in file. So for real remove there is clsDbAdvanced class. SQL Queries: CREATE TABE, INSERT INTO For deleting data there is function (supports multiple conditions and operators =, <>, >, <) For reading there is also function that sets data automaticly to RecordSet. Please check it and leave feedback and if you wont wote.

This application handles the basic processes in running a hotel.checkin, checkout, employee record, search guest and employee, payroll, bar etc.

This application is an automated banking system.it keeps track of custmers and employees. you can Add,Edit,Delete,Search and generate report based on certain criteria

Generates payroll reports all base from DTR and is use to record the daily time record of an employee.

Advance Search Database It provides advance searching for MS Access databases. No need to provide Table names; it will retrieve tables from the given database and list it out. Just select table names from the list and put the record to search. It will return you the fields and table names where the record present. Its so simple to use Basically it is use to seach the whole database. Many of the times you gets confused in which table the record present or while analyzing software you entered a record and want to find where actually it get stored into the backend. Just try it and then rate me.

It is Quiz Software for online Examination

Autocomplete textbox and listbox in one. Gets data from a recordset then populate the listbox. Autofills the textbox then synchronously highlights the listbox. Great autocomplete please vote for ME.

SQLite VB Sample ---------------- This is a sample program for SQLite database using dhRichClient3 db engine and FreeImage for rendering BLOB image data. It contains a simple user management module within an MDI container that can be used as a template for further application development. Requirements: 1) dhRichClient3.dll (COM-Dll, current version 3.0.19) and sqlite36_engine.dll (StdCall-compile of sqlite-version 3.6.20) both are included in the Toolset-Binaries: (ca. 1.3MB) download from http://www.datenhaus.de/Downloads/dhRichClient3.zip. 2) FreeImage.dll - download from http://downloads.sourceforge.net/freeimage/FreeImage3130Win32.zip. --raffysantos @ hotmail . com 9:29 AM 12/15/2009

Base de Dato para clientes utilizando Access, Interfase grafica. = Data base using Access… Unzip the file in this directory “C:\” likes that the Data Base would be reed by ADO. USER: ALU PASSWORD: ALU if it does not work inside is a manual make in flash and written a manual. Descomprime el archivo en el directorio “C:\ “de esa manera la base de dato puede ser leída por ADO. USER: ALU PASSWORD: ALU si no funciona dentro hay un manual el flash y escrito.

Tutorial explaining how to connecting vb6 to a MySql server.

Add your source code to this book and get back when you are working. Thanks Shyam Singh Chandel

ITS A NEW TECHNIC WHICH I USED HERE, I NEVER SOW THIS TYPE OF UTILITY. HOW TO RESTORE LAST DELETED RECORD FROM ACCESS FILE. THANKS SHYAM SINGH CHANDEL

This code shows how to use ADO with Visual Basic 6 to generate a nice user friendly application. The backend database used is in MS Access.

No ADO Library. Direct connect to MySQL Server 5.0 or above. Use libmysql.dll(written by MySQL AB in C++) One dependecies libmysql.dll Download link:http://www.gurevin.net/dll_libmysql.rar Optional return table convert to ADO Recordset object. (in use grid ocx's) Full Speed Connection, pure visual basic 6.0 and libmysql.dll. I'm sorry. My English is not good. :( Function List: BathRealQuery, BathRealQueryFromFile, BathRealQueryFromResource, BathRealQueryFromResource, Connect, ConvertADORS, DatabaseExists, Disconnect, EscapeString, Execute, ExecuteNonQuery, ExecuteReader, FieldExists, FreeResult, ListDatabases, ListFields, ListTables, Ptr2Str, SelectDatabase, SendQuery, TableExists.

Designed as a solution for business-to-business sales. Easy-to-access features include customer and supplier contact management, order processing, accepting delivery, constant product monitoring, user access setup and producing sales & inventory management reports. It also provides easy-to-use menus and toolbar icons.

Searching and Browsing is among most common task for database application. fast search is definitely is a must for good database application, specially application with high transaction load like Point of Sales. i use this because i have difficulty in displaying data to user fastly, at first time i use grid by bound it to recordset and did not notice that it is only displaying +/- 2000 record until my customer tell me that it is did not show all the data ( what a good programmer :) ). then i search msdn and found that it is ms hflexgrid limitation ( WOW ). and i start to use the clip function just like msdn told me to. and my customer say "i wonder why yours is slower than my foxpro program", i reply "because foxpro only display data page by page because foxpro procedural programming", "why dont you display it like foxpro" he ask again. that is the story of good programmer :) who learn from good non programmer. hope it is usefull for you.

its a simple airline reservation system using ADO.. it was my first project .. but is quite simple and easy to undersatnd

Allows the user to open a Microsoft Access database, and loads a treeview with the tables, and queries. Demonstrates treeview, datagrid, compressing and deleting database data. Thoroughly commented. Give it a shot, and if you are motivated, please vote.

i made this program in 2 nights... XD im dying.. hahaha... please leave a comment and please vote for my code.. thanks A LOT!!!!!!! :) please see Module1.bas for settings