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

If you want to build an application that can work with several database engines, the main problem you will have to deal with is the different ways for specifying date expressions. This class will allow you to forget those differences. You can enter date strings in any format "dd/mm/yy", "mm/dd/yy", etc.. The class will validate the correctness of the date string and convert it into an expression you can use. Works for SQLServer, MySQL, Access, Informix and Oracle, and it's easy to add more engines.

SQL Writer Pro (using ADO) is a Universal Data Access (UDA) tool. It lets you query OLE DB data sources, author SQL scripts and queries, return query results to a grid, retrieve provider properties, execute multiple SQL scripts or stored procedures simultaneously, and more! This is a work in progress. I ran out of time before being able to complete this application. If you can improve upon it or complete it, please let me know. Otherwise, enjoy!

Allows you to load and view any outside XI report file from your VB6 code.

How to create Access database directly from VB code? This program will create BAS module with all the database structure informations and you can include that module in your app. and create as many databases as you want. Sample code and infos included. Don't have to vote, just use it and send an e.mail for any error you find, any feature that you like me to include (like compact, replication, etc)

To show how to use ADO Data Control

This is a gym application that I created for my VB class. This App. keeps track of members, employees and inventory. This program uses MS Access with SQL DAO.

This code demonstrates how to use a connectionless recordset.

The purpose of the following code is to demonstrate how you can load a datagrid with data from a text file.

Advanced filtering and sorting (since v2.0) class for Microsoft Access 2000. Dynamically add and remove one or multiple filters while maintaining the current record if possible, the method used for this is faster than a FindFirst approach on ODBC connections. Prevents filters being added returning no data. RecordSource is created dynamically, no advanced SQL knowlege required. Disable all Access-own filtering and sorting functions as they'll interfere with the class. Import the class into your Access (library-)project. Code contains basic usage example and further explanations.

Demonstrates many common VB controls, ADO databound controls, Datagrid, and input validation in a VHS movies library. Hopefully demonstrates good code style.

This is a basic example of how to use an access database in an application.. an address book... It has options like search, add, delete, view all.. again, just an example

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

The purpose of this program is to compute the salary of each of employee.

Easy way to create a backup job and schedule it into SQL Server. Pretty small and restricted but allows you to specify backup schedule such as Daily, Monthly etc. You can backup your database and restore it.

This is an updated version to (http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=53106&lngWId=1) It is quite out of date: 1.I found it years ago; 2.it is first written in 1992 by Ethan Winer; 3. seldmom people use dBase nowadyas. But I picked it up last night and decided to make it better: wrap it into a handy OO class, support for all character-sets, tidy up all the codes that strictly follows the coding standard. Changes: 2004/4/13 15:05 GMT-8 1.mimics part of the ADO mechanism(MoveFirst/MovePrevious/MoveTo/MoveNext/MoveLast/BOF/EOF) 2.State(Open/NotReady) 2004/4/14 09:55 GMT-8(v3) 1.all long types to support as more records as possible 2.built-in all field types

Use one generic sub to fill all comboboxes or listboxes on your form(s), with data pulled out from database.

This program demonstrates how to access, modify, and save information from a Microsoft Access Database file, using a GUI. Users can add view information with a listbox, open a webbrowser to a contact's url, even send them an email using the default email client on their machine.

This submission was deleted due to the recent hacker attack. So I'm re-posting it to give access to other users who want this code.

With SQL Server, to save a value to a field with an IMAGE data type, a programmer must provide the proper means to save the data so that the data can be properly interpreted by a bound picture box or an image control. Simply binding the image field to a picture box and populating your picture box with a LoadPicture command will not save the image to the database. Here, I will share with you how I tackle this problem so that I can make use of the bound capabilities of an image or picture box. I've tried this way both in SQL Server 2000 and MS Access database, and it all works. With this program, a MS ACCESS database is used, but don't worry, with SQL Servers, you will just have to change the connection string definition in order to access the database and off you go.... Enjoy.

This application illustrates basic manipulation of the treeview control like populating a treeview with items from a database, expanding the treeview nodes manually by clicking or by automatically by code, searching a tree for an item and others. This also illustrates how to simply create a splitter by using pure vb code. Please give feedbacks.