working with datasets and stored procedures

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Aussie Rules

    #1

    working with datasets and stored procedures

    Hi,

    I have a stored procedure (sql2005) that is executed and fills a
    dataset(ds1).

    I use this dataset to populate a form, which allows the user to edit
    information.

    Currently the user can click a save button, which executes another stored
    procedure that updates the record (only ever 1 at a time).

    This works fine, but for reasons to lengthy to type, I actually need to
    update the dataset(ds1), and then somehow have the dataset update the sql
    server table, rather than executing a stored procedure directly from code.

    Is there way to do this ?

    Thanks

Working...