Class is ambiguous in the namespace – Fixed

Last night, I slept early 10.45 PM, however wokeup @ 5.45 AM after having my regular # of sleep hours. I have tried my best to sleep for next couple of hours, as there is yet another long work day is awaiting me.

I stopped by work 8 AM this morning and started to work on my issues with code getting work on Visual Studio 2005 IDE. The following errors from yesterday’s port pissed me off.

  • Compiler Error Message: BC30456: ‘InitializeCulture’ is not a member of ‘ASP.login_aspx’.
  • ASPNET: Make sure that the class defined in this code file matches the ‘inherits’ attribute, and that it extends the correct base class (e.g. Page or UserControl).
  • Login is ambiguous in the namespace MyNameSpace.MyApplication

I had a source code with .aspx file containing

<%@ Page Language="VB" AutoEventWireup="false" 
          Inherits="MyNamespace.MyApplication.Login" %>

So, for some reason I changed CodeFile to CodeBehind and voila all the above problems fixed. Now, I need to figure out how in the hell I had CodeFile instead of CodeBehind and whatz the difference between them.

Shyam K. Arjarapu

How to Generate / Create SQL script from stored procedure

Not long ago, I was working on “SQL Synchronizer” -a tool of my own to help synchronize stored procedures from source server / database to target server / database. Use of this tool will become handy when you want to synchronize different environments currently having different versions of stored procedures.

The idea behind developing such tool has struck my mind while moving my changes from development to staging. Though execution of DDL statements went through fine, execution of stored procedures themselves failed as the dependant objects of these stored procedures where not in sync. So, I started to build a .NET project to help me add, delete, update stored procedures either from source / target databases. I shall post the solution to share with you guys, please bare with me for awhile.

Continue reading

SQL SERVER Generate Password Function

Most of you might have come across need for creating a random password for the users. I prefer using passwords that are generated completely random, containing a-zA-Z0-9 and some special characters, making them tough to guess. However, thinking from the user’s perspective those passwords are really hard to remember. So, if you want to leverage complexity of the passwords for making them easy to remember then here is what I have used. Continue reading