Value property does not appear in the parameters editor

microsoft.public.dotnet.framework.adonet

5 Jan 2007 6:29 PM

Steve

Hello fellow coders!

I'm working with typed datasets / tableadapters in VS.NET 2005 with SQL
server for the backend. My tableadapters are configured to use stored
procedures. My stored procedures have a @debug parameter which when set
to 1, causes PRINT statements to be executed to aid in debugging the
stored procedures. The @Debug parameter is not mapped to any column in
my dataset. What I would like to do is set the value of it to 1, which
the documentation for VS.NET says I can do by setting the value
property in the parameters editor. However this property does not
appear in the parameters editor. Nor have I figured out how to set it
through code in an instance of the tableadapter, since the underlying
dataadapter is scoped as private, disallowing access to it's command
objects through an instance.

Is there something I'm missing here? Why does the value property not
appear in the parameters editor, contrary to the documentation? How
else could I set the value of the parameter to what I need?

Thanks,
Steve