Parameters of the stored procedure called by Asp.net

Sqlcommand command = buildquerycommand (connection, storedprocname, parameters );
Command. commandtype = commandtype. storedprocedure;

Cmd. Parameters. Add ("@ ArticleID", article. ArticleID );
Cmd. Parameters. Add ("@ title", article. Title );
Cmd. Parameters. Add ("@ content", article. content );

Ttp: // community.csdn.net/expert/topic/5103/5103411.xml? Temp =. 4127466.

Obtain the returned value of a stored procedure:
The method for getting the return value in ado.net is (C #):
------------------------------------------------------------
Sqlconnection dbconn = new sqlconnection (connstr );

Sqlcommand cmd = new sqlcommand ("sp_uptmp", dbconn );

Cmd. commandtype = commandtype. storedprocedure;

Sqlparameter tmpname = cmd. Parameters. Add ("@ tmpname", sqldbtype. varchar );
Sqlparameter srcpos = cmd. Parameters. Add ("@ srcpos", sqldbtype. varchar );
Sqlparameter rtnval = cmd. Parameters. Add ("rval", sqldbtype. INT );

Tmpname. Direction = parameterdirection. input;
Srcpos. Direction = parameterdirection. input;
Rtnval. Direction = parameterdirection. returnvalue;

Tmpname. value = "";
Srcpos. value = "";
Dbconn. open ();

Cmd. executenonquery ();
Dbconn. Close ();

Tmpid = (INT) rtnval. value; // Return Value