[Solved] Error using delete on grid

[judo]

I'm trying to add a delete column to my RadGrid

I added the below column:

<telerik:GridButtonColumn CommandName="Delete" CurrentFilterFunction="NoFilter" FilterListOptions="VaryByDataType" Text="Delete" UniqueName="AutoGeneratedDeleteColumn" ConfirmText="Do you wish to delete this article?" SortExpression="articleid"></telerik:GridButtonColumn>

and added the appropriate command to my SQLDataSource:

DeleteCommand="delete from arts where articleid=@articleid"

However I still get the error Must declare the variable '@articleid'. whenever I try to delete a column. I have used the same where 'articleid=@articleid' for the update statement of the SQLDataSource which works fine so I don't know what is going wrong.

[Chris Gillies]

Hi Jude,

As I see your code you should have declared the RadGrid property DataKeyName="articleid" (the primary key of the datasource of the grid) and should have set the following parameters for the datasource you are using for the grid:
<DeleteParameters>
   <asp:Parameter Name="articleid" Type="..." />
</DeleteParameters>

Happy Holidays,
Chris