I have my gridview set up to a sql data source which is in turn linked to a stored procedure. I get the following error:
Procedure or function <stored procedure name> has too many arguments specified.
My sql datasource code is:
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DVC_OVRLDConnectionString %>"
SelectCommand="Select_Device_By_Owner" SelectCommandType="StoredProcedure"
UpdateCommand="update_device_information" UpdateCommandType="StoredProcedure">
<SelectParameters>
<asp:QueryStringParameter Name="userID" QueryStringField="name" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="dvc_nm" Type="String" />
<asp:Parameter Name="data_valid_ind" Type="String" />
<asp:Parameter Name="invld_data_reasn_id" Type="Decimal" />
<asp:Parameter Name="work_actn_id" Type="Decimal" />
<asp:Parameter Name="comnt_txt" Type="String" />
<asp:Parameter Name="wrqst_need_ind" Type="String" />
<asp:Parameter Name="wrqst_cd" Type="Decimal" />
<asp:Parameter Name="rview_ind" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>
my stored proc is:
@dvc_nm varchar(50),
@data_valid_ind char(1),
@invld_data_reasn_id numeric(9,0),
@work_actn_id numeric(9,0),
@comnt_txt varchar(1000),
@wrqst_need_ind char(1),
@wrqst_cd numeric(11,0),
@rview_ind char(1)
AS
BEGIN
SET NOCOUNT ON;
Update
DVC
set
data_valid_ind = @data_valid_ind,
invld_data_reasn_id = @invld_data_reasn_id,
work_actn_id = @work_actn_id,
comnt_txt = @comnt_txt,
wrqst_need_ind = @wrqst_need_ind,
wrqst_cd = @wrqst_cd,
rview_ind = @rview_ind
where
dvc_nm = @dvc_nm
I don't understand my parameters match up. I have have only 7 cols set to readonly = false; The 8th col that i am using in the update is the PK so it is left as readonly = true;
I don't understand why it thinks i'm passing tomany parameters
Thanks for any help!