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

取得預存程序的傳回值：
在 ado.net 裡面擷取傳回值的方法為(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; //此處即為傳回值