flink.gr

Working around lately with MySQL and C# I created a small and quite simple application that visualizes MySQL Commands to a DataGrid.

With SQL Statement Monitor v. 0.0.0.1 you can connect to a MySQL Database, execute MySQL commands and see the result straight on the DataGrid. For example, when you can execute a “Select” command and only the selected columns will be visible in the DataGrid. Similarly, you can add Tables, Entries, Columns etc.

In this Beta version of SQL Statement Monitor v. 0.0.0.1 are two buttons. One “Select” and one “Execute”. The “Select” button is used to filter the data (i.e. the Select example above). While the “Execute” button is used when an alteration to the Database is required (i.e. add an entry).
In addition, the code of some basic SQL Commands is included. Just select the command from the “Common SQL Commands” drop down menu and the code will be inserted for you in the commands field.

In order to use SQL Statement Monitor v. 0.0.0.1 MySQL Community Server is required. Personally, I suggest you to download MySQL Workbench (GUI Tool) too, so that you can manage your databases easily from a GUI. Both of these tools can be downloaded for free from MySQL official website.

How to use:
1. Download SQL Statement Monitor v. 0.0.0.1, unzip it and run the executable
2. Download MySQL Community Server and install it
3. Download MySQL Workbench and install it
4. Create a Database (write down the Username, Password and Hostname)
5. Start SQL Statement Monitor v. 0.0.0.1 (some errors may pop up that it cannot connect to Database)
6. Click ‘Connect to Database’ and give the correct information (Database name, Username, Password, Hostname and Table Name)
7. If the database has no tables yet an error will pop up. You should create a table
8. You are ready! Add some data and play around with SQL commands

If you have any question/suggestion please comment below.

If you need a copy of the source code do not hesitate to contact me.

A new version (still in Beta) of the Personal Documents Organiser for Windows in C#, Documents Order Obsession v. 0.2.0.0 is here.

The updated version brings many new features with a new interface, that will help you to organise your documents (and your files in general) better.
Some of them are:

+ Documents Order Obsession v. 0.2.0.0 has a proper installer now
+ New re-ordered main menu
+ Icon menu for easier access to frequent actions (i.e. creation and edit of Entries)
+ Export your entries to CSV file (open it in Excel)
+ Open the associated file directly from Documents Order Obsession v. 0.2.0.0
+ Star your “favorite” entries
+ Filter to view only your Starred entries
+ Completed tasks now are indicated with icons
+ Check online for new versions

Other features include:

+ Create up to six categories, filter them and color them to find easier what you are looking for
+ Show/Hide completed tasks
+ Keep History of your changes
+ Import/Export the entries from/to a XML file

Documents Order Obsession v. 0.2.0.0 is written in C# and requires Microsoft .NET Framework 4 (x86 and x64), SQL Server Compact 3.5 SP2 and Windows Installer 3.1.
If you do not have them installed do not worry. The installer will download all the prerequisites from Microsoft.

To install:
1. Download Documents Order Obsession v. 0.2.0.0
2. Unzip it
3. Run the executable

Note 1: If you get an error that cannot connect to database you should run the program as Administrator (Shift + Right click > Run as Administrator)

Note 2: This is a Beta version. If you find any bugs or have any suggestions please contact me.

If you need a copy of the source code please contact me.

Feel free to comment ;)

New version available: Download Documents Order Obsession v. 0.2.0.0

Lately I have started to work on some projects on C# and I am really excited about the way that C# applications communicate with Windows.

Documents Order Obsession v. 0.1.0.0 is an application that will help you to organise your documents and put them in order. However, it can be used to track and organise any kind of information as the given categories can be configured from the user.

Some of its features are:

+ Create up to six categories to add your document entries
+ Color each category to be easier to distinct entries belonging to a specific category
+ Show/Hide completed tasks
+ Filter categories
+ Keep History of creating, editing and deleting entries (History can be disabled)
+ Import/Export the entries from/to a XML file
+ View Statistics

Documents Order Obsession v. 0.1.0.0 is written in C# and requires Microsoft .NET Framework 4 (x86 and x64), SQL Server Compact 3.5 SP2 and Windows Installer 3.1 to be installed. If you do not have them installed do not worry. The installer will download all the prerequisites from Microsoft.

To install:
1. Download Documents Order Obsession v. 0.1.0.0
2. Unzip it
3. Run the setup.exe.

Note: This is a Beta version. If you find any bugs or have any suggestions, use the Feedback form under the Help menu or comment in the post.

If you have any question about parts of the code you can comment below.

If you need a copy of the source code please contact me.