Passing UpdateParameters or a Detail View to a stored Procedure

J

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??
 
E

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.

(e-mail address removed) napisal(a):
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Procedure or function has too many arguments specified 0
Procedure or function Authorize_Member has too many arguments specified 1
OleDb SqlDataSource stored procedure call parameter order mixed up ? 0
GridView UpdateParameters 3
Return value parameter error 12
How do I get rid of the select button in a gridview? 1
databinding 'system.data.datarowview' does not contain a propertywith the name 1
Returning SCOPE_IDENTITY from SQLDataSource and DetailsView 1

Members online

No members online now.
Total: 22 (members: 0, guests: 22)
Robots: 333

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,007
Latest member
obedient dusk

Latest Threads

Top