Posted on: 6/12/2014 4:27:05 PM | Views : 366

how do I sort it buy popsicles, Bars, Candy, Icecream..column name is GroupCode with a blank line after every group
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Shipping %>" ProviderName="<%$ ConnectionStrings:Shipping.ProviderName %>" SelectCommand="SELECT ITEM.ITEMNM, ITEM.DSC, ITMPRICE.PRICE FROM ITEM INNER JOIN ITMPRICE ON ITEM.ITEMNM = ITMPRICE.ITEMNM WHERE (ITMPRICE.ACCTNBR = ?) and STATUS <> 'I'"> Go to the complete details ...