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

<!-- BEGIN: PAGE SCRIPTS -->
<div id="txtProjName" class="cbp-l-project-title">Construction of Hulhumale LOT10214 </div>
<div id="txtProjClient" class="cbp-l-project-subtitle">Mitts</div>

<div class="cbp-slider">
    <ul class="cbp-slider-wrap">
        
    </ul>
</div>

<div class="cbp-l-project-container">
    <div class="cbp-l-project-desc">
        <div class="cbp-l-project-desc-title"><span>Project Details</span></div>
        <div id="txtProjDetails" class="cbp-l-project-desc-text">Concrete and Finishing Works</div>
    </div>
    <div class="cbp-l-project-details">
        <div class="cbp-l-project-details-title"><span>Project Information</span></div>

        <ul class="cbp-l-project-details-list">
            <li><strong>Client</strong><span id="txtClient">Mitts</span></li>
            <li><strong>Date</strong><span id="txtDate">30 April 2013</span></li>
            <li><strong>Status</strong><span id="txtStatus">Completed</span></li>
        </ul>
    </div>
</div>


<br>
<br>
<br>

<!-- END: PAGE SCRIPTS -->