Procedure expects parameter '@statement' of type 'ntext/nchar/nvarchar'.

sp_executeSQL , for example , accepts only a parameter of nvarchar

to avoid The site's security certificate is not trusted! errors

use this in Global aspx

  void Application_Start(object sender, EventArgs e)

        {

            // Code that runs on application startup

            System.Net.ServicePointManager.ServerCertificateValidationCallback =

                ((certSender, certificate, chain, sslPolicyErrors) => true);

        }

of course , this is where there is no security issue

IE9

Good article

Would you like to make Internet Explorer your default browser?

setting don't ask again does not work

Limiting file size of uploads in IIS

maxRequestLength indicates the maximum request size supported by ASP.NET
measured in KB
<httpRuntime executionTimeout="900" maxRequestLength="1048576"/>

maxAllowedContentLength specifies the maximum length of content in a request supported by IIS.
measured in bytes
<requestFiltering>
<requestLimits maxAllowedContentLength="1048576000" />

Excel-CSV Date Issues

What happens when you save the following s/sh to csv?

The first column is formatted mm-dd-yyyy  (jan-2 ), the second dd-mm-yyyy(feb-12 )

The answer: 12-02-2011,12-02-2011

Linq issues with datatables

first the interesting thing
if a linq query returns an empty array of datarows - you can still run tolist() on the object.
a different issue that sidetracked me for a long time - if you do something like 

row.Field<string>("BLAH").ToLower()

this will fail if null