RE: Update changes

From: Morten Jokumsen (Jokumsen_at_discussions.microsoft.com)
Date: 05/01/04 

Date: Sat, 1 May 2004 13:52:01 -0700

> Now I would like to know if it's possible to update the changes from dataset
> back to database with stored procedure?
>
> The problem is, that my sqlConnection has only read permissions on the
> database tables and execute permission on Stored procedures.
> That is for security purpose.
>
> Is it possible and any example?
>
> Thank you for your answer,
> Simon
>
Sure it´s possible - and it not hard at all!
Rember that the updatecommand is just a Command object - so there should be no problems. If you not are used to work with SP´s and the command object take a look at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconusingstoredprocedureswithcommand.asp