double quotes in formula

easiest method & CHAR(34) &

Subkeys in Cookies

are stored as NameValueCollection ; therefore, you have to urlencode the values before disaster strikes

Exception from HRESULT: Excel automation issues

I was getting bizarre Exception from HRESULT: on vista where it worked fine on xp
I tried setting security to allow vba projects - nyet
I tried dcom - it wasnt there
I finally tried savecopyas   lo  and behold - it worked

Publish Issue

I had to compile before publishing to get my latest changes in the XAML file

Cannot find a Resource with the Name/Key blah

Fascinating point - if the resource is included in a different xap file there wont be an error

Comparing Images In Sql Server

SELECT 1 where
HASHBYTES('MD5',image) =HASHBYTES('MD5', image)

or the following function 

CREATE FUNCTION [dbo].[fn_HashLongString] (@InputData NVARCHAR(MAX))

RETURNS BINARY(20)

AS

BEGIN

RETURN HASHBYTES('SHA1',SUBSTRING (@InputData,1,3989) + CAST(CHECKSUM(@InputData) AS NCHAR(11)))

END

 

ReportViewer greyed out or without images?

You may need to add managed handler.

Farewells

I have bid adieu to CuteFtp which has so many permissions issues and costs $ to boot.

 Welcome winscp - free and scriptable (I'm talking about you, filezilla)

only one thing - make sure the portable exe is the same version as the dll

Silverlight debugging in VS

A few things you may have to do:

• clear cache
• on the web tab of project click silverlight debugger
• when attaching to process click select->debug these code types->silverlight

relative path for exe run from sql server Job

will be C:\Windows\System32 or such
write out the whole path

System.TypeInitializationException was unhandled

may mean there is a bug in the static constructor

The underlying provider failed to open while connecting with SQL Server Windows Authentication Mode From IIS Errors

Just means the connection can't be made - this could be due to the apppools permissions- it could be due to an incorrect connection string

Debug regular handled errors

debug->exceptions...->

System.BadImageFormatException

could be caused by this not being set

The page you are requesting cannot be served because of the ISAPI and CGI Restriction list settings on the Web server errors

select the server on IIS and set this

To View Complete SSIS Warnings

Open view->Error List

this.controller is null or not an object error

add managed handlers

XP connecting to vista with remote

Unable to copy file error

Unable to copy file "C:\blah.dll" to "bin\blah.dll". The process cannot access the file 'bin\blah.dll because it is being used by another process\

may be caused by a current service running that DLL

adding project to solution doesn't get added to TFS

This happens once in a while - perhaps when you are importing a project that has its own vss files.
what to do

• add the folder by source control explorer
• file-source control->change source control - make sure bindings are correct

Get to the physical GAC

thus:

subst x: %windir%\assembly\gac

View Full Datatable in debug

Relative paths in javascript when using asp.net

use Page.ResolveClientUrl

Repeater in ajax tab component

kept on going out of bounds
tabcontrol scrollbars did not help;likewise asp:panel with scrollbars

at the end i just added div inside tabpanel

IIS Security error

The application attempted to perform an operation not allowed by the security policy.  To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

This can be caused by the site being set up in the wrong pool -e.g  it needs classic asp

Unkown missing static main error

mean the project was inadvertently created as a console project

Could not load file or assembly Error

The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

I had this when a dll was inadvertently copied and windows had the name as blah-copy.dll