You can get my projects at Softpedia now, hehe

Softpedia Editorial Team informed me that they have included my projects in their sites. 

1) Analog Clock - A small desktop gadget that will display the current time (Downloads: 44)

2) SQL Management Console 0.1.1.29977 -Query pane and result pane (Downloads: 50)

Again, really thanks to them.

First release of SQL Management Console

Finally, I decided to release the second .NET application I am developing: SQL Management Console, now. This version 0.1, which is still in beta phase, still has a lot of room for improvement. Use at your own risk.

Here are some of the screenshots of it:
1) Login screen


2) Main GUI with MSSQL 2005 in action

3) Main GUI with MySQL 5.0 in action

4) Object scripting

5) Dependency viewer

For this version, it will suport MSSQL 2000 & 2005, MySQL 5.0. I am planning to include PostgreSQL connector in the next version. The features include in this version are :

1. (IDE-wise) Open/Save/Drag-and-Drop file
2. (IDE-wise) query pane and result pane
3. (MS SQL 2000 & 2005) Object browser for system objects (Scalar function, Stored procedure, System table, Table function, Trigger, User table, View)
4. (MS SQL 2000 & 2005) Object browser for security (Users, Roles, Schemas)
5. (MS SQL 2000 & 2005) Object browser for constraints, columns, parameters (Columns, Keys, Constraints, Triggers, Indexes, Parameters)
6. (MS SQL 2000 & 2005) Dependencies viewer for objects (Scalar function, Stored procedure, System table, Table function, Trigger, User table, View)
7. (MS SQL 2000 & 2005) Object scripting for non-encrypted objects (Scalar function, Stored procedure, Table function, Trigger, View)
8. (MySQL 5.0) Object browser for system objects (Scalar function, Stored procedure, System table, Trigger, User table, View)
9. (MySQL 5.0) Object browser for security (Users, Privilege)
10. (MySQL 5.0) Object browser for constraints, columns (Columns, Keys, Triggers)
11. (MySQL 5.0) Object scripting for non-encrypted objects (Scalar function, Stored procedure, Trigger, View)

Since parts of the source code is came from MSDN, thus I think it's good to release it under Microsoft Public license (Ms-PL) to prevent any infringement, though the chance are very little.

Since I am not an expert on database, feel free to give to any constructive comment and recommendation. I will try to improve it.

You can get the source code at here and executable files at here.

Little Update for C# Clock widget

Several months after posting the C# Clock widget on CodeProject, finally I managed to add some useful features into it. There are:

1) Customizable/Load and save user settings. User will be able to customize the application based on the feature they like, and it will load also on every start. In this case, the color of the hands and alarm message. (Part of the UI design refers from CodingForFun)



2) Localization, although it will no longer standalone (it will need satellite assemblies for localization). Currently it supports english and simplified chinese, other locales will fall back the english version though.

3) Alarm. User can enable the alarm so that this widget will notify the user on certain occasion.

4) Call the system clock. This is a context-menu to summon the system clock, maybe it's redundant, since user can by-pass it through the taskbar

You can get the source-code and installer here.

My first .Net app : C# Analog Clock

Finally, my first try on a simple .NET app is done. I created a analog clock widget using C#. I think it's quite challenging for a beginner because it will require simple background of Math, image processing, and 3D graphics programming.

With the mouse hit-test, anti-aliasing graphics and flicker-free double buffering, you couldn't even tell the difference between it and Sidebar gadget. Yet it is in C#, and it reduces the pain to deal with Win32 API directly.

To draw the hour-hand, minute-hand and second-hand needs a little trick.

1) Set the origin of form to center, from left-top (so that following rotation can be taken place)
2) Save the current state

3) Rotate the new graphics objects

4) Draw the second-hand (or any hands) at new origin, new orientation

5) Restore the saved state

6) Rotate the new graphics objects
7) Draw the minute-hand (or any hands left) at new origin, new orientation

8) Reload the identity / Reset the origin and orientation (Restore the saved state seems failed)
9) Rotate the new graphics objects

10) Draw the hour-hand (or any hands left) at new origin, new orientation

Voila!

You can get the source here or get the exe here!

#p/s: thanks for the Fasticon for its free icon provided.