Re: Default Value for Where Clause in Datasource
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Wed, 22 Aug 2007 15:31:20 -0400
Lee Stevens wrote:
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?
I can't answer this without seeing your code. There are many ways you
could have accomplished your first task: dynamic sql, parameterized sql
statement, stored procedure ...
However:
There was no way for you to know it (except maybe by browsing through
some of the previous questions in this newsgroup before posting yours -
always a recommended practice) , but this is a classic ADO newsgroup.
ADO.Net bears very little resemblance to classic ADO so, while you may
be lucky enough to find a dotnet-knowledgeable person here who can
answer your question, you can eliminate the luck factor by posting your
question to a group where those dotnet-knowledgeable people hang out. I
suggest microsoft.public.dotnet.framework.adonet.
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- Prev by Date: Re: Closing recordset generates exception
- Next by Date: Re: Default Value for Where Clause in Datasource
- Previous by thread: Closing recordset generates exception
- Next by thread: Re: Default Value for Where Clause in Datasource
- Index(es):
Relevant Pages
|
|
