﻿<asp:Repeater ID="rp_publicity" runat="server" DataSourceID="Sq_ads">
    <ItemTemplate> 
        <a href='<%# "../../"+ Eval("url_publicity") %>'>
            <img style="width: 120px; height: 240px; border:0" title='<%# Eval("Titlle_publicity") %>' src='<%# "../../Admin/image/publicity/"+Eval("ID_publicity")+"."+ Eval("pic") %>'  />
        </a> 
    </ItemTemplate>
</asp:Repeater>
<asp:SqlDataSource ID="Sq_ads" runat="server" ConnectionString="<%$ ConnectionStrings:cmsConnectionString %>"
     SelectCommand="SELECT * FROM  publicity INNER JOIN publicity_Category ON publicity_Category.ID_publicity= publicity.ID_publicity WHERE (ID_Category='کد دسته جهت نمایش وارد کنید')"></asp:SqlDataSource>