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

This code demonstrates how to access a POSTGRES SQL database on a LINUX box via an ODBC connection. The demo ( using RDO ) shows you how to create a table, wipe a table, insert data, select data, modify data and write the modified contents back to the database.

A simple project which can serve as a good example for use of crystal reports,DAO and dynamic control arrey.

Contains One Class clsCompareDB and a Demo project. Purpose: To compare two MS Access tables in different databases. The code alse demonstrates: ADO Technique to retrieve the Table names from an MS Access Database using the Connection Object OpenSchema Method. ADO Techniques for using a recordset to retrieve Column Name, DataType and Size. This class came as a result of MS Access being so easy to Change. Before I Joined Tier Technology training I was employed by the United States Navy (DP1). Our Managers decided that the MDB file should not be locked in any way. We were requested to train the users what they can do and what they shouldn't do. This gave no Guarantee though. We had several programs that required that several tables in different databases (IE MDB's for different years) be identical in every way. The procedures in question copied information of processed information by Column Index (Column position) or by using For Each (which also relied on the Column Position). Recently I needed this technique to do some debugging on an application I wrote for Tier Technology Training. So I dug this program up. Converted it to a Class and converted all DAO code to ADO code (Just to see if I could do this). Also this allowed this class to easily be converted for use with other databases (Other than MS Access). Author: Joel Isenstadt(iteachvb@aol.com). I am a Microsoft Certified Trainer for Visual Basic and am Currently Employed by Tier Technology Training (www.tiertraining.com)

Last code of mine was about quering tables and i used a little bit SQL In this small code i will try to explain SQLText string. How is it created and working? This series will continue under this name !Lets Create Database Applications-V?

Second code for managing database series. Querying with SQL and basic dictionary application. Enjoy it.

For beginner database programmers.

This code will save and retrieve bitmap graphic files from an OLE Object field inan Access 97 database. The same principle applies to earlier versions of Access/VB, but I haven't tested them. You'll need to use the appropriate DAO library. Let me know if you find a way to save other graphic formats.

This sample project will show you how to easily structure a query to a DataBase. The sample uses the NWND.MDB that ship by default with VB5 and 6 and demonstrates on a searchform how to search on a text from a textBox and use the different comparison operators like =,>,LIKE, etc. NOTE: This is for total newbies that have a hard time figuring this out. I myself had a hardtime in the doc to get an easy explanation on this. Cheers, and hope you enjoy.

since i couldn't find any code that let me connect to an sql data source i got to work and wrote one i think it's real easy and it lets you connect to the sql server while still using a data control

This program converts any SQL Server table into a CSV text file.

Imports ASCII text databases in any format, to Microsoft Access format. Very nice GUI. You will need to find a "Replace" function from Planet Source Code and paste it in... only if you are using VB4 or VB5.

This code is an update of my previous submission. I put in code to convert database info to a comma delimited file, and to fill a listbox with data. I'm still working on it to do more things (SQL searches, etc.), and I'm going to do images,and things like that. I'm also going to improve the conversion to HTML to make it even better. Have fun with it!

Digital Statistics Calculator saves all entered data to a DAO database and can send it to Excel for graphing. The lab where I work wanted this to avoid doing double data entry.

Complete wholesale product inventory database program. Combines Access, DAO, and Excel to manage inventory, write reports, and print forms. I wrote this for work so you might as well have the code.

A viewer and editor of a database with 10,000 computer acronyms.

Have you ever try so send a SQL String to a database that has apostrophes ? If YES you will get a run time ERROR Here is your solution....A function that formats the variable before sending it to the database

Update: ver 47 - DbaMgr provides a graphic management interface for MS Msde 1.0 installations. It allows you to manage and administer your server, databases and database objects from a Windows interface similar to the one Enterprise Manager provides, rather than via the standard oSql.exe command line utility: an alternative inexpensive console/management tool for Microsoft Sql Server 7.0/Msde 1.0. In addition to traditional Sql Server objects management and permissions, DbaMgr adds HTML documentation generation tool, attach/detach visual interface, a query interface, and a visual interface for BCP operation. Provided with built-in English and Italian language localization, supports user defined language translation. It needs ADO 2.5 installed, as long as SqlServer Client Components (Sql-DMO). SqlServer 2000/Msde2000 version available too

DbaMgr2k provides a graphic management interface for MS Msde 2000 installations. It allows you to manage and administer your server, databases and database objects from a Windows interface similar to the one Enterprise Manager provides, rather than via the standard oSql.exe command line utility: an alternative inexpensive console/management tool for Microsoft Sql Server 2000/Msde 2000. In addition to traditional Sql Server objects management and permissions, DbaMgr2k adds HTML documentation generation tool, attach/detach visual interface, a query interface, and a visual interface for BCP operation, extended objects properties support. Provided with built-in English and Italian language localization, supports user defined language translation. It needs ADO 2.6 installed, as long as SqlServer 2000 Client Components (Sql-DMO). SqlServer 7.0/Msde1.0 version available too

This code can literally do anything you wish with an INI file. Here are a list of the 21 INI functions that I created. These took me a long time to make, so please let me know what you think. A program is included that explains everything completely...from how to use the functions...to an explanation of each variable. GetKeyVal(), AddToINI(), DeleteSection(), DeleteKey(), DeleteKeyValue(), TotalSections(), TotalKeys(), NumKeys()-"To count how many keys in 1 section"-RenameSection(), RenameKey(), GetKey(), GetKey2(), GetSection(), IsKey(), IsSection(), KeyExists(), KeyExists2(), SectionExists(), GetSectionIndex(), GetKeyIndex(), GetKeyIndex2().

I saw the earier example of a global error handler written in C#, but needed it written in VB for my company. I translated the earlier work into my version in VB. It was suggested by a couple of people that I provide my VB version, so here it is. I just hope you find it useful. You can visit the C# version at: http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=948&lngWId=10 It was submitted by Joel Thoms on 2/5/2003. Thanks to all that asked me to post the VB version. Special thanks to Charles Richardson for helping me track down a bug. When you paste the code into the IDE, most of the formatting should return.