Monthly Archives: June 2012

How To Read Articles On Financial Times For Free Saving £5.19 or $6.25 a week

13-06-2012 It usually costs £5.19 or $6.25 a week to get unlimited access to FT (Financial Times). You can open a free account which will allow you to access a certain number of articles a month. Or You can follow … Continue reading

Posted in Tips and Tricks | Tagged , , , , | Leave a comment

How To Exit or End a C Sharp (C#) Application

12-06-2012 To exit a c# program simply use following command: Environment.Exit(int Status); Status is the integer you return to tell the environment how your program concludes. If it executed according as expected or if it encountered any errors. The commonly … Continue reading

Posted in C#.Net | Tagged , , , , | Leave a comment

How to Suggest Values or Autocomplete Values When A User Types Into a Combo Box

08-06-2012 .Net has a 5 seconds super easy way to achieve this. Use ComboBox.AutoCompleteSource and ComboBox.AutoCompleteMode properties: (Available from .Net 2.0 onwards) Steps: Load all possible values to ComboBox.Items collection – this is the easiest source available. Select Properties of … Continue reading

Posted in C#.Net | Tagged , , | Leave a comment

Using Regular Expressions With Find And Replace In .Net IDE

06-06-2012 Use any regular expression to make your match. Then use {} pairs to define blocks of the search string you want to use in the Replaced string. Example: following find and replace strings will replace all occurrences ” report(number) … Continue reading

Posted in Microsoft .Net Framework | Tagged , , , , | Leave a comment

The Dashed Print Area Line in Excel

01-06-2012 Excel shows which content will be included in a page (when printed) with a dashed outline. If you can’t see this follow these steps (just one of them 🙂 ): Go to File Menu and Select Print You don’t … Continue reading

Posted in Microsoft Excel | Tagged , , | Leave a comment

How to get Table Information in SQL Server (Equivalent of Oracle’s desc)

01-06-2012 You can use following stored procedures to get table information similar to what you get by calling “Desc” in Oracle. Sp_columns ‘<TableName>’ This will show the list of columns along with other useful information such as: data type, length, … Continue reading

Posted in SQL Server | Tagged , , , | Leave a comment