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

While searching for a way to repair a corrupted database file, that couldn't be fixed with just Repair and Compact, i found this undocumented option that prooved to repair and optimize my database file. Read the whole article. Any comments or feedback are welcomed.

ADO Helper 2.0 now includes example projects to demonstrate the working of ADO. This will help to directly use the codes in application. Example projects include: Demonstrates how to use Cross Tab, How to handle ADO Errors, ADO Find and Seek Methods, How to use ADO with Grid Controls, Use ADO with Data Report to create Simple Data Report, A complete ADO Unbound example to show, add, edit, save, delete with navigation with error handling, How to practically handle ADO transactions. These example programs will definitely help beginners and pros alike. With the passage of time, ADO Helper will become the complete source of ADO Help and Example programs at one place. Coming soon are topics such as: Data Consumers, Data Shaping, ADO MD to summarize data, Creating Data Sources, A complete payment management system using ADO and crystal report.

Allows you to automatically generate column headers and load all the records from a table or SQL statement into a listview.

These 9 lines of VBSCript code access the OLE DB Service Provider Type Library that is installed with ADO and will build a connection string to ANY database supported by OLE DB. Simply launch the VBScript file enclosed in the attached ZIP file, on the first tab select your Provider (Access, Oracle, SQL Server, etc), Click Next and enter your connection info (login, password, server name, etc), click Test Connection to test connection and when ready, click OK. When OK is clicked it will popup a VB InputBox that has your connection string as the default value in the text box. Simply copy the string and click Cancel to end the script. The original Artical is from the 11th Annual VBPJ Tech-Tips issue and can be found in its entitity at www.vbpj.com in its archives.

My Address Book(AnyAddress) allows you to add the persons name, email,Homepage ,Address, phone number and so many other fields. It also have good GUI. It is fully User friendly So u can easily use it. I have used Microsoft Access as Database Sql for searching the records.

MS Access developers will be amazed at this solution. Smart form requires zero programming on your part. What if you could intercept the MS Access sql statement before any database transaction occurred and record this statement in a journal, would this be valuable to you? Of course it would. What if you could replay the journal DML entries in the event a database crash occurred, would this be of value? If you haven’t solved the transaction problem you’ll love this article. Spread the word through the news groups.

Need to do any oracle/ADO work? I wrote these to help me along in my projects. I hope you find them useful too.

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.