Menol

How to Get the Underlying DataRow of a DataGridViewRow

23-07-2012 How to get the underlying data row of the bound data table linked to a DataGridViewRow in a DataGridView? How to get the underlying DataRow of a DataGridView.Row? How to get the underlying DataRow matching to a Selected Row of a DataGridView? How to map the DataGridView row to the datasource? How to getContinue reading “How to Get the Underlying DataRow of a DataGridViewRow”

Use of Nullable ?? Operator in C#

20-07-2012 Use ?? operator to tell the compiler how to assign a null-able variable to a non-null-able variable. Menol ILT

Change the Firefox Address Bar Search Engine

17-07-2012 1. Type about:config in your address bar 2. Search and locate the key called “keyword.url” 3. Double click on the key and update the search URL to match the search engine you desire. Following are the URLs for common search engines: Google: http://www.google.com/search?&q= Yahoo: http://search.yahoo.com/search?p= Ask: http://www.ask.com/web?q= Bing: http://www.bing.com/search?ie=UTF-8&oe=UTF-8&sourceid=navclient&gfns=1&q= DuckDuckGo: http://duckduckgo.com/?q= Menol ILT

Using Short-Circuit Condition Evaluation in VB using AndAlso and OrElse

02-07-2012 Normally, a programming language stops evaluating a composite condition when it finds one of following scenarios. (Condition 1) AND (Condition 2) Since the above composite condition to evaluate to true, both condition 1 and condition 2 have to evaluate to TRUE. If the condition 1 evaluates to FALSE then it is obvious that theContinue reading “Using Short-Circuit Condition Evaluation in VB using AndAlso and OrElse”

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 below steps 🙂 What you need to do is : Search of Brows through FTContinue reading “How To Read Articles On Financial Times For Free Saving £5.19 or $6.25 a week”

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 used success value is zero 0 This will mean that your program termintaes without anyContinue reading “How To Exit or End a C Sharp (C#) Application”

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 the ComboBox and select ComboBox1.AutoCompleteSource to “List Items” Select ComboBox.AutoCompleteMode to anything other than “none”Continue reading “How to Suggest Values or Autocomplete Values When A User Types Into a Combo Box”

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) ” to ” // report – number ” in the following sample code. Sample CodeContinue reading “Using Regular Expressions With Find And Replace In .Net IDE”

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 have to do a print or anything just go to this view. This will remindContinue reading “The Dashed Print Area Line in Excel”

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, Is-Nullable, etc… You can also use sp_help ‘<TableName>’ For even more descriptive information This willContinue reading “How to get Table Information in SQL Server (Equivalent of Oracle’s desc)”