Results for "Category: Databases/ Data Access/ DAO/ ADO"
Store name and address information with associated call logging. I use it to track calls to job agencies while I'm looking for contracts.
3-TIER Test project illustrating high performance Data Access for SQL Server using ADO command objects and Stored Procedures in a 3-TIER ENVIRONMENT USING VB CLASSES for Insert, Update, Delete and Select. This project runs on Northwind db.
This VB test project demonstrates how to insert, delete, update and select from a Microsoft Access database using parameterized stored queries and ADO command objects. .mdb file in included.
***UPDATED 02/19/2003*** This is a quick and simple documentor for SQL Server. It returns a list of registered Servers in your EM. You choose the one to connect to, then you choose the database - once connected it will return a list of Databases - then you choose what you want to document and how you want it returned in an Excel Spreadsheet. It's well documented code so you should be able to make changes without much pokin around.
UPDATED - 12/07/01!!! This kind of goes against my article earlier this this week. In a new environment I was able to do two things. I was able to query a list of DTS Packages from my Server and then execute a chosen Package remotely. This can be easily modified to accept collections and remotely fire multiple Packages on a timer (which is what I'm using it for). If you downloaded the zip file earlier you may want to download it again since I've updated it and revised some of the references. NOTE: If you use a DSN connection it must be pointed at the MSDB database to get the list of DTS Packages, not the Database you are trying to run the DTS Packages Against.
Have you ever wondered how to remotely fire a DTS Package in SQL Server 7 from a Visual Basic Application? Me too... So through rigorous research and aggrevation I figured out a very simple way to do this.
visual user interface to construct a query
This will read the table form an access database and then creat the textboxs on a form with the field names mapped to the textbox names. It will then create the code to save what is in the text boxs back to the data base
Print a crystal report in a certain date range
This code is used to search for clients in an access 2000 database using ADO and a parameter query. In our database we have roughly 20000 records to search and it still finds them very quickly.
Complete application. Customers Database, inventory system, search databse records, cool gui, Debtors alert, password protected. This application is suitable for a car shop. Whenever the mechanic finish a job on a car the only thing he has to do is to use the service wizard and select the parts he used from a list and the number of the parts. The application substract the number of parts used from the inventory and gives the subtotal and total price. (The login password is set to nothing for the moment so if you want to access the application just click the login button)
Simple Database Application with find function.
Allows you to simply type what you want into a cell of a Flexgrid control, resembles Excel. You can also enter values in the text boxes to chenge the number of columns or rows quickly
Create an MS Access Style Combo or ADO DataCombo using a class and a single property
This is Easy. Very Easy. 10 lines of code, 30 of comments. I'm sick to death of trying to find simple, concise code that tells me what I need to know. This is an example of how to access a SQL Database from VB, and how to use the data returned.
This program will allow you to physically map fields between two Access databases and then transfer the data (overwrite or append). You physically map it by clicking on an item in a list and then drag a 'Connector' object (just a bunch of lines thrown together in a class) to a field in another list. This code has been tested minimally. Please let me know if you find any errors. I will fix them. Thanks for your vote. All constructive criticism welcome! This is my first submission so help me out.
This is an improvement on my previous Access Field Mapper. This program allows you to open two Access databases and Map fields between two different tables (performs AutoMapping as well). After you've finished mapping the fields you can transfer the data with one click. This version will do type compatibility checking and if you transfer data that is not directly compatible it will coerce it for you.
A simple example to add, update, delete and open Access2000 database.
Creates ADO Access 2000 Database
This code demonstrate how to connect to database (Patients97) using ADO code alone. I also demonstrate using the MonthView control and MSHFlexgrid control. The database called Patients97 contains customer details like name , address, customer number etc and appointment date and time. On the form, I have an MSHFlexgrid control, a MonthView control and a command button(cmdViewAppt). Clicking the command button connects to the database using ADO code and the details are displayed on the MSHFlexgrid control. You can display appointments for a particular date by clicking on a date on the MonthView control (MonthView1_DateClick event) and the result is displayed on the MSHFlexgrid control. I have not figured out how to create a report yet. What I'll like to do is to be able to pull the information on the MSHFlexgrid control and display it as a report which can be viewed and printed.Preferably I'll like to use the data report designer but I won't mind using excel or word or is there a way to use DataEnvironment designer? Please e-mail me any improvements or additions at supo@orimogun.freeserve.co.uk.