M
moondaddy
I have a WinForms application that uses webservices for its data access.
Rather than having the user insert/update/delete multiple rows and then send
the dataset back to the server as a batch, I want to submit the changes back
to the server as each row is saved. what would be the best way to send a
dataset datarow back to sql server via a webservice? I know I can simply
use function and pass parameters back to a stored procedure, but I wanted to
explorer the options using the dataset technology since I'm already using
datasets to manage the data in the client app.
The 2nd part to this is if I use a data adapter on the backend to submit the
changes to the db, how can I return a new PK value on inserts? If this
isn't possible, then I may as well stick to passing parameters through the
webservice to a stored procedure to do updates and have the SP return the
new identity value.
Any recommendations?
Rather than having the user insert/update/delete multiple rows and then send
the dataset back to the server as a batch, I want to submit the changes back
to the server as each row is saved. what would be the best way to send a
dataset datarow back to sql server via a webservice? I know I can simply
use function and pass parameters back to a stored procedure, but I wanted to
explorer the options using the dataset technology since I'm already using
datasets to manage the data in the client app.
The 2nd part to this is if I use a data adapter on the backend to submit the
changes to the db, how can I return a new PK value on inserts? If this
isn't possible, then I may as well stick to passing parameters through the
webservice to a stored procedure to do updates and have the SP return the
new identity value.
Any recommendations?