DataAdapter.Update

  • Thread starter Thread starter JimHeavey
  • Start date Start date
J

JimHeavey

Hello
I am wanting to know how to populate my dataset with
@varirables returned from my stored procedure when I use
the DataAdapter.Update method. Is this possible?

Say for instance the adapter is tied to a dataset with 3
fields, Movie Title, Movie Description and Tape Number.
The entry screen allows the user to key in the movie
title and when they are done with entering all movie
titles, they press the "Update" button which then runs
the DataAdpater.Update method which is associated with
the store procedure which will determine what values to
assign to the Movie ID and Tape number and return those
values back in the form of @ variables. How to I get
those values and place them into my dataset?

Thanks in advance for your assistance!!!
 
I think, no need to do anything on the .net to get new values back to
dataset.

just you need to specify that those @variable as inputoutput and in stored
procedure you need to assign new values to those variable back

Rajesh Patel
 
I was thinking that I would not supply the Movie ID and
Tape Number as Input params since there is really nothing
of "value" which will be supplied for those particular
fields. But maybe it makes sense to provide.

But I am still not clear on how the @ variables update my
dataset. I do not have to intevene to make this happen?
 
Back
Top