iandevlin.com

Icon

A mixture of musings on web design & development, history, and life

Accessing data records from Excel and CSV files in VB.NET

vb.net

One of the first projects I undertook when I started at my current workplace was to produce a data migrator that ported user data records from a client system to one of our systems. This was written in VB.NET (for compatibility reasons) and the data sources were both Microsoft SQL Server 2005 systems. Recently I’ve had to make a few changes to it to allow the client data source to be either an Excel spreadsheet or a CSV text file. Having never worked with these methods before, I had to look it up (via Google of course) and thought I’d share with you the methods of doing this.

Read the rest of this entry »

Enabling the HTML5 parser in Firefox 3.6

firefox 3.6

With the release of Firefox 3.6, one of the things that was promised was a HTML5 parser. Well it’s here, but the it is turned off by default. Here’s how to enable it.

  1. Type about:config in your Firefox address bar
  2. Click the “I’ll be careful, I promise!” button on the warning message that appears (and make sure you adhere to it!)
  3. Type html5.enable into the filter bar at the top of the page
  4. As you can see it’s currently disabled, so click it to toggle the value to true
  5. There you go, the Firefox HTML5 parser should now be enabled.

    The next question is what does it do…

A new arrival

border terrier puppies

This coming Sunday, 24th January 2010, we will be welcoming a new arrival to come and live with us in the shape of Yogi, the young Border Terrier. Now I have never owned a dog before, yet alone live with one, whereas my girlfriend is dog mad having grown up with Border Terriers and Airedales (her parents currently have one of each).

Read the rest of this entry »

HTML5 Laboratory

html5 laboratory

As you may have noticed, I have been messing around with HTML5 a lot lately, even making my personal website HTML5 compliant. To say the least, this has tweaked my curiosity a lot and I knew that I would be playing around with the new features that HTML5 has to offer and thought that I should create a new site, in HTML5, where I can share my experiences when experimenting with these elements.

And thus HTML5 Laboratory was born!

Read the rest of this entry »

A matter of <form>

a matter of form

When I redesigned iandevlin.com as a business-card style website, I was a bit lazy when it came to the contact form. Other than making it snazzily slide down when the @ symbol graphic is clicked on, I didn’t do much else with it, leaving it the way it was – using a CGI script to send the email (I know! Seriously!)

I always had the intention of changing it but never actually got around to doing it for various reasons that range from just not being bothered to being lazy. But after reading a form of madness over at Dive Into HTML5, I decided that the time had come to actually get on with it, and to make use some of the new elements within html5. And so I have.

Read the rest of this entry »