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

To handle multi-users / concurrency of a MDB using eith DAO or ADO in the VB 6.0

Heres the update to my Address Book Example that pulls it information from an Access Database. I finally added the search and delete functions because I got tired of getting email from people asking me to write the update. :) Sorry it took so long but I've been busy opening up my office... Email any questions you have or comments to plexxonic@softhome.net

since i couldn't find any code that let me connect to an sql data source i got to work and wrote one i think it's real easy and it lets you connect to the sql server while still using a data control

This sample project will show you how to easily structure a query to a DataBase. The sample uses the NWND.MDB that ship by default with VB5 and 6 and demonstrates on a searchform how to search on a text from a textBox and use the different comparison operators like =,>,LIKE, etc. NOTE: This is for total newbies that have a hard time figuring this out. I myself had a hardtime in the doc to get an easy explanation on this. Cheers, and hope you enjoy.

This is just a demo for dBASE files. It will open any number of dBASE files and there is one function which can be used to get data from any of those .dbf files.

A simple project which can serve as a good example for use of crystal reports,DAO and dynamic control arrey.

This program converts any SQL Server table into a CSV text file.

Contains One Class clsCompareDB and a Demo project. Purpose: To compare two MS Access tables in different databases. The code alse demonstrates: ADO Technique to retrieve the Table names from an MS Access Database using the Connection Object OpenSchema Method. ADO Techniques for using a recordset to retrieve Column Name, DataType and Size. This class came as a result of MS Access being so easy to Change. Before I Joined Tier Technology training I was employed by the United States Navy (DP1). Our Managers decided that the MDB file should not be locked in any way. We were requested to train the users what they can do and what they shouldn't do. This gave no Guarantee though. We had several programs that required that several tables in different databases (IE MDB's for different years) be identical in every way. The procedures in question copied information of processed information by Column Index (Column position) or by using For Each (which also relied on the Column Position). Recently I needed this technique to do some debugging on an application I wrote for Tier Technology Training. So I dug this program up. Converted it to a Class and converted all DAO code to ADO code (Just to see if I could do this). Also this allowed this class to easily be converted for use with other databases (Other than MS Access). Author: Joel Isenstadt(iteachvb@aol.com). I am a Microsoft Certified Trainer for Visual Basic and am Currently Employed by Tier Technology Training (www.tiertraining.com)

Last code of mine was about quering tables and i used a little bit SQL In this small code i will try to explain SQLText string. How is it created and working? This series will continue under this name !Lets Create Database Applications-V?

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.

Browse to your database. This MDI program opens the database, seeks for tables and puts the fields into new documents. When double clicking a field from a table, the relation between other tables will be shown. Simple Code ..

This sample program is just used to show you how to load the entire Database into MSFlexGrid using ADO and SQL command.You can view and search all country Code by just a click.

With DYNDATA your are able to connect to a SQL-Server Database and edit the data in thier tables. DYNDATA builds dynamically the needed textfields and checkboxes. It uses ADO without databindingcontrols. You can select a database and table from a combobox and then connect to your given SQL-Server. All information about login, tables and databases are extracted from information_schema views and system tables. It is a tool I need for editing quickly data in tables without having additional tools. Thanks for voting

This code is an ADO modification to the previous post from Robert Row in December of 2000. This class adds AutoComplete functionality to a textbox. You start typing and the class searches for a record in an Access 2000 database that starts with the letters you typed, if it finds one, it completes the rest of the textbox with the record.

A simple example to add, update, delete and open Access2000 database.

Uses DTS (Data Transformation Services) from within VB

The program Creates a VB Class Module from a DTS Package on a SQL Server, with all events, and its own events(Progress, currentTask, etc) It creates a very compact script, so you can very large packages in a single routine. The Class Module "ClassDTSScript" is what is created when you get a package from the server and script it. Simply remove the example, and add one you have done to test it. The example execution asks you to navigate to the source and destination Access Databases, and uses the filepath to pass in an ADO style connection string for the source and destination connections. The parsing routine in the class module will work for SQL Server or ACCESS. I have not handled more complicated transformations such as Many to one column mappings and such, but Execute SQL and DATAPUMP Tasks work quite well. The Example "ClassDTSScript" module included was created from a package in SQL Server 7, and includes a couple of queries, two transformations, and running a stored procedure with a parameter, as well as demonstrating using the events that are called by the DTS Package object. Read the comments in the code carefully to better understand the uses.

I have used SQL queries for Add, Modify, Delete, Update and Search in the databases. Everything neatly coded and commented for each line. A very good example for beginners, who needs to know the coding standards for connecting to the database using ADO. Comments appreciated.

VB module to read and store ANY kind of picture file pictureboxes support into a database, it's easy and it's pretty fast... please, rate it, any comments are wellcome

Good database program to learn from. I suggest getting it. It was one of my first database programs, and this makes it easy and stuff. Has add, delete, edit and search feature. Also uses SysGarbage.ocx for system tray access. It is cool. Please rate.