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

Exports an ADO recordset to Microsoft Excel.

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.

Allows you to automatically generate column headers and load all the records from a table or SQL statement into a listview.

This Dll is just an expansion upon the previous submission to create .xls without having Excel on the machine. It allows an ADO recordset to be turned into a spreadsheet, with some formatting controls (borders and allingment). It also allows floating point values to be added, the conversion routine was nicked from PSC, and is left pretty much untouched from the submission found here.

As a lot of other people's reasons for posting source I post this because I couldn't find any help with the MS Data Environment. So after playing around with it I finally got it to do what I wanted it to. This Example is composed of basic ways to manipulate the Data environment. Add, Edit, Delete, Search, and pull report information. Use of ADO Transactions is also covered. Hope you enjoy it and learn something. The example uses the basic contact database concept. Please vote if this code is useful.

This is an Home Inventory program that uses the cuecat that was given out by Radio Shack. It also show ADO connections Data Reports. You can keep track of your movies, what you have and who borrowed them as well if you sold any. You can scan or key in the UPC from movies as well as groceries. This still needs a little work, but I am on the right track.

This program retrieve the tables and column existing from DSN ODBC. To do, use the OpenSchema method frmo ADO.

This is an excellent database program the screen shot speaks for itself has a lot off features. Basicly for storing and keeping track of employees. "PLEASE RATE IT IF YOU LIKE IT" it also has a custom CD Player built in. I will be uploading version 2.0 in 1 week so keep an eye out for it cause if you like this you'll love version 2.0. Still a littly buggy but it's still in its beta stage. Thanks PSC

I have worked out all the bugs in this realse, I changed the UI a little but it's still the great looking employee database. PLEASE RATE IT IF YOU LIKE IT . Any comments are welcome. The User Name and Password is "admin"

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.

This code snippet will show you how you can convert an ADO recordset to a delimited text file in just a couple lines of code using the ADO GetString Method. You can easily export a recordset to a csv file using this method.

Create Shape Statement For Master/Detail Form In Visual Basic.I Made This "Generator" Because I Couldn't Remember The SHAPE Statement And Now I Publish It For All Developers Who Cannot Remember It And It Is A Good Example Of ADOX And ADO.The New Version Is With Full Test Of SHAPE Statement.

PlanetSource code is a life for VB programmers. I have learned many thing from this website so I felt I will give this code to all the programmers who are willing to learn the database concepts. I tried for this kind of code but all in vain. Dont worry. This is the best and the ultimate code for all the Database programmers who have been waiting for ages. The whole world is looking for a control of this sort. I as a enterprise solution provider found it very difficult to debug the recordset and find the exact match in the recordset by pressing F8 .. F8 .. F8. Dont you think doing this way wastes your time and money... The main purpose of this code is to print the contents of the recordset of ADO,DAO,RDO. Within a fly we can see the contents of the recordset. This will save a lot of time. The main purpose of this code is to pin point the exact location of the data that we need. We use filters to check the data and reduce the recordset to find the exact match. But this control by clicking on the tab sort the contents of the recordset and display to us. You can change the order of the recordset fields by dragging.

To handle multi-users / concurrency of a MDB using eith DAO or ADO in the VB 6.0

Heres the update to my Address Book Example that pulls it information from an Access Database. I finally added the search and delete functions because I got tired of getting email from people asking me to write the update. :) Sorry it took so long but I've been busy opening up my office... Email any questions you have or comments to [email protected]

since i couldn't find any code that let me connect to an sql data source i got to work and wrote one i think it's real easy and it lets you connect to the sql server while still using a data control

This sample project will show you how to easily structure a query to a DataBase. The sample uses the NWND.MDB that ship by default with VB5 and 6 and demonstrates on a searchform how to search on a text from a textBox and use the different comparison operators like =,>,LIKE, etc. NOTE: This is for total newbies that have a hard time figuring this out. I myself had a hardtime in the doc to get an easy explanation on this. Cheers, and hope you enjoy.

This is just a demo for dBASE files. It will open any number of dBASE files and there is one function which can be used to get data from any of those .dbf files.

A simple project which can serve as a good example for use of crystal reports,DAO and dynamic control arrey.

This program converts any SQL Server table into a CSV text file.