extra DataKeyNames - Stored procedure too many arguments ??

[jobs]

I have a gridview that I use to both select a record to be edited in a
formview and to also delete records with. Because the selectcommand is
grouping rows, my deletes stored procedure requires a different set
of keys than the one used for the edit.
The datakeyname in my gridview has a key I need for editing that I do
not need for deleting. The delete gives me the Procedure or function
has too many arguments specified error so long as the extra key
RatePlanId is the datakeynames attribute of the gridview. However, I
need that rateplanid key to pull the record into a formview when the
grid row is selected.

I not sure why it even matters as my delete parameters do not list the
... rateplanid key identified.

<asp:GridView ID="RateGridVie w" runat="server"
AutoGenerateCol umns="False"
DataKeyNames="r ateplanid,route code,plancode"
Width="700px" SkinID="GridVie w" AllowPaging="Tr ue"
AllowSorting="T rue" ShowFooter="Tru e"
PagerSettings-Mode="NumericFi rstLast"
DataSourceID="R ateGridSource">
<EmptyDataTempl ate>
No Data
</EmptyDataTempla te>
<Columns>
<asp:CommandFie ld ButtonType="Ima ge"
ShowSelectButto n="True"
SelectImageUrl= "../App_Themes/WinXP_Silver/Images/edit.gif" />
<asp:CommandFie ld ButtonType="Ima ge"
showdeleteButto n=true
deleteImageUrl= "../App_Themes/WinXP_Silver/Images/delete.gif" />
<asp:BoundFie ld DataField="rate planid" Visible="false"
/>
<asp:BoundFie ld DataField="Prod uctCode"
ItemStyle-Width="25" HeaderText="Pro duct Code"
SortExpression= "ProductCod e" />

.. more code here
</asp:GridView>
<asp:SqlDataSou rce ID="RateGridSou rce" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:RTEConnectio nString %>"
OnDeleting="Dat asource_ing" OnDeleted="Data source_ed"
SelectCommand=" Select DISTINCT .. more code here >
<SelectParamete rs>
... code here
</SelectParameter s>
<DeleteParamete rs>
<asp:Paramete r Name="RouteCode " Type="String" />
<asp:Paramete r Name="Plancode" Type="String" />
<asp:SessionPar ameter SessionField="C urrentUser"
Name="lastUser" Type="String" />
</DeleteParameter s>
</asp:SqlDataSour ce>


I've also tried this:
<DeleteParamete rs>
<asp:ControlPar ameter ControlID="Rate GridView"
Name="RouteCode " Type="String" />
<asp:ControlPar ameter ControlID="Rate GridView"
Name="PlanCode" Type="String" />
<asp:SessionPar ameter SessionField="C urrentUser"
Name="lastUser" Type="String" />
</DeleteParameter s>

When I remove RatePlanId from the datakeyname the delete works, but my
edit fails.