Retrieve data from a database

Nothing advanced here, I just wanted to store this code snippet somewhere for easy reuse…

SqlConnection conn = new SqlConnection(@"...");
SqlCommand cmd = new SqlCommand("select * from employee", conn);
cmd.CommandType = CommandType.Text;

using (conn)
{
	conn.Open();
	SqlDataReader reader = cmd.ExecuteReader();
	while (reader.Read())
	{
		...
	}
}

How to create a transparent GIF with GIMP

The GIMP is a great, free image manipulation program. It can do a lot but it’s not always obvious how it can perform a certain task.

For example, creating a transparent GIF was something I could not find how to do. Luckily, there are other bloggers out there to help:

The Gimp: Making Colors in a GIF Transparent (A.P. Lawrence).

Good tip and it works great.