C# /ASP.NET/Computing Blog

Hibernate not working on Windows Vista, laptop wakes out of hibernation bug

craig — Sun, 24 Jan 2010 18:36:24 GMT

I have looked around for a solution to this problem, it appears that many people have encountered this issue. On my M1330 Dell XPS I regularly have this problem. I think, I may have pinned down the issue. In my case it seems to occur when there is a ghost Firefox process running in the background. I have seen that occasionally Firefox does not shutdown correctly. If you examine using SysInternals Process Explorer, you can investigate the background processes running. In my case I found a Firefox ghost process running consuming 45% of the CPU. This happens... read more

Insert statement generated using SQLParameter and datetime.now()

craig — Wed, 03 Jun 2009 17:05:23 GMT

Working with DateTime and the DB can be tricky in C#. The easiest way to insert a DateTime robustly in to the DB is to use a prepared statement

cmd.Parameters.AddWithValue("@Date", DateTime.Now);

2) Inserting a Null Value into the Db

As a second point it, I had a situation where it was important to work with a nullable date time in the DB, in this case DBNull.Value should be used as follows:

cmd.Parameters.AddWithValue("@Date", DBNull.Value);

...

subdomain on MojoPortal with DNS Record/CName using Host Name Mapping

craig — Sat, 30 May 2009 09:40:19 GMT

The following describes how to add a subdomain using HostNameMapping on UsanaCar or similar sites, (folder mapping does not seem to work), but in any case host name mapping is much easier. Getting Mojoportal to work with a subdomain can be tricky depending on the hosting provider. On Usanacar, this process requires several steps in addition to the standard mojoportal steps: Adding the A Record on UsanaCar for a new subdomain on mojoportal. 1) On UsanaCar ( or many similar providers) go to the TotalDNS settings page (click on hosting=> manageAccount=>open settings box... read more