ALTER PROCEDURE [dbo].[test]
@BookId int output, @BookName varchar(50), @Author varchar(50)ASBEGIN SET NOCOUNT ON; INSERT INTO [book] ( [BookName] ,[Author] ) VALUES ( @BookName ,@Author ) set @BookId=@@IDENTITY; if @@rowcount<>1BEGIN RETURN -1; END RETURN 0;END
Reprinted from: http://www.189works.com/article-42994-1.html
Example:
// Create sqlparameter [] parameters = {New sqlparameter ("@ bookid", sqldbtype. int, 4), new sqlparameter ("@ bookname", sqldbtype. varchar, 50), new sqlparameter ("@ Author", sqldbtype. varchar, 50), new sqlparameter ("retval", sqldbtype. int, 4)}; // set the parameter type parameters [0]. direction = parameterdirection. output; // set it to the output parameter parameters [1]. value = "testname"; Parameters [2]. value = "DSD"; // assign parameters to the input parameter [3]. direction = parameterdirection. returnvalue; // set to return value int A = sqlhelper. executenonquery (sqlhelper. conn_string_lc, commandtype. storedprocedure, "test", parameters); label1.text = parameters [0]. value. tostring () + "---" + parameters [3]. value. tostring ();;