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

When you display data from a database to a DataGrid, you will see that DataGrid's columns width cannot adjust to the longest data in the field. I made one procedure that can fix the problem. This procedure will adjust DataGrids column width based on longest field in underlying source. Enjoy!!!

Confused how to make a database programming using ADO Code? This project shows you how to make a complete ADO Code database programming with: navigation (move first, move next, move previous, move last), add, update, delete, cancel, refresh, find first, find next, filter, unfilter, sort (ascending-descending), bookmark, and adjust datagrid's column. This project uses reference "Microsoft ActiveX Data Objects 2.0 Library" and database Microsoft Access 97. I made this project by using "VB Application Wizard" in Visual Basic's Project Type Dialog Box and I choose "ADO Code" and "Master-Detail" through "Data Access From". Then I modified the code by adding find, filter, sort, and bookmark procedure - each of them in one form. The comments in the source code using Indonesia language (because I am an Indonesia ;) ). Sorry for this. May be I will translate them to English some other time. I hope you understand the code because the name of procedure using English language, for example: cmdAdd_Click, cmdUpdate_Click, cmdDelete_Click, etc. Enjoy the code! Any comments and votes would be appreciated.

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.

Store and extract MS Word Documents (or such other file) in binary mode into a DataBase.

This is a program that sort the grid control without sql.

Connecting to MySQL 4.0.2 using myODBC 3.5 & ADO 2.7 without creating DSN in ODBC DataSources in ControlPanel. In this sample is a code for adding records, showing records in listview removing selected records from list, searching records (you can search for records by name or by surname or both. Inside code is description what you must do before running code.

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

Document your Access database structures with ease.

myAnalyzer is a simple query analyzer that allows users to run SQL Statements to their mySQL database. This program does not use ADO but rather connects directly to mySQL through the DLL file included with mySQL (this through the help of some code borrowed from an individual mentioned inside the code). myAnalyzer also allows the user to save the sql query as well as print the query or it's results. The program has full search capabilities and can run multiple queries in one window or multiple queries through several databases in an MDI environment. I hope this benefits others out there as I wrote it to help me debug my SQL queries for my apps. You can connect to your mySQL server through a logon screen, or pass the information through to the exe from another application or command line.

Opens MSAccess 97 and 2000, works with databases with passwords. it allows the user to add, edit, delete modify RECORDS from any access database, also added defrag database function. Please Vote. :D

Internet Cafe System .. to calculate time and the cost for each PC in the cafe .. There is a DB to save user accounts and information about them

Easy way to create a backup job and schedule it into SQL Server. Pretty small and restricted but allows you to specify backup schedule such as Daily, Monthly etc. You can backup your database and restore it.

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.

It's not true you can't use Seek with ADO in Access.

This is the first wizard I made and uploaded to PSC. I never saw the one like this on this site. So I made it. This program/wizard will help you and save a lot of your time to build an ADO Code Project. You can build your ADO Code Project by entering and selecting data/tables/fields based on Database or DSN or parameter you entered/selected to connect to your database. Everything is available in this wizard, included if the .mdb file was password protected. This you can't find in VB Data Form Wizard. So you don't have to build your project from beginning by adding controls on your forms, write the code, adding the components and references, etc. The wizard will automatically add those to your new project. You can also add the find, filter, sort, and bookmark procedure/form to this new project. I made this wizard because I often make ADO Code Database project in my office, and this is really really save a lot of my time. You can learn how to make wizard from this program. I got the template of this wizard from Visual Basic, and I modified as I want to, and I added a Help file that you can call from the wizard. As a matter of fact, this wizard is rather similiar to VB Data Form Wizard in Visual Basic, but I had modified the wizard by adding a lot of enhancements. Please download and prove it now. Any comments, feedback, and votes would be truly appreciated.

Well.. for those who where happy about the previous version, heres a little update with scripting for Views, StoredProcs and missing tables. Works like a tierelier (Dutch ;-)). For those who don't know about the previous version, it compares 2 SQL-server databases. Also if somebody doesn't know how to implement a splitter, here's a idea how to do that :-).

This control will take care of you when you do database application, it serves as your recordset for your form, it will LOCK objects for you, do the BACKCOLORING of objects and Clear Values of objects. Just add the object to its control collection and bind data on it. The nice part of it is that you can save IMAGES to your database without calling or adding codes that will handle chunks. It can also search the database up to 3 columnar search, for more precise record retreiving. It has also a good error handles to avoid error when user encode a wrong value to the database. I hope you find this code useful and your vote would gladly appreciated. THANX.

***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.

This is a Password Program. does what the Windows 98/95 Password screen does. But the program cover's the whole screen. It shows how to use Database... And find the computer's Username...

I had problems using the datagrid attached to an ADOdc control. Here is what I found.