Passing UpdateParameters or a Detail View to a stored Procedure

[jkeel]

If I try to Update a record with the following code using a stored
procedure I get an error:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:stellentConnectionString %>"
SelectCommand="spWC_Adjusters"
SelectCommandType="StoredProcedure"
InsertCommand="spWC_Adjusters_Insert "
InsertCommandType="StoredProcedure"
UpdateCommand="spWC_Adjusters_Update"
UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="A"
Name="Adj_Sup" Type="String" />
<asp:ControlParameter ControlID="GridView1"
DefaultValue="%" Name="Adj_Sup_Num" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>

<UpdateParameters>
<asp:Parameter Name="Unit" Type="String" />
<asp:Parameter Name="Sup_Adj_No"
Type="String" />
<asp:Parameter Name="Sup_Adj_Ind"
Type="String" />
<asp:Parameter Name="extension"
Type="String" />
<asp:Parameter Name="User_id" Type="String"
/>
<asp:Parameter Name="Fname" Type="String"
/>
<asp:Parameter Name="Lname" Type="String"
/>
<asp:Parameter Name="Email" Type="String"
/>
<asp:Parameter Name="Designation"
Type="String" />
<asp:Parameter Name="Adj_Type"
Type="String" />
<asp:Parameter Name="Title" Type="String"
/>
<asp:Parameter Name="Queue" Type="String"
/>
<asp:Parameter Name="Sup_No" Type="String"
/>
<asp:Parameter Direction="ReturnValue"
Name="RETURN_VALUE" Type="Int32" />
</UpdateParameters>

I get the error:
Procedure or function spWC_Adjusters_Insert has too many arguments
specified

So then I try to pass in the arguments for the stored procedure, but
then I get another error:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:stellentConnectionString %>"
SelectCommand="spWC_Adjusters"
SelectCommandType="StoredProcedure"
InsertCommand="spWC_Adjusters_Insert "
InsertCommandType="StoredProcedure"
UpdateCommand="spWC_Adjusters_Update @Unit, @Sup_Adj_No"
UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="A"
Name="Adj_Sup" Type="String" />
<asp:ControlParameter ControlID="GridView1"
DefaultValue="%" Name="Adj_Sup_Num" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>

<UpdateParameters>
<asp:Parameter Name="Unit" Type="String" />
<asp:Parameter Name="Sup_Adj_No"
Type="String" />
<asp:Parameter Name="Sup_Adj_Ind"
Type="String" />
<asp:Parameter Name="extension"
Type="String" />
<asp:Parameter Name="User_id" Type="String"
/>
<asp:Parameter Name="Fname" Type="String"
/>
<asp:Parameter Name="Lname" Type="String"
/>
<asp:Parameter Name="Email" Type="String"
/>
<asp:Parameter Name="Designation"
Type="String" />
<asp:Parameter Name="Adj_Type"
Type="String" />
<asp:Parameter Name="Title" Type="String"
/>
<asp:Parameter Name="Queue" Type="String"
/>
<asp:Parameter Name="Sup_No" Type="String"
/>
<asp:Parameter Direction="ReturnValue"
Name="RETURN_VALUE" Type="Int32" />
</UpdateParameters>
I get the error:
Could not find stored procedure 'spWC_Adjusters_Insert @Unit,
@Sup_Adj_no'.

What gives??????? How can I pass the parameters to the stored
procedure??

[elPako]

Something smell like shit ... i have the same problem - something is
wrong with return value parameter on aspx side. When I add returnvalue
parameter at cs side on deleting event then everything is ok.

jk***@charter.net napisal(a):

If I try to Update a record with the following code using a stored
procedure I get an error:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:stellentConnectionString %>"
SelectCommand="spWC_Adjusters"
SelectCommandType="StoredProcedure"
InsertCommand="spWC_Adjusters_Insert "
InsertCommandType="StoredProcedure"
UpdateCommand="spWC_Adjusters_Update"
UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="A"
Name="Adj_Sup" Type="String" />
<asp:ControlParameter ControlID="GridView1"
DefaultValue="%" Name="Adj_Sup_Num" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>

<UpdateParameters>
<asp:Parameter Name="Unit" Type="String" />
<asp:Parameter Name="Sup_Adj_No"
Type="String" />
<asp:Parameter Name="Sup_Adj_Ind"
Type="String" />
<asp:Parameter Name="extension"
Type="String" />
<asp:Parameter Name="User_id" Type="String"
/>
<asp:Parameter Name="Fname" Type="String"
/>
<asp:Parameter Name="Lname" Type="String"
/>
<asp:Parameter Name="Email" Type="String"
/>
<asp:Parameter Name="Designation"
Type="String" />
<asp:Parameter Name="Adj_Type"
Type="String" />
<asp:Parameter Name="Title" Type="String"
/>
<asp:Parameter Name="Queue" Type="String"
/>
<asp:Parameter Name="Sup_No" Type="String"
/>
<asp:Parameter Direction="ReturnValue"
Name="RETURN_VALUE" Type="Int32" />
</UpdateParameters>

I get the error:
Procedure or function spWC_Adjusters_Insert has too many arguments
specified

So then I try to pass in the arguments for the stored procedure, but
then I get another error:

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:stellentConnectionString %>"
SelectCommand="spWC_Adjusters"
SelectCommandType="StoredProcedure"
InsertCommand="spWC_Adjusters_Insert "
InsertCommandType="StoredProcedure"
UpdateCommand="spWC_Adjusters_Update @Unit, @Sup_Adj_No"
UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="A"
Name="Adj_Sup" Type="String" />
<asp:ControlParameter ControlID="GridView1"
DefaultValue="%" Name="Adj_Sup_Num" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>

<UpdateParameters>
<asp:Parameter Name="Unit" Type="String" />
<asp:Parameter Name="Sup_Adj_No"
Type="String" />
<asp:Parameter Name="Sup_Adj_Ind"
Type="String" />
<asp:Parameter Name="extension"
Type="String" />
<asp:Parameter Name="User_id" Type="String"
/>
<asp:Parameter Name="Fname" Type="String"
/>
<asp:Parameter Name="Lname" Type="String"
/>
<asp:Parameter Name="Email" Type="String"
/>
<asp:Parameter Name="Designation"
Type="String" />
<asp:Parameter Name="Adj_Type"
Type="String" />
<asp:Parameter Name="Title" Type="String"
/>
<asp:Parameter Name="Queue" Type="String"
/>
<asp:Parameter Name="Sup_No" Type="String"
/>
<asp:Parameter Direction="ReturnValue"
Name="RETURN_VALUE" Type="Int32" />
</UpdateParameters>
I get the error:
Could not find stored procedure 'spWC_Adjusters_Insert @Unit,
@Sup_Adj_no'.

What gives??????? How can I pass the parameters to the stored
procedure??