When I call my method InsertOrderRec(...) with the various parameters, the only parameter I need back is the Ticket Number. I call a Sql stored proc which successfully returns the Ticket Number to my custom method; however, when the system returns control back to the FormView InsertTemplate I just lose the Ticket Number.

I tried trapping the ticket number in the ItemInserted event but it's not there.

Here's my InsertParameters :

<InsertParameters>
<asp:Parameter Name="ticket" Direction="ReturnValue" Type="Int32" DefaultValue="0" />
<asp:ControlParameter ControlID="FormView1" Name="cur_1" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="FormView1" Name="cur_2" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="FormView1" Name="amount" PropertyName="SelectedValue" DefaultValue="" />
<asp:ControlParameter ControlID="FormView1" Name="amt_unit" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="FormView1" Name="fx_spot" PropertyName="SelectedValue" />
<asp:FormParameter Name="buy_sell" FormField="hidBuy_Sell" Type="Int16" />
<asp:FormParameter Name="act_cur" FormField="hidAct_Cur" Type="Int32" />
<asp:FormParameter Name="invert" FormField="hidInvert" Type="Int32" />
<asp:FormParameter Name="buy_cur" FormField="hidBuy_Cur" Type="String" />
<asp:FormParameter Name="sel_cur" FormField="hidSell_Cur" Type="String" />
<asp:ControlParameter ControlID="FormView1" Name="order_type" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="FormView1" Name="exp_type" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="FormView1" Name="exp_date" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="FormView1" Name="sub_account" PropertyName="SelectedValue" DefaultValue="''"/>
<asp:ControlParameter ControlID="FormView1" Name="memo" PropertyName="SelectedValue" DefaultValue="''" />
</InsertParameters>

and here's part of my Insert proc (defined within a DataComponents.cs) :

public virtual int InsertOrderRec(Int32 ticket, ... ){

string lcSelectCmd = "InsertOrder_ASPNet";
SqlCommand loCommand = new SqlCommand(lcSelectCmd,
this.Connection);
loCommand.CommandType = CommandType.StoredProcedure;

...
loCommand.Parameters.Add("@ticket", SqlDbType.Int).Direction =
ParameterDirection.ReturnValue;
lnNumRows = loCommand.ExecuteNonQuery();

Int32 lnTicket = (Int32)loCommand.Parameters["@ticket"].Value;
return lnTicket;
}

Please advise...
Bob Mazzo