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

Question

0.00/5 (No votes)

See more:

Hi,

I have used stored procedure to delete the value in Gridview_RowDeleting event.

Record is deleted from DB. but I am getting this error.

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

how to resolve this?

Posted 13-Dec-11 20:37pm

palraj001

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2011-12-13T20:41:00

Solution 1

As the error states, you haven't defined a command for delete. Try defining: SqlDataSource.DeleteCommand Property [^]

Posted 13-Dec-11 20:41pm

Wendelius

Comments

palraj001 14-Dec-11 2:46am

actually i used SP for deleting the record. i have written delete query in SP. without using this delete command, Cant we delete it?

Wendelius 14-Dec-11 2:52am

From MSDN: The DeleteCommand represents an SQL query or the name of a stored procedure, and is used by the Delete method

So you can use the stored procedure. Just define it (and it's parameters) in the DeleteCommand property

mehdifaster123 · Answer 2 · 2014-03-05T19:52:00

Solution 2

please change CommandName="delete" to CommandName="mydelete"
i sure solve your problem

Posted 5-Mar-14 19:52pm

mehdifaster123