Archive for December, 2009

How to programmatically create an Excel Spreadsheet in ASP.net/ C#

The Problem: You need to create a dynamic excel spreadsheet in C#/ASP.net. There are several ways to accomplish this, but this is one I use when I don’t need to specify the column names order to any great detail. I’ve included it in the How To Fix series simply because it took me more than 15 minutes to find the code, and rules are rules.

Read more on How to programmatically create an Excel Spreadsheet in ASP.net/ C#…

Popularity: 3% [?]

How to fix problems with SSL certs in Plesk

The Problem: You attempt to install (or renew) an SSL certificate in Plesk (web hosting management software) but when you follow the instructions (meaning add the certificate in Plesk, and then going to the “Setup” screen for the domain, you do not have the option of selecting the renewed certificate.

Read more on How to fix problems with SSL certs in Plesk…

Popularity: 1% [?]

How to fix invisible view in ASP.net mvc

This is not the most significant I know, but the goal is to document every problem that took more than 15 minutes to solve, and I did try the more complicated methods before I tried the obvious one, so here it is.

The Problem: When programming in ASP.net MVC in Visual Studio 2008 you create a new folder, in the views directory, then create a new view in that directory called Index. For example I was working on the Stronico public site (coming soon, really) and created a directory called “Contact”, and a view called “Index.aspx” so the url could be http://www.Stronico.com/Contact/. I also created the Controller “ContactController.cs”. When I went to the staging site on LocalHost, I got the “File Not Found” error.

The Cause: I never did find out. I tried changing the verbiage slightly, in case contact was a protected word, I reset IIS, I did several other things. None of the usual methods worked.

The Solution: I finally just closed the solution and restarted it and I was able to get to the contact page. No idea why that worked, but it did.

Sort of a a lame post, but I did spend slightly more than fifteen minutes trying to see why the page would not appear, only to find it to be a simple Visual Studio error.

Read more on How to fix invisible view in ASP.net mvc…

Popularity: 1% [?]

How to fix Quickbooks 2010 printing problem on 64 Bit Windows, (Error Code -30)

I intended the focus of the “How To Fix” posts to be Silverlight, but as I’ve encountered other problems while setting up the business, I’m posting those. The rule I established is “If it takes more than 15 minutes to fix, it gets documented” so here we go.

Read more on How to fix Quickbooks 2010 printing problem on 64 Bit Windows, (Error Code -30)…

Popularity: 40% [?]

Quick review of RescueTime

Yesterday I downloaded and installed RescueTime – So far I like it. It hasn’t had that much time to gather data but it does identify many weak ponts. A longer review will be coming as soon as there is more to work with.

Read more on Quick review of RescueTime…

Popularity: 1% [?]

At long last QuickBooks will work

After recreating an XP 32bit Pro installation on two different drives, I finally get QuickBooks 2010 to work on my machine. Now to actually use it and see if it is the fun everyone tells me it is.

Read more on At long last QuickBooks will work…

Popularity: 1% [?]