Sqldataadapter not updating
Now that you know how to create a basic stored procedure, let's create a more advanced stored procedure that includes parameters.
Navigate to and expand the Pubs database node in Visual Studio . Right-click on the stored procedure node and select Create a New Stored Procedure from the popup menu.
This is where you can send an integer status value back to the caller.After you've declared the procedure name, you'll declare any parameters that the stored procedure will use.