Dataset Binding stored procedures update/insert/delete
- by Jin
Hi all,
I am currently having a problem since the DB has been changed.
I am using Datasets for a c# application, and there is a user management system.
For the security issues, our current DB design is like
user log into app.
DB returns a session ID
On use of any other stored procedures, a session ID must be specified.
BUT, the DB didn't request session ID before.
since I am using the datasets, I used update/insert/delete stored procedures with
"TableAdaptor Configuration Wizard".
Bind Commands to Existing Stored Procedures
(choose stored procedures to call and specify any reuiqred parameters)
Now, it seems like I have to specify session ID for Insert/Update/Delete stored procedures.
How do I specify session ID parameter here?
It seems like I have to pick one return parameter variable from a select statement.
Thanks,