Welcome
to OIG
Currently this project can be used as a tutorial for people wanting to start programming with Visual Studio 2005 and MySQL.
The source code is in Visual Basic.
It is for a "Base Database Editor" and can be downloaded here.
Requirements:
Software:
* Visual Studio 2005
* Download the nearly fabulous MySQL .NET connector (start here)
* Download the fabulous MySQLWorkbench (start here) (version used by OIG is 5.0.23)
Database Design:
* There is an example Database named "osrgbase" which is created, when you execute "\OSRGBase.sql" against mysql.
* You have to know several rules in order to design for this editor. They get obvious, if you read the source code.
Functionality:
* On Startup: Loads Key Tables (Tables, whose name starts with "KEY")
* On Startup: Loads ENUMS used in the database.
* On Startup: Loads base tables.
* On Startup: Loads foreign key reference Tables (Tables, whose name starts with "REF") to the base tables.
* Clicking on a Node in one of the tree views fills the respective ListView
* Double Clicking on an item in one of the List views lets you edit the database field.
* There is a TRICKY thing with "REF" tables: in the comment of the REF Table's primary key column is the name of the base table. The REF table is displayed along with this table's colums.
Help
* If you have any questions, feel free to ask them in the forum
Download
* Download the source
go to Project Site
This site is kindly hosted by:
