SELECT 'Files\Photos\' + PhotoFile as PhotoFile, PhotoCaption FROM Photo a INNER JOIN ProjectPhoto b ON a.PhotoID = b.PhotoID WHERE ProjectID = 17<br>There is already an open DataReader associated with this Command which must be closed first.<br>

<!-- BEGIN: PAGE SCRIPTS -->
<div id="txtProjName" class="cbp-l-project-title">Temporary Works of Laamu Vadinolhu</div>
<div id="txtProjClient" class="cbp-l-project-subtitle"></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">Construct the Temporary Works L. Atoll Vadinolhu - to be developed as 150 rooms resort. </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"></span></li>
            <li><strong>Date</strong><span id="txtDate">11 August 2012</span></li>
            <li><strong>Status</strong><span id="txtStatus">Completed</span></li>
        </ul>
    </div>
</div>


<br>
<br>
<br>

<!-- END: PAGE SCRIPTS -->