﻿       <asp:Repeater ID="rp_publicity" runat="server" DataSourceID="Sq_script">
            <ItemTemplate>
                <span><%#Eval("scripts") %></span>
            </ItemTemplate>
        </asp:Repeater>
        <asp:SqlDataSource ID="Sq_script" runat="server" ConnectionString="<%$ ConnectionStrings:cmsConnectionString %>" 
		SelectCommand="SELECT  * FROM  post INNER JOIN post_category ON post_category.ID_posts= post.ID_post WHERE (ID_category='کد دسته مورد نظر وارد کنید') AND [Looktop_post]='False' AND  state='False' AND recyclebin='False' ORDER BY [ID_post] DESc,[date] DESC"></asp:SqlDataSource>