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

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.

my english is bla bla so try to understand my words first i want to thank mr.opal coz of the code he put here about the same thing printing flexgride. i want to say to mr.opal great mind = great code but vb has a great tool called DataReport what u need to deal with this tool is imagine take ur mind a way. if u don't understand my words u will understand my code.

This code simply binds a ListView control to *ANY* kind of database you want(Access, MSSQL, MySQL etc...) It also includes auto column resizing that resizes column headers relative to their content.

I needed to query 2 password protected Access databases with a single SQL statement. The Microsoft web page http://support.microsoft.com/kb/113701 was helpful and gave me hope that it may be possible, but was not too clear. I use ADO with VB6 whereas the Microsoft example was for VB3 and the old ODBC. The Microsoft example worked almost straightaway for me if the databases had no password protection, it was the password protection that made it more difficult. Eventually after quite a bit of experimentation I cracked it and I thought I must share this with fellow coders in case they have the same requirement.

Graph designing is one of the most important feature of database programss. This code allows you to design graphs at runtime! It can also read from a database that you can open and display it graphically. It allows you to chose from a list of chart types including both 2d and 3d!,it allows to save graphs to bitmap files!, copy graph to clipboard,print the graph and lot's more.

For people who still use the DAO data control to acess MICROSOFT Access Databases , Here's what's been missing from the control , A way to access a database with a password

Using this code You can easily backup your sql database. There were some code here that used ADO for the backup purpose, here in my code i have used the SQLDMO object for all the sql transactions. Few code are taken from here and are upgraded with comments. Hope you all would like the work

A Library Management System using Microsoft SQL Server database in the backend. This project can also be implemented on Oracle by only changing the ADODB.ConnectionString property. Before working on the project you need to create the normalised tables, I've provided with the (DDL) SQL commands to adumbrate you with the structures for the tables used in the project. My Local Server name is BasuDip you'll need to modify this in the code. A screenshot of SQL Server Enterprise Manager is provided for reference. An updated code on Calculator is also included with the project. Hope you like it, your inspiration is solicited. Please vote and/or post your comments.

This tutorial will show you how to create a Visual Basic 6 project which will generate a report using Seagate Crystal Reports 8.5 Developer Edition. You will save the path of the image files in a MS Access database where it is protected by password. This project will use an external Crystal Report file and will be previewed using Crystal Viewer control.

Basically it is just a telephone numbers directory. You can search for people whose birthdays are fall inside a range of Date so that you could call/send SMS to them to wish them :-). Support Chinese name as other name. Use MS Access 2000 database with password protected. Auto compact database and update birthday when unloading the program. Auto resize MSFlexgrid column width when vertical scrollbar appeared. Use text file for simple program settings and write error log. Easy to use First, Previous, Next and Last records and string Find function. Easy to Add, Save, Edit/Update and Delete records using Hotkeys. Updated 12 October 2007: Leap year bug fixed and also show age in MSFlexgrid. Support empty birth date whether only Day or Month or Year is inserted or combination of 2 or 3 entries. Use Dateserial function to fix date problem. P/S: Searching birthday records stored inside a database is not easy. I hope this program could help someone who are looking for an idea to solve the problem.