I have a master/Detail page website, where users can select a category of items from a menu. The selected items (from interrogating a SQL database) are displayed in a GridView (on what I called ResultsPage). Using a Repeater control, I also display the brand names (from the selected items), as well as the total number of items for each brand. LinkButton is used to display the brands in a bulleted format. This works fine.
Next, I want to enable users to click on the LinkButton which will cause a postback and be directed to another page (which I called a SubsetPage), where the selected brands are displayed in another GridView.
The problem is that although a selection of brands is displayed, the total number of brands is incorrect. I guess what happens is the data is lost during postback, or the ViewState is incorrect. I have tried different things without success.
Code from the ResultsPage:
<asp:Repeater runat="server" EnableViewState="true" id="Repeater1" > <ItemTemplate>
<asp:Label Text='*' Font-Size="7pt" ForeColor="DarkGray" runat="server"/>
<asp:LinkButton ID="LinkButton1" runat="server" Text='<%# Eval("Brand") %>'
PostBackUrl ='<%#"SubsetPage.aspx?BrandSearch=" & Eval("Brand") %>'>
<asp:Label Text='(' Font-Size="8pt" ForeColor="DarkGray" runat="server"/>
<asp:Label Text='<%# Databinder.Eval(Container.DataItem, "BrandCount") %>' Font-Size="8pt" ForeColor="Black" runat="server"/>
<asp:Label Text=')' Font-Size="8pt" ForeColor="DarkGray" runat="server"/>
Code from the SubsetPage:
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
If Not Page.IsPostBack Then
Dim ConnectionString As String = "Data Source=CYBERSTORE\SQLEXPRESS;Initial Catalog=ProductsDB;Integrated Security=True"
Using SqlCon1 As New SqlConnection(ConnectionString)
If SqlCon1.State <> ConnectionState.Open Then
Dim BrandSearch As String = Request.QueryString("BrandSearch")
Using SqlCom1 As New SqlCommand("ProdProcMSearch", SqlCon1)
SqlCom1.CommandType = CommandType.StoredProcedure
SqlCom1.Parameters.Add("@Brand", Data.SqlDbType.varchar, 50)
GrdMenuSub.DataSource = SqlCom1.ExecuteReader()
I will appreciate any suggestion, along with some example code if possible. Please let me know if you require additional information.