Populate Image Control From DB

I am trying to Populate an image control from DB and I am using a stroed procedure and have never done this before. I usually do this through the gridview.
Could anybody give me a clue as to what I should be doing please.
This is what I am trying.
SqlConnection conn = null; SqlCommand cmd = null; SqlDataReader rdr = null; conn = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ConnectionString); conn.Open(); // Cmd // --- cmd = new SqlCommand("[sp_Populate_Staff_Photo]", conn) { CommandType = CommandType.StoredProcedure }; // Param(s) // -------- cmd.Parameters.AddWithValue("@s_StaffID", txt_search.Text); // Execute // ------- ...