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;" />

Jago Investor

This books helps you understand the finances better.
Its best for indians to start in the journey of achieving financial literacy.
Manish and Nandish did great job.

Code Complete 2 Book

I found this book suggested by all geeks as best one.
It has core principles of software building which helps to become a better programmer irrespective of the language you code.
I added this book in my reading list.

Exception: "The underlying connection was closed: The connection was closed unexpectedly."

The most important reason might be your connection string.Modify your connection string to the updated database and see how it works like a magic.
The VPN issue may also result it in.Plz check whether your are connected to it.

Make icons background transparent in Windows XP

Please see below link for wonderful explanation of how to do it ?
Click here to know how it can be done !

How to make a Button appear as LinkButton?

.link
{
    text-decoration:none;
    background-color: #FFFFFF;
    background-repeat: no-repeat;
    background-color:Transparent;
    float:none;
    display:block;
    border-style:none;
   
}

use the above css class and you are done !