ansaurus

Question

Answer 1

+1 A:

You need to define a Default value to the parameter for those situations, for example:

<asp:QueryStringParameter Name="client" QueryStringField="client" DefaultValue="0"/>

and then in the SP you need verify if the client is 0, return all the clients, otherwise the specific one.

Tom S. 2010-04-21 22:45:25

Is it possible to set default value to `NULL` (`DBNull.Value`) ?

abatishchev 2010-04-21 22:53:41

Hmm i dont think so. But is there a reason to use NULL instead of 0, -1 or something else?

Tom S. 2010-04-21 22:54:29

@Tom S.: For `NULL` it's easy to use SQL built-in function `ISNULL(,)`. Values like 0 or -1 required additional `CASE-WHEN-THEN` statement into query

abatishchev 2010-04-21 23:09:32

With this url "View.aspx?client=" i think the parameter is automaticly converted to null, because its empty. Try this and give some feedback,

Tom S. 2010-04-21 23:13:15

Thank you for your participation! :) Problem is solved. See below

abatishchev 2010-04-21 23:32:19

Answer 2

+2 A:

SqlDataSource won't fire if any of it's parameters are null, unless you specify otherwise:

<asp:SqlDataSource CancelSelectOnNullParameter="False" />

It might also be necessary to add a null default value to your querystring parameter:

<asp:QueryStringParameter Name="client" QueryStringField="client" DefaultValue="" ConvertEmptyStringToNull="True" />

richeym 2010-04-21 23:10:08

Thank you very much! First option does what I need.

abatishchev 2010-04-21 23:31:38

asp:QueryStringParameter and empty query string parameter