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

**Niro Professional Address Book** This is my second use of database. This is an address book with password protection, ect... I've worked hard so please vote! Watch up the screen shot!

This is a quiz administration programme. It was created with the military in mind (Navy) so to login you use an official number and a password.There are two groups of users, the administrators and the students. An adminstrator would have access to the questions database (being able to modify it or add new questions), he can also set the conditions for taking the test like number of questions type of questions and duration of test. Only an administrator can register or modify or delete other users. He also has access to all test scores and can prune the database. The questions are stored according to subjects and could be in form of True/False, Multiple Choice or Short Answer type. Each question can be associated with a picture. A student can either take a test of check his scores. All users can change there password anytime. Even though the application was written to suit the military it can easily be modified. Please leave you comments and views, as I am sure I still have a great deal to learn. I have indeed learnt alot from this great site and most of this code can be traced to this site. I am really gratefull to all members of PSC.

Demonstrate the use VB/ ADO to connect to a mySQL server/database / table. Show the records in MSHFlegrid. You can also user sql statement to customize recordset

Whith this class you can load a lisview control with a recorset, and export the data to the TXT, CSV and HTML Format, you can use or not the progressbar.

The purpouse of this module is to backup and restore mysql databases within a Visual Basic program. Please, don't vote for this one... It is a remake of http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=57138&lngWId=1 which inspires me. It has some improvement on his code: Basically, it take the table creation statement directly from the MySQL engine (so now it publish constrains and indexes correctly) and perfom only on insertion statement per table no matter the number of rows in the table. Also, it prevent MySQL from generating errors because of the constraing and block the tables before the insertion process. Also, it could allows the programmers to give feedback to the user about the process and, last but not least, it is IMHO a bit cleaner.

This code will copy all fields from all tables in a database and add them to another identical database. My company has Rep submitting database reports all the time. I need to append the data from the reports database to a live database. At first I was running querys I had made in the database but our file structure changed and that was no long an option. This is about as simple as it gets but someone might find it useful.

Simple Database Application with find function.

This is Easy. Very Easy. 10 lines of code, 30 of comments. I'm sick to death of trying to find simple, concise code that tells me what I need to know. This is an example of how to access a SQL Database from VB, and how to use the data returned.

GoXML is a wrapper class for MSXML 2.0 / 2.6 / 3.0 / 4.0, offering access to some of the more basic elements in your xml documents. Use GoXML and easy-to-learn XPath to open, create, modify and save XML documents without a hassle. Don't worry about available MS XML Parser version, GoXML will autodetect it for you! The included code sample illustrates the use of all methods and properties. PLEASE VOTE OR COMMENT, THANKS!

This application will take any table from any database, and converts it into a HTML page, with nice looking tables. I have included a database with the entire 2000-2001 hockey season schedule as an example. The user can then view the schedule for any given date and convert it into a HTML page. Good idea if you're a hockey fan and want to update your page with the games scheduled for the day. Please remember to vote for me!

Haven't made a visual basic program for a long time. Made this for a place that I work. I haven't finished the program yet but couldn't wait to see any comments you make.

It explains the basics on Database managing with ADO using Datagrid.

Using this Program one can browse for Access Database through Network or local computer, pick a table you want to make an XML file from, and finally push a button to create a file in XML format. One can also display the newly created XML file and print it into Textbox with further "copy-and-paste". For database browsing I used an API call: GetOpenFileName Lib "comdlg32.dll" instead of bulky CommonDialog Control. For getting a tablenames of the database I used OpenSchema(adSchemaTables)for create Connection and then simply added tablenames into Combobox. Then I used File access VB feature to write an XML file from access table, reading column names and columns, converting it into XML format and writing on disk. The last feature this program has to print out a newly created XML file into Textbox for analysis and, if necessary, "copy-and-paste".

Use this class to create select, insert, update, delete sql queries. It automatically manages datatype and build data according. I generated this code in order to reduce my time in creation of queries.

An alternative method of reading an MS Excel Spreadsheet.

Basically I took the most common database commands and wrapped them into an Active X DLL. Step 1 – Compile the DLL Step 2 – Open and run the “Test” program Hope this helps some of you newbies

This is a prefabricated database browser to be used with bookmark- and clone-supporting SQL databases (MS-Access for example). It lets the user browse a database or search for specific entries and then select an entry for further processing. The appearance and contents are customizable. Everything above the blue line is part of the OCX Control. Simply stick it in a form, set a few properties and you're go with a commercial quality browser/record selector. A cross linked help file is included. Download is only 20.5 kB.

VBRSGen is a handy VB 6.0 Add-In that creates formatted ADO/DAO recordset and SQL code from Access database tables and queries. Generates variables, sets objects, etc. Also includes a simple "Where" clause creator tool and a results preview grid. Code is ready to paste from the Clipboard or Notepad. Some SQL statements aren't parsed properly, but these can be easily edited; this still saves a lot of time in repetitive ADO/DAO database coding. I'm making this available elsewhere as shareware for $20, but because the PSC community has provided so much invaluable support and helpful code, feel free to download the open source code here for your own personal use at no charge! This was originally posted in early April 2002 and received amazing feedback and dozens of "5-Globe" votes, until the PSC database had some problems. So please vote and leave feedback to let me know what you think!

2 functions to convert a 38 character GUID eg. {2E1EFAD8-4AD9-48A6-B9A9-75505F2B9A51} to a compact/compressed 16 character VB String eg. @#$%

I just put a bunch of controls on a form to play around with it and thought others might be interested in looking at it. Basically it allows you to conect to a mySQL database and ADD, EDIT, and DELETE records. You will need to create a table in mySQL called feedback with the following Fields. Field username Type varchar Size 50 Field emailaddress Type varchar size 50 Field subject Type varchar Size 50 Field message Type Text Requirements: This program requires that you have mySQL loaded somewhere you can connect to it. You must also have myODBC loaded on your machine. This program uses Windows ODBC 0to connect to your mySQL database. Written in VB6