Proc Return Value Question

Hi Folks

How do I get a return value ( a string, not int32) from an insert on a proc? This is what I've done so far:

Thanks in advance

The proc:

CREATE  PROCEDURE Proc_Course_Event
@action varchar(30)='',
@CourseID int='0'

 AS

if @action = 'ins_event'
 begin
  INSERT INTO
   Tbl_Course_event ( CourseID)
  VALUES
   (@CourseID)
  
  Select ReturnEventID = EventID from Tbl_Course_Event where id = @@Identity

 end
GO

The SQLDataSource Control:

<asp:SqlDataSource ID="Sql_Course_Names" runat="server"

ConnectionString="<%$ ConnectionStrings:TNAConnectionString %>"

SelectCommand="Proc_Course" SelectCommandType="StoredProcedure"

InsertCommand="Proc_Course_Event" InsertCommandType="StoredProcedure">

<SelectParameters>

<asp:Parameter DefaultValue="Course_Names" Name="action" Type="String" />

</SelectParameters>

<InsertParameters>

<asp:Parameter DefaultValue="ins_event" Name="action" Type="String" />

<asp:Parameter DefaultValue="CourseID" Name="CourseID" Type="String" />

<asp:Parameter Name="ReturnEventID" Type="String" Direction="Output" />

</InsertParameters>

</asp:SqlDataSource>

The code-behind:

Protected Sub Sql_Course_Names_Inserted(ByVal sender As Object, _

ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) _

Handles Sql_Course_Names.Inserted

Dim EventID As String = Convert.ToString(e.Command.Parameters("@ReturnEventID").Value)

Response.Write(EventID)

End Sub