Re: Default Value for Where Clause in Datasource
- From: "William Vaughn" <billvaNoSPAM@xxxxxxxxx>
- Date: Wed, 22 Aug 2007 15:08:19 -0700
I've done this any number of ways but I like using <all> or somesuch as a value in a permissible dropdown list of valid arguments. The query's WHERE clause simply tests for this alternative value or a specific value. And Bob is right. This the ADO classic list.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------
"Lee Stevens" <leecstevens@xxxxxxxxxxxxxxxx> wrote in message news:0AA71EEB-C699-42C9-970D-928FED2F5033@xxxxxxxxxxxxxxxx
Hi all,
I have a textbox and want to populate my datagrid using a LIKE clause from
what is in the textbox. This works fine, however, if the textbox is empty, I
would like it to return all rows. I was looking into setting the default
value to do this, but have had no luck so far in finding an answer.
Does anyone have any advice for this?
.
- Prev by Date: Re: Default Value for Where Clause in Datasource
- Next by Date: RE: Default Value for Where Clause in Datasource
- Previous by thread: Re: Default Value for Where Clause in Datasource
- Next by thread: RE: Default Value for Where Clause in Datasource
- Index(es):
Relevant Pages
|
|
