Some Application Icons for Web Development

Not everyone who develops for the web has great design and UI skills so it's sometimes tricky to make an application look good and have that polished layer that finishes application development. If you aren't great in Photoshop or Fireworks then don't be afraid to turn to the web for resources to spice up your application.

SQL Query - Optional "where" parametres

There is a really simple way you can add optional parameters to a SQL select statement without having to convert the query into TSQL or any other dynamic way to create the query. The query uses the "CASE" clause to perform the required task. Here's how:

Missing Visual Studio 2008 Templates?

Just had a bit of an issue using Visual Studio 2008 on Vista 64bit where no options appeared in the "New Projects" box that appears when you create a new project.
If you have the same issue then try the following:
1. Remove items from the following:

C# Thumbnail Generator

Earlier in this blog I posted a VB thumbnail generator. The following is the same function but converted to c#. It converts an image on the file system to a thumbnail using the X, Y values sent to the function along with its save path.

C# Select Case = Switch

If like me you have converted from VB.Net to C# then this is a handy bit of code:

Search DB for column names

Here is a handy bit of SQL used to search a database for tables that contain a specific column name:

Select
 name 
 from sysobjects 
 where id in (select id from syscolumns 
 where name like '%ColumnName%')

Pretty handy if you have a database with a lot of tables in and you need to find the correct tables etc.

Generate Thumbnail - VB.Net

The following function allows the automatic creation of a thumbnail from an uploaded image. It is assumed that thumbnail is required (a check before the function is called).