Assembly.LoadFrom Method

This method dynamically loads dll file. If the assemblyFile parameter passed to the method didn't explicitly specify the directory and the FileNotFoundException occured, try check the Environment.CurrentDirectory to see if it is what supposed to be. One thing that could change the working directory when running the application is the OpenFileDialog. To prevent this to happen, set RestoreDirectory in OpenFileDialog to true.

Tags: .NET

sp_change_users_login

When restore database from another machine, the database user and login user might not be linked correctly. sp_change_users_login might fix the probelm.

Tags: SQL Server 2005

System.Diagnostics.Trace.WriteLine("Message");

Tags: .NET, C#

Visual Studio .NET 2003 Installation Problem

In the first step of installing Visual Studio .NET 2003, if you got the following message even after you reboot the computer.

"Setup has detected that another program requires the computer to reboot"

If it keep asking you to reboot, delete the registry key "HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\PendingFileRenameOperations" or installing Prerequisites components from the Prerequisite CD by yourself.


For more information:
http://support.microsoft.com/?scid=kb;en-us;891402&spid=3040&sid=1252

Tags: Visual Studio .NET 2003