get @RETURN_VALUE after calling MyTableAdapter.Update(...)

11 Oct 2006 2:39 PM

google@easiesttoremember.com

The subject pretty much says it all. I've got a TableAdapter that
calles a stored procedure for its InsertCommand and the stored
procedure returns an integer into @RETURN_VALUE. I can't figure out
either of the following:

1. How do I get the @RETURN_VALUE from the parameters collections of
the commands that were called during the update?
2. How do I access the InsertCommand, DeleteCommand, SelectCommand,
and UpdateCommand objects from my TableAdapter through code? They
don't seem to be available as class members from code... very strange
as they are definitely class members.

TIA!

11 Oct 2006 6:53 PM

google@easiesttoremember.com

OK, I found *AN* answer. If anyone knows of a better way, please let
us know!

http://blogs.msdn.com/youngjoo/archive/2006/07/25/678320.aspx
(Just an FYI: That page doesn't show the article when I'm using
FireFox... had to crank up IE to read it.)

On Oct 11, 10:39 am, "goo***@easiesttoremember.com"
<goo***@easiesttoremember.com> wrote:
Show quote

> The subject pretty much says it all. I've got a TableAdapter that
> calles a stored procedure for its InsertCommand and the stored
> procedure returns an integer into @RETURN_VALUE. I can't figure out
> either of the following:
>
> 1. How do I get the @RETURN_VALUE from the parameters collections of
> the commands that were called during the update?
> 2. How do I access the InsertCommand, DeleteCommand, SelectCommand,
> and UpdateCommand objects from my TableAdapter through code? They
> don't seem to be available as class members from code... very strange
> as they are definitely class members.
>
> TIA!