Preview Data dialogue demands values for every param in a store pr

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
If this isn't the correct forum please let me know where I should post.

I'm developing in VS2005 and have a data source based upon a parameterised
stored procedure. I click to preview my data and I'm presented with a very
nice UI that lists all my parameters however, it is the nature of these
paramters that they are mostly left empty - the stored procedures decides on
how to use them depending upon if they contain values or not.

The problem I have is that the Preview Data dialogue demands that I enter a
value for every parameter. Is there any way around this?

TIA - Peter
 
First things first. "Empty" is not a very good term to use in regards to the
data, I would guess that you mean either one of two things, either an empty
string or null; since it's possible that not all of your params are strings,
perhaps you mean null? If you have optional parameters in your stored
procedure then they do not require a value. Otherwise you have to either
provide a value or can set them to be null.
 
Back
Top