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

Complete wholesale product inventory database program. Combines Access, DAO, and Excel to manage inventory, write reports, and print forms. I wrote this for work so you might as well have the code.

With this application you can see how DAO works. You can completely control the database with this code, you learn how to read, insert and delete things from a database with no data controls or whatever :-) And also a great deal of the ListView control is used for this app. And it is completely documented and explained!!

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.

Accesses any ODBC database using ADO. Records are displayed in a table withe rows that alternate colors. Paging control code allows the user to select which page in the recordset to go to. Current code has been tested with Microsoft Access and SQL 7.0.

This demonstrates how to create a database and components at runtime from a public sub called from the AdoxData class with ADOX 2.1 objects

Need to do any oracle/ADO work? I wrote these to help me along in my projects. I hope you find them useful too.

This class will let you create ADO recordsets on the Fly - Without a database.Once I wrote a dll that had to return an ADO recordset, but as I had no connection to a database, I had to write this class and I felt like sharing it.This class will worl only under VB6

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/