...
> I'm trying to change my datasource of datalist depending of listbox
> value:
> Listbox:
> <asp:DropDownList ID="ListCriteria" runat="server"
> AutoPostBack="True">
> <asp:ListItem Selected="True"
> Value="1">Positive</asp:ListItem>
> <asp:ListItem Value="2">Negative</
> asp:ListItem>
> <asp:ListItem Value="3">All</asp:ListItem>
> </asp:DropDownList><br />
> Function:
> Function GetDataSource()
> Dim VarDataSource As String
> If Me.ListCriteria.SelectedValue = 1 Then
> VarDataSource = "SELECT * FROM [CustomerList] WHERE
> Amount>0"
> ElseIf Me.ListCriteria.SelectedValue = 2 Then
> VarDataSource = "SELECT * FROM [CustomerList] WHERE
> Amount<0"
> Else
> VarDataSource = "SELECT * FROM [CustomerList]"
> End If
> Return VarDataSource
> End Function
> SelectCommand:
> SelectCommand="<%#GetDataSource().ToString()%>"
> I don't get any records back. Off course, when I try to do this
> manually with criteria from ListBox it works fine.
> Any suggestions?
Just set myDataSource.SelectCommand = GetDataSource() in the codebehind.
--
Eliyahu Goldin,
Software Developer & Consultant
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Mirnes" <leme
@yahoo.com> wrote in message
news:1181121351.548924.85090@h2g2000hsg.googlegroups.com...
> I'm trying to change my datasource of datalist depending of listbox
> value:
> Listbox:
> <asp:DropDownList ID="ListCriteria" runat="server"
> AutoPostBack="True">
> <asp:ListItem Selected="True"
> Value="1">Positive</asp:ListItem>
> <asp:ListItem Value="2">Negative</
> asp:ListItem>
> <asp:ListItem Value="3">All</asp:ListItem>
> </asp:DropDownList><br />
> Function:
> Function GetDataSource()
> Dim VarDataSource As String
> If Me.ListCriteria.SelectedValue = 1 Then
> VarDataSource = "SELECT * FROM [CustomerList] WHERE
> Amount>0"
> ElseIf Me.ListCriteria.SelectedValue = 2 Then
> VarDataSource = "SELECT * FROM [CustomerList] WHERE
> Amount<0"
> Else
> VarDataSource = "SELECT * FROM [CustomerList]"
> End If
> Return VarDataSource
> End Function
> SelectCommand:
> SelectCommand="<%#GetDataSource().ToString()%>"
> I don't get any records back. Off course, when I try to do this
> manually with criteria from ListBox it works fine.
> Any suggestions?