Results for "Category: Databases/ Data Access/ DAO/ ADO"
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
Student database is a multi-management database system. It manages all records of student and their result data too. Student database can generate a student’s result in cGPA depending on given subject marks automatically. * Download ActiveX and register them by using RegThem.exe : Download : http://www.box.net/shared/893eyb6rsd
It is a simple application that can connect to any database of MS-SQLServer 2000, and can get and store pictures in the specified tables of that database.
Flexible Phone Book can Save any phone & address list with ActiveX.OCX and xml technology. You can just modify,add or delete xml and field name whithout modify the source code.
it is best example of ADO good graphics stock,purchase,invoice,returns and many more you can learn many things from this,but inprocess,this codes realy impress you
This is a way of expressing my sincerest thanks (to all Developers who contributed and continously sharing their ideas to VB community) by providing at least one sample appplication that would give an idea to Beginners as well as in the Intermediate level of Database programming of what an N-Tier application is all about. This is a transaction oriented-application (see your SQl Profiler)capable of accessing database through stored procedures and without single Adhoc queries involved. Business rules were implemented through the middle layer which you can compile as in process dll at anytime and used it by setting the reference and instantiate to exposed its objects. An option to change your connection has been included during logon to allow user to change database connection. All exeptions are handled by error trapping code so don't worry about unexpected closing of application. I have also added some crystal report functionality and show how to use TTX files(Field Definitions Only) on stored procedure. Should there be any bug occured during runtime, please send the details to me. Thanks and Please vote.
Avoiding runtime errors caused by the "new" operator using exception handling with simple three different methods
This system will help you to use a listview as a grid in vb6.0 it uses a ms access were the data to store... It is easiest way to learn a adodb and adodc or a ado....... using a hard code for you.
This system will help you to use a listview as a grid in vb6.0 it uses a ms access were the data to store... It is easiest way to learn a adodb and adodc or a ado....... using a hard code for you.
This system will help you to use a listview as a grid in vb6.0 it uses a ms access were the data to store... It is easiest way to learn a adodb and adodc or a ado....... using a hard code for you.