Binding results of query to repeater control

[dinesh]

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>

[Karl Seguin]

Dinesh:
Your code is wrapped in a If Not Page.IsPostback...however, as you say, the
form IS posting back (which it should).

One solution would be to remove the NOT from the if statement.

A BETTER solution would be to place this code in the SelectedIndexChanged
event of the dropdownlist...

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/ - New and Improved (yes, the popup is annoying)
http://www.openmymind.net/faq.aspx - unofficial newsgroup FAQ (more to
come!)
"dinesh" <di****@discussions.microsoft.com> wrote in message
news:17**********************************@microsof t.com...

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>