SELECT TOP 1 PhotoFile FROM Photo a INNER JOIN ProjectPhoto b ON a.PhotoID = b.PhotoID WHERE ProjectID = 69
Invalid operation. The connection is closed.
SELECT 'Files\Photos\' + PhotoFile as PhotoFile, PhotoCaption FROM Photo a INNER JOIN ProjectPhoto b ON a.PhotoID = b.PhotoID WHERE ProjectID = 69
ExecuteReader requires an open and available Connection. The connection's current state is open.