Jesi523 0 Junior Poster in Training

Hi, I have a question please I am using a DetailView to Insert into a SQL Server database. I then want to get the last identity id and use it at the end of url to redirect it to another page. I've done a lot of research and I think I have it right but it is not's my code, please help... code:

<asp:SqlDataSource ID="eventDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:RSVPApplicationConnectionString %>"
        InsertCommand="INSERT INTO Events(eventName, description, host, eventRegistrationClosed) VALUES (@eventName, @description, '{a53e98e4-0197-4513-be6d-49836e406aaa}', @eventRegistrationClosed); SET @NewID = Scope_Identity()"
        SelectCommand="SELECT eventAuid, eventName, description, host, isActive, eventRegistrationClosed 
                    FROM Events
                       WHERE eventAuid = @eventAuid">
            <asp:Parameter Name="eventName" />
            <asp:Parameter Name="description" />
            <asp:Parameter Name="host" />
            <asp:Parameter Name="eventRegistrationClosed" />
            <asp:Parameter Direction = "Output" Name="NewId" Type="Int16" />
            <asp:QueryStringParameter Name="eventAuid" QueryStringField="eventAuid" />

then my c# code:

protected void eventDataSource_Inserted(object sender, SqlDataSourceStatusEventArgs e)
                string newId = e.Command.Parameters["@NewID"].Value.ToString();
                Response.Redirect("AddEventOccurrence.aspx?eventAuid=" + newId);

Please please tell me what I am doing wrong. I do not understand. The insert works but it will not redirect it to other page. Thank you!!!!