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

Allows an interface to generic CSV files. It will allow you to load the file into memory, alter field values by defined name, the fields stored, rename fields in the header line,... with relative ease! HEAVILY commented -- good for learning from. This is was incorporated into an application that shared its information with perl scripts. This was updated on 12/3/02 for bug fixes (sorry if you already downloaded it).

This code shows how to use an array obtained from 'GetRows' and navigate through it as though you were using a pageable recordset

Updated: Dec 02 2001, Ver 2.5 updates are functionality to associate MS Access (.mdb) databases with Database viewer/editor, and to Maximaze the application. View/Edit data on databases that can be MS SQL-Server local/lan or remote on internet, or a MS Access database. Get Data by clicking databases/tables/columns/views/stored procedures or perform custom SQL queries. It shows ADO Programming and Some API. In this version I have fixed some bugs from previous releases and improved the functionality. Now you can view the "source" of all stored procedures and views in SQL-Server. Thanks to all who came with feedback/suggestions in previous versions of this application. The project is made with VB 6.0 Service Pack 5 and I used MDAC 2.5. Please help me grow as a programmer and come with feedback/suggestions.

This is an example on how to use ADO without ADO controls. I use the typical phonebook example... It is a complete application I use myself. You can store your friends, bussines associates name, adress, company, telephone, email, webpage, info, photo and more.... If there are several people using the same computer they could all have their own adress registers... you can create as many as you want and call them what ever you want. You can backup your database to any location you want. You can restore your backup. You can choose if you want to be in read only mode or in editable mode. When you are in editable mode you can Add a new post, edit a post or delete a post. You can send a email to current person or open his/her webpage. You can search for post using several search criterias such as: LastName, FirstName, Company, Adress, Telephone, Cellular, City, Country. The project is made with VB 6.0, Service Pack 5 and MDAC 2.5. If you dont have MDAC 2.5 you can get it at Microsoft webpage. Comments and constructive Feedbacks are always welcomed.

This is simple database program to demonstrate the use of ADO and OOP. The program includes functionality to navigate through the records, add, save, delete and find. All functionality are encapsulated in a class. The program contains very minimal error trapping, error handling and input validation. No data bound controls are used in this program. The program shows how to use ADO, Classes, Basic Module, Simulated inheritance and more. I intend to expand this further to include an error trapping and validation class. Other functionality will be included soon. In fact, this is a subset of a larger database program for a retail store.

This example will show you how to move items from datalist (which is connected to ADO control) to a listbox.

** PLEASE VOTE FOR MY CODE - EVEN IF YOU DON'T LIKE IT ** GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the DLL.

DataAccessDLL's SUCCESSOR - as a control. GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the CTL with an 'INSTRUCTIONS' function.

With DYNDATA your are able to connect to a SQL-Server Database and edit the data in thier tables. DYNDATA builds dynamically the needed textfields and checkboxes. It uses ADO without databindingcontrols. You can select a database and table from a combobox and then connect to your given SQL-Server. All information about login, tables and databases are extracted from information_schema views and system tables. It is a tool I need for editing quickly data in tables without having additional tools. Thanks for voting

Creates a Microsoft Database (MDB) on the fly and adds tables dynamically in Visual Basic. The program needs a reference to Microsoft ADO Ext for DDL and Security.

This code will allow you to make a DAO database using code instead of the Visual Data Manager. This is good if you need to make a program that makes a database from scratch on the user's computer. Has many uses if you are a creative person! Please vote for this code if it helps you in anyway. If there are any questions, just email me. Thanks!

THIS IS AN EXAMPLE OF HOW YOU CAN DO A SIMPLE TABLE WITH DATA, SO YOU CAN NOT USE THE FREEFILE() , YOU CAN MAKE MSFLEX GRID, TEXT BOX,COMBO BOX ETC WITH THIS CODE, AND IS SO EASY, TRY IT, PLEASE DONT FORGET TO VOTE FOR ME THANKS.....

BUG correction!!! Version 1.01 A solution for who does not want to use ADO/DAO or ODBC to have access its database in MySQL. With only one DLL you it has the power on all functionalities of the MySQL.

A solution for who does not want to use ADO/DAO or ODBC to have access its database in MySQL. With only one DLL you it has the power on all functionalities of the MySQL.

Backup and Compact a MS Access database file (*.mdb). Output a *.csv (Comma Delimited)File.

UPDATED!!!!! This usercontrol allows to get/put files in an Access 2000 mdb with one line of code!!! And I've forgot to mention it, if the file is a picture, it is autom. shown !!! Please leave me a comment !

Shows how ADO technology connects globaly. Also shows how to integrate ADO Data Control and the Data Grid. This project uses the phonebook concept to show these concepts.

This small application will allow users to search for contacts by name using a ComboBox. This project shows use of ADO, Search Methods, and Modular programming.

In development of dynamic website using ASP, recordset paging is one of the very useful feature. This code "Dynamic Paging in ASP" makes the recordset paging a child's play. You just have to modify three parameters in the paging.asp file and voila, you can use this code anywhere in you website. Just gives the name of database file, name of table and no. of records to display. That's it ! I am sure it will be a very handy code for any serious ASP Developer.

Connect to any ODBC compliant db using RDO. by the way MySQL, Oracle, FoxPro, Excel, Access, Sybase are all ODBC compatible. Use this code to connect to Unix databases, Linux databases, etc. Very simple (easy to follow) code. If you would like to see the same in ADO, or want me to add DB creation/editing capabilities let me know. Currently you can just add, update and delete records as well as run queries. Please Vote, I stayed up late working on this. Comments positive and negative welcome.