asp:QueryStringParameter and empty query string parameter
Posted
by abatishchev
on Stack Overflow
See other posts from Stack Overflow
or by abatishchev
Published on 2010-04-21T22:39:54Z
Indexed on
2010/04/21
22:43 UTC
Read the original article
Hit count: 200
I haveasp:GridView
displaying client requests using asp:SqlDataSource
. I want to limit displayed information by client:
View.aspx
has to display everything, View.aspx?client=1
has to display only requests from client ID #1.
So I'm using <asp:QueryStringParameter Name="client" QueryStringField="client" />
for query "EXEC getRequests @client"
.
Everything works properly when some client is specified. But don't - if not.
I tested my SP using SSMS - it works properly in both cases - when parameter is specified and when it isn't (NULL
passed explicitly).
What have I do?
© Stack Overflow or respective owner