I am trying to display data from an SQL database using the Repeater control in ASP.net, but I’ve run into some difficulty. Primarily, when a user selects an item from a menu, data from an SQL table is displayed using Gridview – this works perfectly ok. Additionally, I want a subset of the Gridview data to be displayed using the Repeater control - this is where I have the problem: the two sets of data are not displayed simultaneously when a menu selection is made. Instead, the data from the previous menu selection is displayed. In short, the Repeater data lags behind the Gridview data.
Sub Page_Load If Not Page.IsPostBack then Dim SQLstring As Object If MenuSearch = "selected item" Then SQLString = "SELECT * FROM ProductsTab " & _ "WHERE OuterCategory = '" & MenuSearch & "' " & _ "IF OBJECT_ID(N'ProductsDB..BrandsTab') IS NOT NULL " & "DROP TABLE BrandsTab " & _ "SELECT Brand, COUNT(*) AS BrandCount INTO BrandsTab FROM ProductsTab " & _ "WHERE OuterCategory = '" & MenuSearch & "' " & _ "GROUP BY Brand " …………… SqlDataSource2.SelectCommand = SQLString End If End Sub Note: Data from ProductsTab is displayed in Gridview, data from BrandsTab is displayed in Repeater. The subset of selection from ProductsTab is saved in BrandsTab. The Repeater code is:- <asp:Repeater runat="server" id="Repeater1" DataSourceID="SqlDataSourceBrand" OnItemCreated="Repeater1_ItemCreated" > <ItemTemplate> <asp:Label Text='<%# Eval("Brand") %>' runat="server"/> <br /> <asp:Label Text='<%# Eval("BrandCount") %>' runat="server"/> </ItemTemplate> </asp:Repeater>
I hope the above code helps to explain my problem. I would greatly appreciate any help.
Edit: Please use code tags when posting your code , Like so =>
This post has been edited by PsychoCoder: 05 January 2008 - 10:14 AM