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

This Project is an example of how to open a file into a byte array and save that byte array to an Access database, and to extract binary data from the Access database back into a byte array and save it back to a file. This example uses .bmp and .jpg graphics files but with minor modifications any type of file can be saved in binary format to a database. again this is only an example application. I threw this togethor in a couple of hours so there are some minor bugs in the code. a little bit of error handling should clear them up. Hope you find this usefull

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

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

This is an update to the fantastic work of Jeremy van Dijk on SQLScripter 2.0. I have added just a few minor enhancements by borrowing more great code from Royce D. Powers (SPGenerator). The main feature that I've added is the ability to generate INSERT scripts for a selected set of tables - definitely NOT difficult, but handy. I have also made the command line options more complete and added a few extra.

Allows you to simply type what you want into a cell of a Flexgrid control, resembles Excel. You can also enter values in the text boxes to chenge the number of columns or rows quickly

Update: ver 47 - DbaMgr provides a graphic management interface for MS Msde 1.0 installations. It allows you to manage and administer your server, databases and database objects from a Windows interface similar to the one Enterprise Manager provides, rather than via the standard oSql.exe command line utility: an alternative inexpensive console/management tool for Microsoft Sql Server 7.0/Msde 1.0. In addition to traditional Sql Server objects management and permissions, DbaMgr adds HTML documentation generation tool, attach/detach visual interface, a query interface, and a visual interface for BCP operation. Provided with built-in English and Italian language localization, supports user defined language translation. It needs ADO 2.5 installed, as long as SqlServer Client Components (Sql-DMO). SqlServer 2000/Msde2000 version available too

A Visual Basic application development framework for Microsoft Great Plains (Dynamics and EEnterprise) accounting software. This application runs completely independant to Great Plains. (If you require seamless integration consider using Dexterity and/or VBA). The initial version allows a user to login to the system, and select a company. The project has also been registered on www.sourceforge.net as open source (search for Great Plains). The idea is to build up a library of code and accelerate application development. Included is a sample program to copy security settings from one user to another. (Be sure to read the readme.txt before using this program!)

This project uses ADO to copy tables from one Access database to another. I did this up as a demo of ADO at work. It (probably) has no actual use but demonstrates ADO connection. This is my first submission, so please, Be Gentle!

Easily Compact & Repair a MS Access Database and display the size differences.

This will give you the tools and instructions necessary to convert your DAO project to ADO.

Hi folks, The purpose of this code is to scan a database's table and then export them into a number of text files. Simplely change the name of the ODBC. Cheers

This is just a small login app you can use in your programs. It uses an access database. You can add users. Starting username: username password: password. Please give feedback. I know there are bugs.

MyVbQL is a Visual Basic API for accessing MySQL databases. This API was developed as an alternative to the MS ADO - MyODBC interface that VB developers must use for MySQL database connectivity. For more information, visit http://www.icarz.com/mysql/

PROBLEM: Creating a copy of a Recordset could mean using the Recordset.Clone method sometimes. However, this is not always appropriate because ADO’s Recordset.Clone method creates a Recordset which points to the same data as the original Recordset. This means that you really do not get a physically distinct copy of the original Recorsdet. Consequently, changes to the clone copy could modify the data in the original Recordset. An alternative solution would be to use a loop to append each record to a new recordset. This, however could end up being an unwieldy solution with potential performance penalties. SOLUTION: ADO 2.5 comes with a Stream object that can be used to create physically distinct copies of Recordsets. The article below demonstrates the use of the ADO 2.5 Stream object in copying Recordsets and the difference between the Recordsets created by the Recordset.Clone method and ADO 2.5 Stream object. Please see attached file.

Complete application. Customers Database, inventory system, search databse records, cool gui, Debtors alert, password protected. This application is suitable for a car shop. Whenever the mechanic finish a job on a car the only thing he has to do is to use the service wizard and select the parts he used from a list and the number of the parts. The application substract the number of parts used from the inventory and gives the subtotal and total price. (The login password is set to nothing for the moment so if you want to access the application just click the login button)

This code can be used as a template for creating master forms.

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 !!

Simple program that views a database, transacts custom SQL statements in SQL Server 2000. The SQL-VB connection established here is the foundation of many front-end applications in RDBMS nowadays. This project uses ADO programming techniques.

What you can do is hook up to a database, and with the use of a timer control, you can make a list of any/all records you want in a database. You can use an SQL statement (in the code already) to find a certain part of a string. The return results are any record that contains that particular string in it. Then with the click of a button it will go through each record found and make a list of them. For example, For a spell checker, I took a database that contained over 5,500 words. It went through that database in a little over 5 minutes to get every word made into a list. Very good ideas can come from this, have fun with it!

Connect to text file(s) and perform advanced queries using ADO. You can even return recordsets on CSV file without a header.