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

Use UDL files for your dataconnections instead of DSN.

Read from and write to a database on a web site via simple ASP pages from within a VB program, if you do not count DIM statements then this is all done with just 4 lines of VB code (+ 25 or so in the ASP scripts). Uses ADO & XML. REQUIREMENTS: CLIENT PC: MS Internet Explorer 5.0 /5.5 (IE4 will not do) ADO 2.5+ XML (3.0 preferred) SERVER: IIS4+ or PWS ADO 2.5+ XML 3.0

This project demonstrates a number of important ADO Data Base - VB methods and utilities. 1. Paramount of these utilites, from my perspective, is how to get the totals from a database field as well as how to multiply the items in two DB Fields and then create another field to show the answer. In addition a running total is kept, showing the Sum of the multiplied fields. This is a feature that any inventory data base requires. 2. Make an ADO Connection without using the ADO Data Control. When a program uses the ADO Data Control(s) it hard connects the data base to a given directory ("C:\My Documents\MyDataBase.mdb"), or worse yet the directory that the program is design / built in; (C:\Program Files\Microsoft Visual Studio\VB98\MyDataBaseProgram\etc"). This connection causes havoc when the product is installed to a client's computer. Of course a work around for this is to make a DSN Connection, but this requires the inclusion of numerous files in your setup/install program. When the connection is made through the use of code as opposed to using the ADO Data Control the Database file is located / installed in the program's deployed directory and is easily connected to. 3. Deploy and show all of the data using the MS DataGrid Control. Program shows how to fill and set the Data Grid. This demo allows adding and deleting of records directly on the Data Grid (Although this method is not recommended due to lack of ease, the better method is to use the programs Text Boxes). 4. Program sets up a TextBox and recordset movement procedure that emulates the familiar data control methods, i.e., The user can move through the records - movement is apparent in both the Data Grid and the Text Boxes, and the Current Record and Number of Records are continously displayed and updated when records are added or deleted. 5. Program makes use of the MS Report Designer in lieu of Crystal Reports. I have used Crystal Reports in the past and had numerous problems. I now use the MS Data Report exclusively. If you have any questions/problems with this demo it will be in this area. Study the DataEnviornment and DataReport Designers Structure

I wanted a way to send messages to the users who are in an access database. This code opens and reads the ldb file for the database (that you specify on the form), reads the user names and sends a message....all without API calls. You can do a lot more with this obviously (I trimmed it down a lot for this forum). You will need one text box for the source of the ldb file (named txtLocation), one command button, and one text box for your message (named txtMsg).

I work with Access databases, and occasionally will need to update the front end on the server. With access, you can tell when all users are out when the ldb file is missing. Therefore I created this app that checks for that ldb file. When the file is missing it uploads a specified file to the specified directory. This works excellent for me so that I can update files when all users are out. Hope this is helpful to you. Feel free to add/change or make suggestions.

This document explains how you can write Oracle stored procedures, that will return ADO recordsets to your VB or ASP application.

This code will allow you to populate a listbox control using an ADO recordset. I am using the standard VB ListBox Intrinsic control. Everything is done through code.

This is a Contact Data Base with to organize our personal contacts or company contacts. This code have other features like Login User and Password, add contacts, delete contacts, edit contacts, search contacts, Print contacts, send email to our contacts without a external email program, a calendar and a digital clock.

Generates Insert, Update, Delete and Select stored procedures for SQL databases

Class object that can be compiled or copied and pasted into your application that will dynamically create ODBC DSN's for you.

Class object that can be compiled or copied and pasted into your application that will dynamically create MS Access ODBC DSN's for you.

the engine i am providing is an asp code generator that i am currently using on my website (www.intratelligent.com) to allow asp developers to upload access databases online and build simple asp interfaces to interact with their data. (insert / update / delete and reporting functionality).

I had a datagrid which I needed to output/print, rather than go through the whole printing process I decided to try export it. This code takes values in a datagrid - populated from an access bound datacontrol, and exports the datagrid to a csv file for input into excel.

This sample program is just used to show you how to load the entire Database into a Tree View Control. (*This sample is complete DataEnvironment based.) The Recordset(the Command Object in the Data Environment Designer "Database") can be set by property pages in the designer. But here for the ease to use, I let you browse an Access MDB file. In fact, you can use any type of recordset(Excel, Access, DB, SQL, OBDC...).

This project demonstrates some code concepts such as use of classes, functions, passing variables, and registry control for setting SYSTEM DSN's under ODBC.

This is the code from a class module for exporting from any Jet database to any ISAM format out there. I think it neatly encapsulates the process, and uses properties and methods to make the process as easy as possible.

It allows you to import any .DBF file into an access database. You can choose the new table names, select individual fields, and create a new Access97 or 2000 database if one is not there already.

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.

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