Miscellany

_pasteConInfo = new pasteConnectionInfo();
        using (SqlConnection conn = new SqlConnection(_pasteConInfo.PasteConnectionString))
        {
            SqlCommand cmd = new SqlCommand("EXECUTE sp_getCode 1", conn);
            cmd.Connection.Open();
            SqlDataReader reader = cmd.ExecuteReader();
            while (reader.Read())
            {
                testCase.Text = reader["code"].ToString();
            }
        }