Deleting is not supported by data source 'SqlDataSource1' unless DeleteCommand is specified

Question

I have an ASP button link in GridView1 that should delete an item from a db table on click, and I am getting this error message:

Deleting is not supported by data source 'SqlDataSource1' unless DeleteCommand is specified.

This is the code:

VB.NET

Protected Sub GridView1_RowCommand(sender As Object, e As GridViewCommandEventArgs) Handles GridView1.RowCommand


    If e.CommandName.Equals("Delete") Then


        Dim rowIndex As Integer = Convert.ToInt32(e.CommandArgument)
        Dim rowID As String = e.CommandArgument.ToString()
        Dim conn As New SqlConnection("Data Source=BRIAN-PC\SQLEXPRESS;Initial Catalog=master_db;Integrated Security=True;")
        Dim cmd As New SqlCommand("DELETE content WHERE content_id=@rowID", conn)

        cmd.Parameters.AddWithValue("@rowID", rowID)

        conn.Open()
        cmd.ExecuteNonQuery()
        conn.Close()


    End If

End Sub

ASP

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" ViewStateMode="Enabled">
    <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
    <Columns>
        <asp:BoundField DataField="content_name" HeaderText="Content Name" SortExpression="content_name">
        </asp:BoundField>
        <asp:BoundField DataField="content_type" HeaderText="Content Type" SortExpression="content_type">
        </asp:BoundField>
        <asp:buttonfield buttontype="Link" commandname="Delete" text="Delete"> 
         <ItemStyle HorizontalAlign="Center" VerticalAlign="Middle" />
        </asp:buttonfield>
         <asp:TemplateField HeaderText=" ">
        <ItemTemplate>
        <asp:LinkButton ID="lnkDownload" runat="server" Text="Download" OnClick="lnkDownload_Click" ></asp:LinkButton>
        </ItemTemplate>
        </asp:TemplateField>
    </Columns>
    <EditRowStyle BackColor="#999999" />
    <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
    <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
    <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
    <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
    <SortedAscendingCellStyle BackColor="#E9E7E2" />
    <SortedAscendingHeaderStyle BackColor="#506C8C" />
    <SortedDescendingCellStyle BackColor="#FFFDF8" />
    <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
</asp:GridView>

From what I read you need to specify a DELETE command for SQLDataSource1.

How do I do that in my case?

Soner Gönül · Accepted Answer · 2013-06-20 06:18:52Z

5

if you change it to something like... CommandName="DeleteRow" or something.. and then change it to if(e.CommandName == "DeleteRow") you will bypass that problem.

edited Jun 20, 2013 at 6:18

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

answered Jun 20, 2013 at 5:56

teardrop

5453 gold badges9 silver badges18 bronze badges

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

2 Comments

user441521 Over a year ago

This did the trick for me although I have no idea why. I guess when the CommandName equals "Delete" it does some assumptions about requiring a Delete command to be filled in?

Bengi Besceli Over a year ago

Thank you, it worked for me, too when I changed "Delete" to something other.

TylerH · Accepted Answer · 2025-03-24 19:50:21Z

1

You have to put this in your ASP code:

<asp:ButtonColumn CommandName="Delete" Text="Delete"></asp:ButtonColumn>

edited Mar 24 at 19:50

TylerH

21.3k84 gold badges84 silver badges121 bronze badges

answered Apr 11, 2013 at 14:13

Minus

7298 silver badges20 bronze badges

2 Comments

Brian Over a year ago

I get this error: Element 'ButtonColumn' is not a known element.

Minus Over a year ago

Oups sorry, this was for a DataGrid, for a GridView, try using this : <asp:CommandField DeleteText="Delete" ShowDeleteButton="True"></asp:CommandField> . Look at this article for some nice examples : msdn.microsoft.com/en-us/library/ms972940.aspx

omar nazzal · Accepted Answer · 2016-01-04 13:58:32Z

0

you need to change it to something Else Like

<asp:buttonfield buttontype="Link" commandname="Del" text="Delete">

and then change it to (e.CommandName == "Del") because "DELETE" Reserved to SQlDataSource Control

answered Jan 4, 2016 at 13:58

omar nazzal

614 bronze badges

Comments

TylerH · Accepted Answer · 2025-03-24 19:51:40Z

If you choose "ShowDeleteButton" under the command field properties of the Select field "Delete" will show on the left of each row on the GridView. However, when you do that there is an expectation that the SQL Data Source will have a a delete command. If not, you get the nasty message about the delete command not being specified.

Since I wanted the business Oobject to handle the delete rather than the SQL data source, I instead used the select, just like you would to select a row, then I changed the "SelectText" under command field properties to say "Delete". That allowed me to use the RowCommand event to catch the delete action. From there I just grabbed the row info I needed, and passed it to the business object for the delete.

Note that when you do it that way the CommandName is still "Select" even though the commandtext is "Delete". So you check as follows:

 if (e.CommandName.ToString() == "Select")

ganesh parve · Accepted Answer · 2015-05-11 06:08:05Z

-1

This error occurs because of you write command name delete. so you write something like Delete Record. and when you use SQLDataSource that time command should be not same as delete or update. Please use alternative name.

answered May 11, 2015 at 6:08

ganesh parve

1

Collectives™ on Stack Overflow

Deleting is not supported by data source 'SqlDataSource1' unless DeleteCommand is specified

5 Answers 5

2 Comments

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related