Asp.net, Response.Redirect not working. Why?
<p>In my application, I'm trying to redirect to another page after a record is inserted into my datasource. The insert part works fine, but the page never redirects. Any ideas? Here's my current code:</p>

<p><strong>ASPX</strong></p>

<pre><code>   &lt;asp:FormView ID="FormView1" runat="server" DataKeyNames="RecapID" 
    DataSourceID="RecapDataSource" DefaultMode="Insert"&gt;
        &lt;InsertItemTemplate&gt;
            Recap Date:
            &lt;asp:TextBox ID="RecapDateTextBox" runat="server" 
                Text='&lt;%# Bind("RecapDate") %&gt;' Width="80px" /&gt;&lt;asp:RequiredFieldValidator runat="server" id="RequiredFieldValidator1" ControlToValidate="RecapDateTextBox" ErrorMessage="*" display="Dynamic" /&gt;
            &lt;asp:Button ID="InsertButton" runat="server" CausesValidation="True" 
                CommandName="Insert" Text="Create"/&gt;
        &lt;/InsertItemTemplate&gt;
        &lt;/asp:FormView&gt;
&lt;asp:SqlDataSource ID="RecapDataSource" runat="server" 
    ConflictDetection="CompareAllValues" 
    ConnectionString="&lt;%$ ConnectionStrings:ConnectionString %&gt;"  
    InsertCommand="INSERT INTO [ftsrms_Recap] ([RecapDate]) VALUES (@RecapDate) SELECT @NewRecapID = SCOPE_IDENTITY()" 
    OldValuesParameterFormatString="original_{0}"&gt;
    &lt;InsertParameters&gt;
        &lt;asp:Parameter DbType="Date" Name="RecapDate" /&gt;
        &lt;asp:Parameter Direction="Output" Name="NewRecapID" Type="Int32" /&gt;
    &lt;/InsertParameters&gt;
&lt;/asp:SqlDataSource&gt;
</code></pre>

<p><strong>ASPX.VB</strong></p>

<pre><code>Protected Sub RecapDataSource_Inserted(sender As Object, e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs)

    'Read the value of the @NewProductID OUTPUT parameter
    Dim newRecapID As Integer = Convert.ToInt32(e.Command.Parameters("@NewRecapID").Value)

    Response.Redirect("Profile.aspx?")

End Sub
</code></pre>
