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

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)

This a example for call one or more store procedures with different input parameters or without parameters.

This simple database will save all your books collection, it shows the use of ADO, DataReport and DataEnvironment, it shows how to Add, Save, Edit, Delete, View Reports. Other cool stuff it contains a toolbar and a file menu. It also shows the enable and disable functions.

Use this class to create select, insert, update, delete sql queries. It automatically manages datatype and build data according. I generated this code in order to reduce my time in creation of queries.

This is a good example to database connectivity....it's an example to match signatures ... in some institutions signatures of a person is scanned and verified by looking into the scanned image and the signature of that person...good example

This is a One Form One Ini solution to the frustration of writing repetitive VB/ADO/ASP Database code. I hope you will find this extremely useful for certain tasks, and a sound concept for improved coding and tailoring to individual requirements. As I can't live without it now - so I thought I would share it. (1) Opens any Access 97/2000 Database and Lists Tables, Fields, Types. (2) Type one line of code, program will replicate the line using the correct Fieldnames/Numbers/Types and Sizes - ASP programmers dream. (3) Create a choice of connection strings based on the Open database. (4) Create Sql INSERT, UPDATE & SELECT statments with actual field names. (5) Print your output code, or Double Click Ouputbox to send to clipboard. (6) Split Screen to adjust to preferred ListBox v Outputbox areas. (7) Most settings saved, return to where you were when restarting. (8) MRU File List, Auto-Open last database, Synchronized Clipboard etc. (9) Tool Tips explain most items, can be turned off when desired. (10) Reminder bar shows current User Keys, DblClick to turn off. (11) Disconnected Recordsets, freeing off DB during development. (12) All Translation 'Keys' are user definable. At the simplest level, Open a database and type in a template like - MyArray(##) = rs("$$") In the Ouputbox, ## and $$ get translated as FieldNumber and FieldName MyArr(0) = rs("ID") MyArr(1) = rs("qCode") MyArr(2) = rs("Title") MyArr(3) = rs("Lastname") MyArr(4) = rs("firstname") ........... ........... and so on to n fields

This source code was originally to predict lightning strikes. This source code is run in MATLAB and can be modified for different no of inputs. Meaning, this source code can be used for any kind of prediction!

PROBLEM: Creating a copy of a Recordset could mean using the Recordset.Clone method sometimes. However, this is not always appropriate because ADO’s Recordset.Clone method creates a Recordset which points to the same data as the original Recordset. This means that you really do not get a physically distinct copy of the original Recorsdet. Consequently, changes to the clone copy could modify the data in the original Recordset. An alternative solution would be to use a loop to append each record to a new recordset. This, however could end up being an unwieldy solution with potential performance penalties. SOLUTION: ADO 2.5 comes with a Stream object that can be used to create physically distinct copies of Recordsets. The article below demonstrates the use of the ADO 2.5 Stream object in copying Recordsets and the difference between the Recordsets created by the Recordset.Clone method and ADO 2.5 Stream object. Please see attached file.

Perform All Database Operation Using Object.

Sale, Purchase and Stock Management for Airline Tickets. This project is in prgress.