Clicking on a Tab is closing tab in Chrome

I came across this situation few weeks ago.When I click on a tab to see its page in chrome browser, it is getting closed and it made me very annoyed. I tried several ways suggested in google search but nothing worked.

Finally some where I read just hold on middle scroll bar for some time on the tab and this issue will be sorted out.I tried holding scroll bar firmly for few seconds on the tab and it indeed worked.
Tabs are no longer getting closed upon clicking them.

Remove unused Extra rows and cells in Excel

Please refer below site for handling unused extra cells and rows in excel.
Source- http://smallbusiness.chron.com/remove-extra-unused-cells-microsoft-excel-2013-75272.html

I copied the actual information from the above website for quick reference.

Worksheets in Microsoft Excel can contain over a million rows and over 15,000 columns. With a workspace that large, if you're not careful, you can both easily and unintentionally enter data into the wrong cell -- which, depending on what you're working on, can interfere with important calculations. Fortunately, just as you can remove empty cells in a printout, you can also hide them on your PC.

Press "Ctrl-End" to move to the end of your worksheet and then select the cell located directly below the current cell.

Press "Ctrl-Shift-Down" to move to the bottom row and then select "Format" from the Cells group on the Home tab.

Point to "Hide & Unhide" and then choose "Hide Rows" from the menu to remove all of the selected rows from your worksheet.

Return to the last cell in your worksheet and then select the cell located directly to the right.

Press "Ctrl-Shift-Right" to highlight the remaining columns and then click "Format."

Point to "Hide & Unhide" and then choose "Hide Columns" from the menu to remove the selected columns.

Insert Excel Data into SQL SERVER table directly

Suppose you got huge data in Excel and you need to query the data by creating a table for the same.
So , as a first step , create a table with columns of appropriate data type in the same order as they are in excel.
Example, we have an excel with ID and Name data.Hence, we are creating a table as below.

CREATE TABLE [dbo].[NameList](
[ID] [int] NOT NULL,
[Name] [varchar](500) NOT NULL

) ON [PRIMARY]
GO

Open the Excel with Data.
Click on bottom triangle before first cell to select entire data.🔻

The data will get selected as below.

Now copy and got to the SQL SERVER MGMT Studio.Open Object Explorer, go to the respective table namely "NameList".Right click and choose "Edit Top 200 Rows" as below.

Click on the Side triangle with star symbol to select the 2 columns.Then you can use Ctrl+V or paste command to paste the copied excel data.

After pasting the data , you can find all excel data as below.

Invalid Column Name issue in Classic ASP

While running classic ASP application , we come across below errors quiet often
- Invalid Column name
-Procedure does not exist
-DataSource is not valid
-Connection error

If you resolve one error by commenting and another error is coming OR you find that connection string is pointing to correct DSN mapped to correct database server but still error coming up , below is the solution.

Sit straight and tight 😊😊

May be, you are trying to search for ODBC driver in windows search and updating here.

This location may not be the one you ASP application is referring.Hence the DSN you have given is not picked by your application but different DSN of other ODBC driver.
So lets try to navigate to other hidden ODBC path using below run command.
%windir%\SysWOW64\odbcad32.exe

Here is the location of the correct odbc path,

Try to update your DSN with correct database server details using above exe and it will work for sure,

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

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 !

How to consume a .NET Dll in Classic ASP?

1.Use regsvr32  /u   to uninstall the existing  OLD ASP dll by navigating to the exact path of dll location in command prompt.
   Eg:regsvr32  /u CLib.dll

2. Go to Visual Studio Command Prompt.

3. Navigate to the path where the new .Net Dll (say CLib.dll) is residing.

4. Make the assembly CLibshared by adding it to GAC using below statement
   gacutil –i  CLib.dll 

5. Install the assembly into the registry using below command.
   regasm CLib.dll /tlb: CLib.tlb

6. Reset the IIS using command iisreset(not mandatory)

7. Now we can use our .Net DLL CLib.dll in ASP page.

MyThoughts !

1. Never Let a task take 1 minute if it can be done in 59 seconds.
2. Positive Outlook is must before you begin doing even your bath.
3. If you have Jealousy, kill it fast otherwise  it will kill you faster.
4. Studying great people broadens your thinking.The better way is to read their biographies and best way is to keep studying them personally if you have found one.
5. The thing we are seeking is near to us but we rarely realize it.The so called Great ones can be found in your close circle itself if you have open mind.
6. The quickest way to calm down your mind is to calm down your speech.Keep quiet and you feel comfortable.  

Tip 1 : Accessing Remote Application

Suppose you have a application MyWebApps and it is published in IIS. This application has a webpage which uses the files from a remote server to which you will get access by using separate credentials given to you.
Now you are able to open the remote server folders using Windows Explorer or Runcommand.
But you are unable to retrieve the same files while running the application.Why?

The reason is your IIS account has different user credentials say IUSR_[MACHINE_NAME].But you remote server has different username and password.So you have to give the same credentials for IIS account which you are actually using to access the client server using some software like TFS.

So change the IIS account  username and password and I am sure you are able to find the shared files.Hurrah :)

Some Good Sites

http://www.koders.com/
This contains source code of some projects you can observe in  free time.
http://www.box.net/
This site provides storage of up to 5GB.
http://resizepic.com/
This site is for one simple purpose, to let you resize picture.
http://www.sqlinform.com/free_online_sw.html
This site helps you in SQL Indentation.
http://telugu.changathi.com/Dictionary.aspx
Its a superb English to Telugu dictionary site.
http://en.srichaganti.net/
This site has excellent discourses on Scriptures by Brahmasri Sri Chaganti Koteswara Rao garu in Telugu.