[Solved] DeleteCommand

[Mark]

Hi,
I have the radgrid working great with regards to inserting, deleting and updating records.
However, at the moment i am using SQL statements in code.
Eg,     DELETE FROM Customer WHERE CustomerID = @CustomerID
          INSERT INTO...
etc.
What i would like to use are Stored Procedures, but it does not seem to allow me.
I have a Stored Procedure for the SELECT command and this works..

How can i get Stored Procedure to work within the commands..?
EG, "usp_DELETE_Customer @CustomerID"

Thanks
Mark

[Princy]

Hi Mark,

Check out the following code library link.
Update/Insert/Delete with stored procedures and SqlDataSource control

Thanks
Princy.

[Mark]

That was a quick answer !!
Thanks,  realised from your help i needed

.DeleteCommandType = SqlDataSourceCommandType.StoredProcedure

Mark