VB.NET DataSet Updates

In my SQL database I don't allow any INSERT, UPDATES or DELETES to be perform by any other user than the DBO.

So to perform these actions I need to be able to call a stored procedure when calling the DataSet.Update method.

Anybody got any ideas on how to do this. The Microsoft Not So Helpful Files are shedding no light.


Cheers

Gary

You can set your own UpdateCommand for the dataset at runtime, which can be a storedprocedure.