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

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.

This code is a small example that shows you how you can run SELECT Queries on an external Excel File.

Demo for database access class automatically generated by CLASSter. Full source demonstrates calling stored procedures, executing parameterized SQLs, multiple recordsets, batch execution, transaction control, XML processing, error handling, etc.

This add-in brings up the Data Link Properties Dialog box. From there you pick the provider and the database along with other important information. You then have to option to test the connection. When you click the Ok button the connection string is placed on clipboard ready to be pasted into you code.

Address DataBase Shows VB and ADO

The JC Persistence framework is an abstract database layer that manage transactions in a transparent maner to the developer in any relational database, focused on Object oriented programming, mappings your objects with the database through an XML configuration file.

Give you an idea of how to store your friends information.Please rate me after downloading my work. Thank you! *version 1.1 is out

Give you an idea of how to store your friends information Better version than earlier. Download it now and try it. Please vote me. Thank you!! If any bug please report, thanks.

An alternative method of reading an MS Excel Spreadsheet.

A valuable tool in your programming toolkit. Use this routine for when an Access table goes bad. Often when this happens conventional INSERT or APPEND queries or cut/paste techniques don't work for backing up your table. This is a routine for copying data from one table to another table, field by field. As the information is processed, bad data fields are skipped over and logged in a log file. Only good data is deposited in the target table. **re-uploaded/Corrected II**

This VBA Automation demonstration assumes that Microsoft Excel 97 and Access 97 are installed. It hasn't been tested yet with Office 2000. My work required an Excel application that could generate charts based on information in Access. After searching PSC I came upon a great example by Joe Miquel which I've built upon. Once you've started the application all you will need to do is Click on the Excel Button on the Access Form. Feel free to expand and to innovate the code. Many thanks to PSC and to Joe Miguel for a great idea. Hope you like it.

Allows an interface to generic CSV files. It will allow you to load the file into memory, alter field values by defined name, the fields stored, rename fields in the header line,... with relative ease! HEAVILY commented -- good for learning from. This is was incorporated into an application that shared its information with perl scripts. This was updated on 12/3/02 for bug fixes (sorry if you already downloaded it).

This code shows how to use an array obtained from 'GetRows' and navigate through it as though you were using a pageable recordset

Updated: Dec 02 2001, Ver 2.5 updates are functionality to associate MS Access (.mdb) databases with Database viewer/editor, and to Maximaze the application. View/Edit data on databases that can be MS SQL-Server local/lan or remote on internet, or a MS Access database. Get Data by clicking databases/tables/columns/views/stored procedures or perform custom SQL queries. It shows ADO Programming and Some API. In this version I have fixed some bugs from previous releases and improved the functionality. Now you can view the "source" of all stored procedures and views in SQL-Server. Thanks to all who came with feedback/suggestions in previous versions of this application. The project is made with VB 6.0 Service Pack 5 and I used MDAC 2.5. Please help me grow as a programmer and come with feedback/suggestions.

This is an example on how to use ADO without ADO controls. I use the typical phonebook example... It is a complete application I use myself. You can store your friends, bussines associates name, adress, company, telephone, email, webpage, info, photo and more.... If there are several people using the same computer they could all have their own adress registers... you can create as many as you want and call them what ever you want. You can backup your database to any location you want. You can restore your backup. You can choose if you want to be in read only mode or in editable mode. When you are in editable mode you can Add a new post, edit a post or delete a post. You can send a email to current person or open his/her webpage. You can search for post using several search criterias such as: LastName, FirstName, Company, Adress, Telephone, Cellular, City, Country. The project is made with VB 6.0, Service Pack 5 and MDAC 2.5. If you dont have MDAC 2.5 you can get it at Microsoft webpage. Comments and constructive Feedbacks are always welcomed.

This is simple database program to demonstrate the use of ADO and OOP. The program includes functionality to navigate through the records, add, save, delete and find. All functionality are encapsulated in a class. The program contains very minimal error trapping, error handling and input validation. No data bound controls are used in this program. The program shows how to use ADO, Classes, Basic Module, Simulated inheritance and more. I intend to expand this further to include an error trapping and validation class. Other functionality will be included soon. In fact, this is a subset of a larger database program for a retail store.

This example will show you how to move items from datalist (which is connected to ADO control) to a listbox.

** PLEASE VOTE FOR MY CODE - EVEN IF YOU DON'T LIKE IT ** GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the DLL.

DataAccessDLL's SUCCESSOR - as a control. GREATLY simplifies accessing JET or SQL Server databases. No more Connection String, provider, data source, Persist Info etc. properties to fill in. Provides easy to follow instructions right inside the CTL with an 'INSTRUCTIONS' function.

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