Re: Null values for parameters in Preview Data dialogue?

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

I'm developing in VS2005

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. Or in this case
microsoft.public.vsnet.general


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?

Sorry. None that I know of, but I'm still somewhat of a newbie with this
..Net stuff. I suppose you could supply "impossible" values for those
parameters and rewrite the procedures to test for those impossible values.
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: SQL Native Client Incorrect syntax near Error
    ... When i run a trace i see the following syntax error on a stored ... This stored procedure is called from a VB.NET application, ... but this is a classic ADO newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Updating column property on table gives error
    ... in code instead of when the append happens. ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: I know Im close but Im getting a strange response
    ... > The XML file can be ruled out because it acts as a datasource. ... > The XSL file only acts as a template for the results. ... >> Please reply to the newsgroup. ... >> header is my spam trap, so I don't check it very often. ...
    (microsoft.public.scripting.jscript)
  • Re: YYYYMMDD
    ... > breakpoint but it dosen't stop it at the breakpoint,should I add ... >> a quicker response by posting to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: How do I link the results from sp_executeSQL to a gridview?
    ... I built a stored procedure that needed to use dynamic sql for a search ... but this is a classic ADO newsgroup. ... gridview and simply call the Fillmethod but the ...
    (microsoft.public.data.ado)