Results for "Category: Databases/ Data Access/ DAO/ ADO"
Unfinished video rental proj.(currently working on int) Shows you how to make your code multi-tier ready, reusable, how to use class, how to dynamically add toolbars, this is kinda basic but will help begginers to intermediate! I like the way PDSA codes that's why i pattern my code to them :) Begginners if you like my code or learn from my code pls. vote!
Simple, but effective. If you use MS Access for Client/Server apps, you'll never need to write another piece of code to display your reports, just add this form to your DB and it'' do the rest. Double click to open a report normally, or send it to Word/Excel or HTML format.
If you liked the Report Manager you'll love this. Again, it's very simple but effective. It allows you to manager both your Access queries and reports directly from a VB6 program, which sure beats writing code to do it. Have fun!
If you do any work with Access, you'll love this. It adds a sliding TreeView to the side of a form in MS Access allowing you to navigate through data
This VB6 project demonstrates how to edit an ADO multiuser recordset using databound controls. It is based on the 'single-record form' created by the VB wizard, but adds: * Enhanced error handling * Improved user interface The demo allows several instances of the form to be opened, for a 'pretend' multiuser network.
This is a simple generic wrapper class to quickly general ADODB Connection strings, including password protected files & shaped recordsets. I've only needed support for Jet & xbase files so that's all I've included. Please feel free to expand and post them as long as I get a copy of any changes.
I was in need of certain application that can store data in to the database and the database is stored on the Web.. And I want it without XML. I asked many people that how Audiogalaxy and Napster are doing those all the things.. they told they are using such service like XML or other.. But I don't want to use XML. So I develope application for me.. It is really very easy to use and also very easy to develope.. This is made with Visual Basic and simple codes of ASP. Must See this code.. and please vote for it.. NOTE: Now probleme is that, that I am not able to get data from the web. If any one can do it.. please let me know..
To show the ease of adding any Crystal Report to your VB application
This is the database editor version 2. I did not submit the first version. However, I made changes and enhancements to improve the program. It only works with MS Access type databases. A person does not need access installed on their computers for it to work either. You can create new databases, open existing databases, compact a database, add new tables and change the database structure. If there are any suggestions for improvement, questions how to use it, to give feedback, or even if there are any hidden bugs, please do not hesitate to email me at musictopia@cox.net
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).