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

This is a small collection of ADO Examples I made some time back. it was ment to be as a small tutor. but I never finsihed it. so I thought I may as well let you people have them. mostly for a Beginner, starts of by makeing a simple connection, to viewing, adding and editing data, and also some tools, such as Compact and Createing a new database and adding a new table. All examples are also commented, and are in seperate folder. Hope this may help some beginners out.

Hi this is a small tool I made to makeing Databases in VB with out a Access, you can add tables, fields, types, you can also add, edit and delete records this is only the first version so I hope you like it.

Hi this is a little VB Code Collector I made for my self to store all my codes, You can Add, Rename and Delete Categories, Add, Edit and Delete Code examples, You can also compact the database, New Update include a quick serach of cocdes and now codes can be stored in to sub Categories, hope you like the update

Hi, this is a small example of using DAO to view a database without access, it very basic and should be handy for a beginner shows how to get all the tables and load them into a Listview, anyway I hope you may find some use of the code.

This code allows for multiple record updates to be grouped into a single batch style transaction. You can then either committ changes to multiple records, or rollback the changes in the case of errors or conditions not being meet. This code is ideal for month-end processing, or in a situation where there is the possibility of errors being generated.

Improved code production, index/relation handling and now supports Queries. Database Coder analyses an Access Database and produces the code to create a blank copy of it. Supports Tables, Fields, Indexes, Relations and Queries. Interested in comments. Updated 26 May 2000: Improved handling of default field values and minor bug fix.

THIS CODE IS NOT THE SAME AS THE AUTO_COMPLETE FEATURES FOR VB5 LISTBOXES AND COMBOBOXES. This code is a class-module that enables VB6 DataCombo controls to function like MS Access combo-boxes. It adds an auto complete feature whereby when the user begins to type text in the combo it automatically searches through the list and completes the entry

if mdb_dsn_connection doesn't exist... then make it

To upload and retrieve ORACLE BLOB File using ADO Recordset. Never try with other than ORACLE database, but i think i can ...

To Provide a Recordset Template (view,execute,edit,Add new) To Provide a Database Connection Template (ORACLE and MS Access)

I have received a lot of responses to my code posted earlier ( a generic object that assisted in returning recordsets from Oracle). Most of these questions have been in the domain of the stored procedures themselves. Hopefully this article and example stored procedures will help clarify.

It allows the user to access Oracle Stored Procedures from VB, including getting ADO recordsets back

The Stream object introduced in ActiveX Data Objects (ADO) 2.5 can be used to greatly simplify the code that needs to be written to access and modify Binary Large Object (BLOB) data in a SQL Server Database. The previous versions of ADO [ 2.0, 2.1, and 2.1 SP2 ] required careful usage of the GetChunk and AppendChunk methods of the Field Object to read and write BLOB data in fixed-size chunks from and to a BLOB column. An alternative to this method now exists with the advent of ADO 2.5. This article includes code samples that demonstrate how the Stream object can be used to program the following common tasks: Save the data stored in a SQL Server Image column to a file on the hard disk. Move the contents of a .gif file to an Image column in a SQL Server table. ** Article ID: Q258038 - I take no credit for the code, I simply created a project from the example in the article **

with this procedure we can handle the queries or stored procedures which returns multiple recordsets - through ADO's

This function retrieves data from MSHFlex Grid and prints it directly to the printer. It determines whether the information should be printed landscape or portrait.

Code below demonstrates how to work with DataReport. You will need: 1. DataEnvironment 2. DataEnvironment Command that receives parameters. 3. DataReport with; a. Detail section named "Section1"; and, b. rptlabel named "lblCopy" 4. Form with a button. Code below should be put on click event.

Uses RDO to connect to 2 different (or the same) ODBC specified connections. Allows you to select tables on both sides and creates SQL statements to transfer the Data from the Source Table to the Target Table. Has the Option to Clear or Truncate the Target Table before Transfer. The 2 Tables must have the same amount of fields (of course).It automatically does the single quote thing for the fields that requires it. Easy to convert to ADO. Very nice , easy to use interface. The ODBC connection wil NOT work on NT , although minor changes can easily make this happen. Comments are very Welcome , even from critics.

This a Search program that searches for a 'specific record in a database. This is a kind of DISTINCT search. Where u just have to enter the first letter of the data u want and it gives u an output in the grid.

Allows the programmer to create an MS Access table in Visual Basic where the primary key’s field data type is set to AutoNumber. It is not like creating the primary key field in Access where you can select AutoNumber date type. In VB 5 and 6 you can’t request AutoNumber for a field type in the SQL Create Table string, it does not exist. So to create a table in VB where primary key’s numeric field type will be AutoNumber, you have to do it the way the included source code shows. Hope this helps.

Class that allows to create or edit connection strings using datalink of ADO. Suggestions and commentaries are welcome. Vote me!!