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

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.

A small script mixes ASP and Javasript to make messages alert or for the debugage.

This is an Home Inventory program that uses the cuecat that was given out by Radio Shack. It also show ADO connections Data Reports. You can keep track of your movies, what you have and who borrowed them as well if you sold any. You can scan or key in the UPC from movies as well as groceries. This still needs a little work, but I am on the right track.

It can parser simple XML like file and read/write data in it. Gives simple access like any Database.

This program retrieve the tables and column existing from DSN ODBC. To do, use the OpenSchema method frmo ADO.

Complete Library Management Software fully commented,No dirty coding. Very useful for beginners!!!!!! Please vote

This code makes easy the creation of databases and tables in a MySQL Server.

Create Shape Statement For Master/Detail Form In Visual Basic.I Made This "Generator" Because I Couldn't Remember The SHAPE Statement And Now I Publish It For All Developers Who Cannot Remember It And It Is A Good Example Of ADOX And ADO.The New Version Is With Full Test Of SHAPE Statement.

This code is an ADO modification to the previous post from Robert Row in December of 2000. This class adds AutoComplete functionality to a textbox. You start typing and the class searches for a record in an Access 2000 database that starts with the letters you typed, if it finds one, it completes the rest of the textbox with the record.

Geo Sun Times allows you to get your sunrise and sunset times each day by using your zip code to look up your geographical location in a database. The database file its self is to large to post here at PSC so you can download it from my website here: http://www.tas-independent-programming.com/cgi-bin/download.pl?file=zipcodes-csv-10-Aug-2004.zip This is an extended front end to compliment ahmed elsheshtawy's submission at http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=65314&lngWId=1 .

Exaple of using MS-Chart control and ADO database. Load data (by projet id, by dates) into 2 dim array and graph it. Ability to Save/Print/Copy graph .

This article shows you how to put a checkbox in a dbgrid. If the column is of boolean type, then a checkbox will appear. Great Look and very easy;

ics1 is a inventory control system. this my first project in vb.

- how to use the ADD-In manager (Read Readme.txt) - How to Use ADO Command,Connection and Recordset Objects - How to Load Data from a Database to a Combobox - Using ADO Recordset Find - Properly Close a connection - Set A DBGrids Datasource on Run-Time - How to trap when user clicks the x button of tour Form - Record Navigation with Error Trapping - Using OLEDB Basic - Use With Command to save Time - Use ADO via Referencing or Without Control - DSN Less Database Connection -approximately 1440 twips to a logical inch or 567 twips to a logical centimeter (correction on my Comment :))

This Sample create's a Datareport by filtering a Database. It is quit useful for small Reports. (Sorry this is the Englisch Version!)

Treeview Database sorry it is in German and my first Submission. If you like it I will put it up again in English.

This article shows how to store and retrieve images from a database in a fairly simple way.

You can connect three databases at one point of time through this application i.e. SQL Server, MySQL and Ms Access. Simultaneously, you can get the references of all tables and connect with DSN too. Adding to this, there is one big utility that changes unformatted SQL queries in two formats [For VB Formatting and For SQL Formatting]. Much more trendy feature that are unanimously claimed by anyone and don’t forget to vote for me.

Allows you to programmatically create an ODBC connection to a MySQL database using the Registry API.

ActiveX Data Object Easy Data Control Ocx V1.0.3 is a more Graphical and Easy ADO designed for Total Beginners,but it also can be used by anyone,Forget Newbies Database errors,and hard to understand code,this New Ado works like the Regular Ado but is more easy to use if you don't have any Databases experience..This Ado uses a Smart Property Page that lets you select from your *.MDB *.XLS *.TXT Databases and All this More Quickly..Now you can use Tables in Text Files,and of course Excel and Access Databases.. This Proyect includes a Tutorial for a more easy undestanding... I used NWIND.MDB For Access Examples so check your NWIND location I used: C:\Program Files\Microsoft Visual Studio\VB98 enjoy!!!!! PLEASE REMEMBER TO VOTE!!!!! Updated a Free OCX..only compiled code!! but still more to come (this is yust part of the actual ADOEDC PRO OCX)this free version can have some bugs and some features are not ready.. but is still a great utility for Visual Basic Programers. The ADOEDC Control is an important developer tool in Visual Basic and it's worth getting a closer look at it here. -------------------------------------------------- http://geocities.com/marioflores_code -------------------------------------------------- or download zip from: http://geocities.com/marioflores_code/adoedc.zip ;)