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

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.

This project will show you how to utlize MS Access as your report generator. If you are tired of designing your report using other third party report generators and if you want to create dynamic reports without making major revisions of your app, then perhaps this project can help you. Be sure to reference the MS DAO library, MS ADO Library and MS Access Object library. If you have comments, email me.If you like it, then vote. Use the following: Username: BetaTester Password: BetaTester

Flex Grid is Made to be More Flexible. A editable Flexgrid with textbox moving along to cells on a click or a cursor movement:)

This code enable you fill a DataReport with the information contained in a Recordset. In this example, I have a connection with a database and I fill the Recordset with a SQL sentence.

This is a simple usage of database as long as VB and MS Access are concerned. But you can certainly use this on your literature class. Zip file includes a database containing more than 200 biographies of classical authors.

Parent Child items in a database table is a well-known issue. Hierarchy in just one table of the database without complicated relations between tables can be obtained by this method. This class simplifies loading this type of data. Fast loading of nodes by filtering recordset data and flexibility to load any database using ADODB has been considered here.

Fill a FlexGrid without ADODC control and without AddItem of FlexGrid Method, with a fasted time about 230% more... with Recordset.GetString() and FlexGrid.Clip methods

This control will take care of you when you do database application, it serves as your recordset for your form, it will LOCK objects for you, do the BACKCOLORING of objects and Clear Values of objects. Just add the object to its control collection and bind data on it. The nice part of it is that you can save IMAGES to your database without calling or adding codes that will handle chunks. It can also search the database up to 3 columnar search, for more precise record retreiving. It has also a good error handles to avoid error when user encode a wrong value to the database. I hope you find this code useful and your vote would gladly appreciated. THANX.

This artical simplifies the usage of ADO objects . If you like me article, please vote for me!

This program uses Data environment to edit, add, delete recordset and it can also prints a specific recordset that you wanted.

This is Contract system project which I made to my company. The program uses ADO and have lot of functionalities. If you download this program you will learn the fallowing:(1) Know how to use ADO in real world business software.(2) How to use unbound text in database programming. (3) How to use crystal report (4) How to how to design a good lessee contract .There is a lot more to learn from this code... so download it and share your comment on what you have learn. Please don't forget to vote! MABUHAY ANG PINOY -michael

we have to save data in TABLE i wrote this utility to help beginers in vb for saving data without using the old way LIKE rs!st_no=val(me.text1.text)