Bitlink Development Blog

Error: Unable to cast object of type 'System.Web.Compilation.BuildResultCompiledAssembly' to type 'System.Web.Compilation.BuildResultCompiledGlobalAsaxType'

Solution:

search for "AssemblyCulture" and make sure to delete the culture or put a valid one in.
e.g. [assembly: AssemblyCulture("THIS_IS_INVALID")]

Tags:

The error message:

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

This can be fixed by the following steps:

Tools -> Options -> Designer Page -> "Prevent saving changes that require table re-creation" -> uncheck

Tags:

Solutions to the following error:

Content controls are allowed only in content page that references a master page

You get this error when you have no masterpage assigned to your web form

Options to consider (other than simply adding your masterpage statically):

 You can derive all your pages from a base page in the web config file:

    <system.web>
      <pages pageBaseType="BasePage" >

then create a class and declare it as follow:

    public class BasePage : System.Web.UI.Page { ....

with the following method in it:

    protected override void OnPreInit(EventArgs e)
    {
        string ThemeName = "Bitlink";
        //this should point to your masterpage:
        MasterPageFile = VirtualPathUtility.ToAbsolute(("~/")) + "Themes/" + ThemeName + "/Master.master";
        base.OnPreInit(e);
    }

this way all your pages would be assigned to a certain masterpage dynamically.

Tags:

you get the error: Value cannot be null. Parameter name: propName

the reason could be (it was in my case) that the gridview you are trying to bind contains a comma with no further fields as follow:

  .... DataKeyNames="FullNo1,StudyNo,"

feel free to post other solutions to this error

Tags:

This happens if you run your application in 64bit
(using the Jet for excel etc)

simply switch to 32bit 

Tags:

The following message a project with that name is already opened in the solution when you try to add -> existing project ... to your solution.
dependency : AnkhSvn

This is an problem with AnkhSvn for which the following work around works well:

be careful and please backup/make a copy of your solution file before proceeding:

open your solution file with notepad or similar and search for the reference to the existing project:
(mine looked as follows)

Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "GraspTest", "GraspTest\GraspTest.csproj", "{28F01283-3324-4E3C-A1FE-C256F29130A6}"
EndProject

Just delete this entry and try again.

Tags:

For some reason this sometimes happen when your browsing history becomes too large.

Simply click "tools", "Delete Browsing History"

or shortcut to this ...... control shift delete 

Tags:

Database diagram support objects cannot be installed because this database does not have a valid owner.

This sometimes happen when you attach a database from a different machine or after restoring a database from scratch

Solution:

EXEC sp_dbcmptlevel '<<DBNAME>>', '90';
go
ALTER AUTHORIZATION ON DATABASE::<<DBNAME>> TO "<<LOGINNAME>>"
go
use <<DBNAME>>
go
EXECUTE AS USER = N'dbo' REVERT
go

Tags:

Cannot open database "DBName" requested by the login. The login failed.
Login failed for user 'DBUser'.

This sometimes happen when you attach a database from a different machine
(because the security doesn't reside inside the database itself)

Solution:

use <<DBNAME>>
go

---create LOGIN <<USERNAME>> WITH PASSWORD = '<<PASSWORD>>' , check_policy = off;
---OR (uncomment which one is needed)
alter LOGIN <<USERNAME>> WITH PASSWORD = '<<PASSWORD>>' , check_policy = off;
go

exec sp_change_users_login 'Auto_Fix', '<<USERNAME>>', null, '<<PASSWORD>>'
go

Make sure your username and password match the web.config file's: <configuration>
     <connectionStrings>
          <clear/>
          <add name="MyConnectionString" connectionString="Data Source=MYPC\SQL2005;Initial Catalog=DBNAME;Persist Security Info=True;User ID=<<USERNAME>>;Password=<<PASSWORD>>" providerName="System.Data.SqlClient"/>

Tags:

Some of the errors I've come accross and how to resolve them:

Cannot open user default database. Login Failed

This occurs when you have deleted the database that your login uses as the default database.
If you still have your connection open to the database engine then run the following sql command:

alter login [petelaptop\pete] with default_database = master

if you have lost your connection you have to connect as follow using the command prompt:

sqlcmd -d master -U <<your username here>> -P <<your password here>>

(this will connect using the master database rather than the default which is now deleted.)

Tags: sql, errors