
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 »

Today I was looking for a way to find a relative path between one absolute directory and another in C#. The .NET libraries themselves don’t seem to have anything that helps with this so I performed the obligatory Google search and came across a handy little function written by Peter Morris which I’ve now incorporated in my library.
Read the rest of this entry »

The Background
Recently I was faced with the task of taking some existing VB.NET code and converting it to C#. Not so difficult so far you’ll say, and you’d be right. However, some of the code on this particular page was contained within a User Control which contained two lists of check boxes in two different categories, which for each category, when a check box item was clicked, was transferred via JavaScript to another (text) list for that category and the selected checkbox removed from the appropriate checkbox list.
Read the rest of this entry »