need suggestions on dropdownlist with "ALL" item...

[Cirene]

I have a databound dropdownlist. It is acting as a "filter" for a gridview.
I wanted to add "ALL" to the first item on the list.

Question: In the SQLDataSource (that the ddl is bound to) how do you
suggest I handle the WHERE clause? If the ddl is set to "ALL" then I don't
really want to use the WHERE clause, but if it's something other than "ALL"
I do.

Your thoughts? How can I best implement this?

Thansk!

[Larry Bud]

On Oct 29, 3:48 am, "Eliyahu Goldin"
<[e-mail]:

I wouldn't add WHERE clause for ALL in the first case. It is the simplest
solution.

You have to. If your SQL data source says

where columnname=@ddvalue

What do you think will happen if @ddvalue is "all" or empty or any
value whatsoever?

[Eliyahu Goldin]

I mean I would modify the sql to exclude the WHERE clause. I would remove
"where columnname=@ddvalue".

--
Eliyahu Goldin,
Software Developer
Microsoft MVP [ASP.NET]
http://msmvps.com/blogs/egoldin
http://usableasp.net
"Larry Bud" <la**********@yahoo.comwrote in message
news:11**********************@22g2000hsm.googlegro ups.com...

On Oct 29, 3:48 am, "Eliyahu Goldin"
<[e-mail]:

>I wouldn't add WHERE clause for ALL in the first case. It is the simplest
solution.

You have to. If your SQL data source says

where columnname=@ddvalue

What do you think will happen if @ddvalue is "all" or empty or any
value whatsoever?

[Larry Bud]

>

You have to. If your SQL data source says

where columnname=@ddvalue

What do you think will happen if @ddvalue is "all" or empty or any
value whatsoever?- Hide quoted text -

On Oct 30, 4:12 am, "Eliyahu Goldin"
<[e-mail]:

I mean I would modify the sql to exclude the WHERE clause. I would remove
"where columnname=@ddvalue".

Kinda defeats the purpose of having a dropdown filter.