PC Review Forums Newsgroups Microsoft DotNet Microsoft ADO .NET Value property does not appear in the parameters editor

Reply

Value property does not appear in the parameters editor

 
Thread Tools Rate Thread
Old 05-01-2007, 06:28 PM   #1
Steve
Guest
 
Posts: n/a
Default Value property does not appear in the parameters editor


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

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off