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

This code serves to connect to a data base DB2 in i5.

UPDATED - 11/10/04 This is a Contact Management System for all those who would like to track Contacts, Projects, Appointments, and much more. A few of the features are: 1)Contact Management, 2)Project Management, 3)Appointment views by Month, Week, or Day, 4)Notes & Calls management, 5)To Do item management, 6)Various database utilities - compact, repair, backup, restore 7)Popup To Do & Appointment reminders 8) Query Contact & Project user defined fields. View "ReadMe" for specific update features.

Listview1 will list all records from a given Data Source SQL qry. It sorts by Date, Number, text etc. It has a very nice find facility and a sql builder. Output data to CSV, XLS, Clipboard, HTML, PDF, Screen. (ActiveReports 2.0Pro) is needed

On browsing the forum and the net, I see a lot of questions relating to data integrity in a VB form. It's an issue I come up against a lot myself - so here, I have attempted to address some of the issues raised and provide a possible solution. The form is designed around the DAO data reference. It is an attempt to make a bullet proof data form in that . . If the user changes the value in a field and then tries to move to another record, or add a new record, or close the form or whatever . . then the form will pick up the changes and ask if the user wants to save.

This code is design to keep track of companies resources like employee, guesthouse, vehicle hire, canteen management, salary slip geneation and many more

This Program explains how to connect ORACLE with VB. How you retrieve table, view and stored procedure of ORACLE. Also featuring subclasssing a Textbox and customizing Progress Bar. If I make any mistake please send me the right one.

This Program explains how you connect ORACLE with VB. How you retrieve table, view and stored procedure of ORACLE and Table Description. please Check Out subclasssing a Textbox and customizing Progress Bar. If I make any mistake please send me the right one. Check Each and every code.

Hi, This project gives you an idea how to access ORACLE through VB and ADO. Project describe How you interacting with ORACLE Table, view, Stored Procedure, Type, Package, Package Body, Synonyms, Sequence etc. I developed an Active X Skin which is used throughout the project. If you want to test the Skin just put the controls (OFrmCtl, Edge Right, Edge Bottom, Edge Region) in a form and run the project. Please close the project from FORM CLOSE Button, otherwise IDE will be crashed. Please check all the menus and form. Now, I’m trying to develop this project in Visual Basic.NET. Resize the form From X Axis and Y axis. Check it out. Using of My developed Active X Skin and other components are strongly prohibited.

This example shows a way to manage persistence with classes in VB using a 3 Tier framework with XML for inter layer communication.

Here is a list of this control futures: 1. Login in to MS SQL Server 2. Backup, repair and restore databases 3. Upload databases and delete databases 4. Control the server (Start, Stop, Pause and Continue) 5. Check Server Status (Started, Stoped or Paused) 5. Check connection if active to server or not 6. List databases in the MS SQL Server, list teables and fields in table 7. Open connection with database and SQL statments (like select) 8. Save any file to Binary Field in table (like upload picture to table) 9. Display picture saved in database field to object (like Picture control) 10. Save a file from database field (like picture or txt files) to harddisk 11. Check if EOF or BOF 12. Find any record easy 13. Add, Edit, Update and Delete records 14. Bind the database fields to VB Objects (like Text Box or Label) 15. Bind the database table to MSFLEXGRID32 control 16. Handle All errors easy (no visible run time or desgin time errors), all hadled by name & num. Its the easiest, coolest code ever seen! You can learn even how to upload and download files from MS SQL Server! Its learning control and can be used for your projects as well! I hope you like it, if yes, please rate it, thx anyway! :)

This is designed as a wrapper to the MySQL API, it is a windows dll and just needs compiling and registering before adding a reference to your projects, it provides a means of accessing a MySQL database as you would using ADO. This is the second and final version and has been compiled and tested with both VB6 and VB.NET and works very well with both. Please give feedback on this as it will help me to improve on it. Also please feel free to suggest anything that you would like to see in future version of this dll.

Hello guys!!! This submission is a complete OLE DB Provider Guide. Many beginner database programmers out there don't know how to connect there application in defferent database, in lan and even in a remote. This guide will help you a lot coz it gives all example on how to connect to a database using OLE DB Provider. Pls. Pls. Pls. Don't forget to vote this appliction.

I created this for work to maintain a list of databases that we have for different product lines. It uses the Access 10 Object Library to perform this functionality "behind the scenes", so to speak. By doing it this way, you should notice a vast performance increase. NOTE: If you do not have Access 2002, this will not work for you unless you have msacc.olb registered on your system, but there are other options that work in much the same way.

[ADODC IS E V I L!] Have you reached a stage when you realize that the standard ADO Data Control Shipped with VB is not enough for you?? Ever Wondered How You Can Connect To A Database with code? How You Can Read, Write, Delete, Change data in Tables ? Well, Here's a small Application which uses ADO Code to manipulate data in a table. I've also included code to Enable or Disable the Command Buttons in the Window based on the context (For exampling disabling First & Previous buttons when you are in the first record...).

IT IS USEFUL FOR SMALL COMPANY, & ALSO CALCULATE THE EMI, PF..

This is a Registration System, it has two application, the client and server. It uses ADO connection and Winsock. You can add, edit, delete, view a record. The server is password protected. I also included a chat. Other stuff are Minimize in System Tray, Compress Database, Install on Startup, also every action made by Client is log in the Server. The Help file is included. Please vote first before downloading this code. Thanks to Chris Hatton for the Ado.

I share this program for others (specially newbies) to have idea on how making software. In this submission you will learn how to connect in MS Access Database using ADO and ODBC, Update/Save/Delete/Search record, open an excel file, computation, formatting, etc. just download it and have fun. Pls. vote and let me know your opinion. I highly appreciate your feedback. Thanks! :D

It allows the end users to encode the necessary transactions for the products delivered by the supplier and the products delivered to the customer. it has necessary maintenance for the customer, products, suppliers and users for record keeping (with add, edit, delete, save, find and cancel button).Counts the remaining item and prompt messages when in reaches the critical level of specific product. It has report sample as well using data report.The username is rowena and the password is weng. you can also check the it in my security table in ms access. hope you like it! DONT FORGET TO VOTE FOR ME TNX!

This sample code is an example of how to put text and graphics into a richtext box on a form and then save that information into a database. The example uses MS Access, but should work with SQL Server as well. I needed this for a specific purpose and when I could not find any examples, I created my own solution. Use this however you like there are no copyrights on the code.

This class makes VB Database Applications easy to write on the fly! This class includes over 30 functions for ADODB programming in VB! It encapsulates all the Find Functions, Move Functions, along with AddNew, Delete, Update functions and a ton of error trapping for easy use! Also includes events to program at your disposal! Please leave comments/feedback and vote if you'd like. This is my first class file I have been working on.