G
Guest
After a selection a selection is made, the form posts to the server, but no
data gets displayed in the repeater. no errors are given.
<form id="Form1" runat="server">
Category:
<asp:dropdownlist id="category" runat="server"
autoPostBack="True">
<asp:ListItem Text="" />
<asp:ListItem Text="Barbera" />
...
<asp:dropdownlist id="region" runat="server">
<asp:ListItem Text="" />
<asp:ListItem Text="Aconcagua" />
....
Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Handles MyBase.Load
' Put user code to initialize the page here
If Not IsPostBack Then
Dim conPubs As SqlConnection
Dim cmdSelect As SqlCommand
Dim dtrAuthors As SqlDataReader
' Retrieve records from database
conPubs = New
SqlConnection("Server=localhost;Trusted_Connection=true;Database=winestore")
If color.SelectedItem.Text <> "" Then
cmdSelect = New SqlCommand("Select * From maintable
where color=" & color.SelectedItem.Text, conPubs)
conPubs.Open()
dtrAuthors = cmdSelect.ExecuteReader()
' Bind to Repeater
Repeater1.DataSource = dtrAuthors
Repeater1.DataBind()
dtrAuthors.Close()
conPubs.Close()
ElseIf category.SelectedItem.Text <> "" Then
cmdSelect = New SqlCommand("Select * From maintable
where category=" & category.SelectedItem.Text, conPubs)
conPubs.Open()
dtrAuthors = cmdSelect.ExecuteReader()
' Bind to Repeater
Repeater1.DataSource = dtrAuthors
Repeater1.DataBind()
dtrAuthors.Close()
conPubs.Close()
....
(repeated for each data element)
<asp:repeater id="Repeater1" runat="server">
<ItemTemplate>
<%# Container.DataItem( "title" ) %>
</ItemTemplate>
</asp:repeater></p>
data gets displayed in the repeater. no errors are given.
<form id="Form1" runat="server">
Category:
<asp:dropdownlist id="category" runat="server"
autoPostBack="True">
<asp:ListItem Text="" />
<asp:ListItem Text="Barbera" />
...
<asp:dropdownlist id="region" runat="server">
<asp:ListItem Text="" />
<asp:ListItem Text="Aconcagua" />
....
Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs)
Handles MyBase.Load
' Put user code to initialize the page here
If Not IsPostBack Then
Dim conPubs As SqlConnection
Dim cmdSelect As SqlCommand
Dim dtrAuthors As SqlDataReader
' Retrieve records from database
conPubs = New
SqlConnection("Server=localhost;Trusted_Connection=true;Database=winestore")
If color.SelectedItem.Text <> "" Then
cmdSelect = New SqlCommand("Select * From maintable
where color=" & color.SelectedItem.Text, conPubs)
conPubs.Open()
dtrAuthors = cmdSelect.ExecuteReader()
' Bind to Repeater
Repeater1.DataSource = dtrAuthors
Repeater1.DataBind()
dtrAuthors.Close()
conPubs.Close()
ElseIf category.SelectedItem.Text <> "" Then
cmdSelect = New SqlCommand("Select * From maintable
where category=" & category.SelectedItem.Text, conPubs)
conPubs.Open()
dtrAuthors = cmdSelect.ExecuteReader()
' Bind to Repeater
Repeater1.DataSource = dtrAuthors
Repeater1.DataBind()
dtrAuthors.Close()
conPubs.Close()
....
(repeated for each data element)
<asp:repeater id="Repeater1" runat="server">
<ItemTemplate>
<%# Container.DataItem( "title" ) %>
</ItemTemplate>
</asp:repeater></p>