Tuesday, 29 November 2011

Online Project Management tools.

Here is the list of online web tools that can help you to organize the project of software development:


  1. Assembla provides a free SVN or GIT storage. More than one user is available.
  2. Aceproject provides a free package of services for project management, bug tracker, etc. 5 users are available, 5 projects, 250 mg of space.
  3. Google docs provides free and almost unlimited services for online documents composing and sharing.
  4. Zoho provides some free services for project management and bug tracking (not free!). Not much is available for free. Has some nice primitive ToDo list.
  5. Applications Manager provides monitoring services for Servers - DB servers, web servers, FTP/mail/telnet/etc. services, cloud applications, etc. It's installed as a web application and free for less than 20 nodes. Can send alerts about servers down via e-mail/sms/twitter.

Friday, 25 November 2011

Programmatically configure the connection string of the Dataset.

Technologies used: Microsoft Visual Studio, c#.

The conditions are:
1) We have a MS Visual Studio project. The DataSet with tables drag'n'dropped on it. The tables were dropped from server explorer.
2) When dataset was initialized Settings.settings file was created. The DB Connection string is stored in it.
3) We need to change the value of the connection string programmatically when the application is run.
4) Main difficulty is that ConnectionString property of Settings class has no setter. Which means we can not set it - only manually from the settings designer.

The salvation solution is:
1) Create class in the Properties folder of the project. Name it for example Settings.Override.cs.
2) Class should extend Settings class. It is easy to do since Settings class is partial one. So the new class should be defined like following: partial class Settings (inside the Settings.Override.cs file)
3) Create a setter property in the new class:
        public string GgstatisticsConnectionString
        {
            set { this["ggstatisticsConnectionString"] = value; }//the name of the connection string in the Settings.
        }
4) In the beginning of the program (in some kind of initialization section) initialize the connections string:
Settings.Default.GgstatisticsConnectionString = "POLETIM-PC\POLETIMSERVER;Trusted_Connection=yes;database=statisticsdb; connection timeout=0";
5) Now the dataset will use the set connection string when it will be initialized.
??????????
6) PROFIT