Reduce the Burden of Expectations

Few days back I came to see a poster sent in whats app, It reads -

"If you want Comfortable Journey of life then , Reduce the Burden of Expectations".

How True !I am myself saved from serious confrontations with my family and friends by just practicing this saying. Just because of being your siblings , spouse or parents does not mean that they should reach your little expectations. Remember that every one has their own definition and perspective of little things. Bringing forgotten or delayed lunch box to your office by a friend or sibling who literally stays nearby is a petty thing for you but it may not be same for other the persons.

You can never understand how it is reasonably correct to say No in this situation even you think with 100 percent empathy and sincerity. The result is frustration and anger on other person who said No.
It does not stop there. It will bother you for the rest of your day by disturbing your work and other human interactions. Keeping a side whether it is fair or not for other person to deny your trivial request, Is it fair on your Self to get disturbed , frustrated and unhappy for being said No ? Never right !

How you deal with this?

Just SMILE or LAUGH and say to yourself that Its perfectly OK to get a 'NO' for your request.
You need not expect any thing more from such a person in future and it helps you  not to ask any further help from him only to get disappointed.Life is too short to worry for others words or deeds which you are not responsible. Keep  smiling and Move ON.

comdlg32.ocx is missing

After googling briefly , I came up with below help and final notes.

1. Firstly , from internet download the Comdlg32.ocx file.You can use below link to download.
    Download Comdlg32.ocx
2. Move comdlg32.ocx to c:\Windows\system32 folder if you are using 32 bit windows OS.
    For 64bit Vista/Windows 7 OS, move comdlg32.ocx to c:\Windows\SysWOW64
3. Open command prompt and use below command.
4. regsvr32  c:\Windows\SysWOW64\comdlg32.ocx
5. You should get below pop up message.
 

6. Once this happens , we are good.Open your VB application now and you will not get the missing dll reference error now.

Don’t you see print statement appearing while running stored procedure script as below?

The missing Go statement with yellow back ground is the cause of it.

CREATE PROCEDURE [dbo].[spGetEmployees]
@EmpId INT
AS
BEGIN
SET NOCOUNT ON

SELECT
E.EmpName,
        E.Designation,
        E.Salary
FROM
Employee
        WHERE Q.EmpId = @EmpId
END
GO

PRINT '[dbo].[spGetEmployees] is Created'
GO

Get data with column names from SQL Result set

Use copy with header and then press Ctrl +V in an excel.You will get column names too along with data.

Login to TFS Server or Other Server Automatically with out providing credentials daily

This is very interesting and useful.

Please follow below steps.

1. Go to Control Panel  , Go to UserAccounts 
2. Click on Credentials Manager
3. You will find "Windows Credentials" section.
4. Click on "Add a Windows credential" link.
5. Enter the valid IP address and credentials and click on OK.
6. From next time , you will login by default and need not enter credentials.

SQL Tips and Tricks

1. Use Keyboard shortcuts in Tools->options for generating regular results sets like sp_helptext and sp_help.
2. When you see ant procedure breaking the If condition logic even the business logic is fine , the best and foremost thing you need to do is to verify the DataType of the variable used in If condition.Remember if you mistakenly used bit for variable x and doing the comparison of integer say x>5 it always go to else condition.The reason the Bit contains 1 values in true case and 0 value in false case.

Make a ASP.LABEL MultiLine(Wrap text in Label)

Please use below code which makes MultiLine text box appear as Label ans suits the need.

 <asp:TextBox ID="txt1" runat="server" Text="RamanaRamanaRamanaRamanaRamanaRamanaRamanaRamanaRa"
        Wrap="true" Rows="2" ReadOnly="true" Width="208px" TextMode="MultiLine" BorderStyle="None"
        BorderWidth="0" Style="overflow: hidden;resize:none;background-color: transparent;" />