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

This tutorial will give you a crash cource in working with Interbase (A free, open source databese from Borland) and ADO. It will show you where to get the database engine and teach you some simple basics.

Updated ver 2.0. In a network environment, open a connection to a database, retrieve data, close the connection, work with the data, reopen the connection to communicate with the database again and do a batch update. This app shows you how. ADO data binding without Adodc control, database file creation, table creation, and combo box data listing and click to find a record is demonstrated. I appreciate your comments.

Populating a standard combo box with data from a recordset of 15,000 records or more seems to take forever. I used API calls instead of the AddItem method and my test results shows my function is at least 3 times faster than the AddItem Method. This download does not come with a database file, so if you'd like to test it then provide your own db. Please post the number of records in your ADODB recordset object, the time it takes to populate the combo box with the Additem method (just uncomment a line in my test project, it comes with a timer), and the time it takes using my RecsetToCombo function which is made up of a couple of API calls.

A article showing how to create a global ADO connection to SQL server from a Visual Basic Client.I have more examples and programming solutions on my web site www.SQLwarehouse.com

Populates a treeview with a database's tables then uses the node click event of the treeview to populate a data grid.

Connects a Data Grid control to a data source using Datalinks and an SQL statement.

This code will show you how to connect to a mySql Database using a DSN. It is very simple program but it shows the basics.

There has been a few questions on how to use VB to connect to a mySql database. This will show you how to connect without using a DSN. Most of the code is from a ADO Tutorial from this site. I just modified it to show how to connect to a mySql Database.

A perfect example of using an Access database. With these example, you can add, delete, moving in the database. All validation is done. Use PageUp and PageDown to seek records. Very nice interface. Reusable code. All code is commented. Simply the best example ever on planet-source code about database management.

The prodram look just like Access, so don't be mistaken. IF you won to learn how to work with databases- the answer is Quarantine DB. The program uses ADO and DAO. With QuarantineDB you can work with, create, delete, rename tables and queries, add, delete, update records. You'll learn how to work with MDI form. Just try it and don't forget to VOTE FOR ME. e-mail : kicheto@goatrance.com

Backup and Restore your Outlook Address Books contacts. You can save your contacts as different profiles which means you can maintain different contact books and restore it whenever and wherever you want! Saves you considerable of time and resources since your address book is now intact and is stored in a Central repository. Ideal for a network environment with a central Database server(SQL Server, preferably).

Search data in a database depending of what you write in the textbox, if you press the "M" key in the textbox you will get all the data that begins with "M", VOTE FOR ME !!

Learn how to quickly attach a console to a window for instant output and feedback. Console apps trivialize the ability to output text data in a fast efficient manner. Displaying diagnostic data in a windowed application is not so trivial or straight forward. Have you ever wanted instantaneous feedback on a variable or state in your windowed program at run-time? One solution is to "attach" a console to your window. Through this attached console, your window can conveniently output information. The WinProg source below does just that. WinProg allocates a console window in WM_CREATE. It is through this console that WinProg can communicate what messages are being sent to it. The example below handles various messages in the window handler and then outputs them to the console. By retrieving a HANDLE from my CreateOutputConsole() function, you can then display whatever data you wish with a simple printf-like function - ConPrintf(). Just pass the HANDLE to the console, the size of the output buffer (big enough to accommodate the format string and the optional variables), the format string i.e.("Data: %d") etc...and the optional arguments (if any). Very similar to printf().

Version 1.0.13: added some error handlign. NEW! Added functionality: now it works also with password protected access databases. Update your new database from your old database at amazing speed. The program updates all the tables from the old database to the new one. If you find anything faster than this please let us know. Enjoy

This little bit of code and table will help you manage tables with linked/split databases. Currently it only handles MDB or Access databases, but it would be a simple task to set it up to handle other types of tables. Basically, with this little code, you can Import a table from another DB, Export and then LINK to data from Current db to another db, or Link to external data in another Db all automatically just by setting the tables in the MOVETABLES table. I'm also going to add some features that will allow you to "upgrade" an external data table with a new Structure for those of you who make a new front end and also change the structure of the back end but you don't have access to the production version of the back end for whatever reason. Should be up sometime today.

Using ADO: This is a demonstration of how one can take selected items at runtime from a user, create a parameter query using the selected items and then run the parameter query.

Create a CSV file (ie. for Excel(???)) based on a parsed ADO-Recordset - very cute :)

Take the advantage of learning ADODB and the datagrid control in a MdiForm with the capability of doing; addnew, delete, edit and search... Thanks for using ...

Thanks to Collin McAllister for the 7/13/1999 submission this is based on!! A visual adhoc query form that allows multiple criteria selections and simple joins. A simple (limited) somewhat user friendly way to create simple queries.

VB module to read and store ANY kind of picture file pictureboxes support into a database, it's easy and it's pretty fast... please, rate it, any comments are wellcome