ASP.NET gridview delete

Question

I made a quick gridview, bound it to a datasource, put in a select statement it works.

I then went into the datasource, and to the delete tab, and put some delete code in, that ends with where blahUID = @blahUID

I checked the enable deleting checkbox, which added a Delete textlink on each line of the gridview.

However when I press it, it errors because @blahUID is not defined - how can I define it?

<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="...snipped..." 


SelectCommand="SELECT [CategoryUID], [WordUID], [CategoryName], [Colour] FROM [Category] WHERE ([WordUID] = @WordUID);" 
DeleteCommand="delete from [Category] where CategoryUID = @CategoryUID">
<SelectParameters>
    <asp:ControlParameter ControlID="lstWords" Name="WordUID" 
        PropertyName="SelectedValue" />
</SelectParameters>
<DeleteParameters>
    <asp:Parameter Name="CategoryUID" />
</DeleteParameters>

NibblyPig · Accepted Answer · 2009-10-16 12:38:44Z

2

Fixed by putting DataKeyNames="CategoryUID" in the gridview parameters.

answered Oct 16, 2009 at 12:38

NibblyPig

53.3k76 gold badges222 silver badges385 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Kieran Senior Over a year ago

Very common problem in the world of GridView's. You must ensure your DataKeyNames are specified. It also works for multiple keys which is handy.

Collectives™ on Stack Overflow

ASP.NET gridview delete

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related