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.

With Give Me a Password v. 1.0 you can create strong random passwords difficult to crack or guess, because of the combination of lower and upper case letters, numbers and special characters.

Give Me a Password v. 1.0 is written in C# and does not need install. However, to run the application, Microsoft .NET Framework 4 Client Profile must be installed.

Just download Give Me a Password v. 1.0, unzip it and run the executable. Select what characters should be included in the password(s) (i.e. lower/upper case letters, numbers, special characters), the length of the password(s) and the quantity of passwords to generate.

The code for Random Password Generation is based on the copyrighted sample code of Obviex™, which can be found here. Some alterations have been made to the initial code, in order to implement it with GUI and enhance the group of available characters.

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

If you find any bug or have any suggestion please contact me.

For more projects visit the Programming Section.

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 ;)

Now you can monitor and log the create, change, rename and delete events of files and folders in any directory, in a local or network hard drive!

With Directory Activity Monitor v. 0.1.0.0 you can set a directory and get notifications for any change happened in any file or folder. You can even keep history of the events and export it to a file. So, you will know exactly when a file or folder, was created, changed, renamed or deleted.

Directory Activity Monitor v. 0.1.0.0 is a software written in C# and works under Windows with Microsoft .NET Framework 4 (x86 and x64) and SQL Server Compact 3.5 SP2 installed. If you do not have them installed the installer will download them from Microsoft’s web site.

Some of the features of the current version are:

+ Set any directory to monitor (in a local or network drive)
+ Enable/Disable history of all the events
+ Export history to CSV or TXT format
+ Enable/Disable the monitoring of subdirectories
+ Enable/Disable the monitor of specific events (create, change, delete and rename)
+ Enable/Disable the balloon notificatiosn in System Tray
+ Select to start automaticaly with Windows
+ Check online for new versions

To install:
1. Download Directory Activity Monitor v. 0.1.0.0
2. Unzip it
3. Run the executable file

Note: This is a Beta version. If you find any bugs or have any suggestion, please do not hesitate to contact me.

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.

For more software check the Programming Section.

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.