This is a migrated thread and some comments may be shown as answers.

Procedure or function spLinkTrackMailRedirectInsert has too many arguments specified

2 Answers 88 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Darren
Top achievements
Rank 2
Darren asked on 23 Jan 2009, 08:40 AM
Hi,

I've wired up my radgrid (4columns) to a sqldatasource. The datasource has the following stored procs attatched.

spLinkTrackMailRedirectInsert
spLinkTrackMailRedirectUpdate
spLinkTrackMailRedirectDelete
spLinkTrackMailRedirectSelect

None of these work, so i set
AllowAutomaticDeletes="True"
AllowAutomaticUpdates="True"
AllowAutomaticInserts="True"

Now i get this error
Procedure or function spLinkTrackMailRedirectInsert has too many arguments specified.

In the SQL Profiler
@LinkTrackMailId = NULL, @DestUrl = N'asd', @LinkUrl = N'asd', @LinkTrackMailRedirectId = NULL

4 parameters but my Insert SP only has 3??

Thanks
My Columns..
                <telerik:GridBoundColumn DataField="LinkTrackMailRedirectId"  
                    DataType="System.Int32" EmptyDataText="&amp;nbsp;"  
                    HeaderText="LinkTrackMailRedirectId" ReadOnly="True"  
                    SortExpression="LinkTrackMailRedirectId" UniqueName="LinkTrackMailRedirectId" 
                    ForceExtractValue="Always"
                </telerik:GridBoundColumn> 
                <telerik:GridBoundColumn DataField="LinkTrackMailId" DataType="System.Int64"  
                    EmptyDataText="&amp;nbsp;" HeaderText="LinkTrackMailId" ReadOnly="True"  
                    SortExpression="LinkTrackMailId" UniqueName="LinkTrackMailId" 
                    ForceExtractValue="Always"
                </telerik:GridBoundColumn> 
                <telerik:GridBoundColumn DataField="DestUrl" EmptyDataText="&amp;nbsp;"  
                    HeaderText="DestUrl" SortExpression="DestUrl" UniqueName="DestUrl"
                </telerik:GridBoundColumn> 
                <telerik:GridBoundColumn DataField="LinkUrl" EmptyDataText="&amp;nbsp;"  
                    HeaderText="LinkUrl" SortExpression="LinkUrl" UniqueName="LinkUrl"
                </telerik:GridBoundColumn>  










2 Answers, 1 is accepted

Sort by
0
Darren
Top achievements
Rank 2
answered on 23 Jan 2009, 09:02 AM
i deleted LinkTrackMailId and edited my insert SP to work out the LinkTrackMailId.

Sorted it out.
0
Darren
Top achievements
Rank 2
answered on 23 Jan 2009, 09:13 AM
i deleted LinkTrackMailId and edited my insert SP to work out the LinkTrackMailId.

Sorted it out.
Tags
Grid
Asked by
Darren
Top achievements
Rank 2
Answers by
Darren
Top achievements
Rank 2
Share this question
or