Okay, I Thought I Had The Return Value From A Statement Figured Out...

  So, Jimmy G helped me out with it in showing a little bit how to do it. SqlCommand command = new SqlCommand(, object>)
SqlParameter param = new SqlParameter();
param.ParameterName = "@return";
param.Direction = ParameterDirection.ReturnValue;
command.Parameters.Add(param);

command.ExecuteNonQuery();

//get the return value
int val = int.Parse(command.Parameters[0].ToString());  

 Where I get lost is in the declaring of a new sqlcommand and sqlparameter. Can you please spell out where to use this and if I need to change my SQLdataSource. I currently was trying to use it in the OnClick of a button. What I had did the following

 Protected Sub CreateIssue_Click(ByVal sender As Object, ByVal e As System.EventArgs)
        dim returnValue as integer

        'how do I get a return value from the stored procedure executed in 'insertissue.insert() here to a variable?
     
        InsertIssue.Insert()

        Response.Redirect("/addarticletoissue")


       
    End Sub

 

again, thank you for your help and patience with such a beginner =)