Filter to show all records in listview

Question

0.00/5 (No votes)

See more:

Hi ppl

I am creating a filtered listview, while it is filtering just fine I would like to have a show all option, just don't know what to make the value I was trying to use IS NOT NULL and didn't work

Below is my code for the listbox and data connection

Any hel will be greatly appriciated

<asp:ListBox ID="PayD" runat="server" AutoPostBack="True" 
                            DataSourceID="SqlDataSource2" DataTextField="Payment" DataValueField="Payment" AppendDataBoundItems="true">
                            

<asp:ListItem Value="  ???????   " Selected=True>All
                            
                           
                        

      <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                            ConnectionString="<%$ ConnectionStrings:Raw_dataConnectionString %>" 
 SelectCommand="SELECT * FROM [MiscBilling] WHERE ([Payment] = @Payment)">
                            <SelectParameters>           ^Value from Listbox^
                                <asp:ControlParameter ControlID="PayD" Name="Payment" 
                                    PropertyName="SelectedValue" Type="String" />
                            </SelectParameters>

Posted 29-Apr-12 23:47pm

Member 8834082

Add a Solution

Comments

Sandeep Mewara 30-Apr-12 6:11am

Not clear.

Member 8834082 30-Apr-12 6:28am

Hi Sandeep

I am looking for a value to give the list item (Value=" ??????? "), that will select all the records in the db WHERE ([Payment] = @Payment)--- @Payment would be the value from the listbox

tx

Sandeep Mewara 30-Apr-12 6:39am

What's wrong with Select * FROM [MiscBilling] only? Why where clause when you want all the records? :confused:

Member 8834082 30-Apr-12 6:56am

This is the code as generated in visual studio 2010, I added the

<asp:ListItem Value=" ??????? " Selected=True>All

I have a listbox with fields

all
monthly -Databound
once-off -Databound

This filters the data in my listview according to the user input, I am trying to get the ALL value to show all records in the listview but i need to give it a value in the listbox (this is the value i'm looking for), the data source has a where cluase and this uses the values from the listbox, I tried giving, 'ALL' a value of "is not null" or "> '0'" to make the select where payment is not null to give me all values but it doesn't give me any results, selecting monthly or once-off works, but want to have a option to view all records - monthly and once off while keeping it dynamic if there is another catagory added

Thanks for the help

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2012-04-30T01:18:00

Solution 1

Ok.

Try using wild card character %, something like WHERE Payment LIKE %@Payment%

Generally this is good for strings search. See if this fits in for you.

Posted 30-Apr-12 1:18am

Sandeep Mewara

Comments

Member 8834082 30-Apr-12 7:28am

I tried using LIKe % as a value for the listbox but also doen't work, the problem is I cannot make any changes to the actual where cluase in the data connection becuase then it will only show all the records and not filter anymore, it has to be a value given to the list item, in the listbox

Sandeep Mewara 30-Apr-12 7:59am

If you cannot change the query then it would be difficult. Further, what are the possible values of Payment?