Changing data source

[Mirnes]

I'm trying to change my datasource of datalist depending of listbox
value:

Listbox:

<aspropDownList 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>
</aspropDownList><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?

 

[verci]

Hi Mirnes,

Your function is not defined correctly, it should be:

Function GetDataSource(ByVal X as Integer) as String
some code
return
End Function


Hope this helps,
Verci

 

[Eliyahu Goldin]

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