Monday, August 3, 2015

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.

Monday, April 7, 2014

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.

Wednesday, July 31, 2013

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.

Tuesday, June 11, 2013

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.

Tuesday, August 21, 2012

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="overflowhidden;resize:none;background-colortransparent;" />

Saturday, August 18, 2012

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.