Hi Staffan,

For your first issue, please delete the "OR ([CustomerID] IS NULL AND ? IS NULL)" inside the DeleteCommand, please also delete the UpdateCommand to make it work as well.

For your second issue, please try my attach sample, let me know if the problem still persist. I can't replicate your second issue on my side.

Thank you and have a nice day.

Best regards,

Niven Prasetya

Hi!

Regarding the first issue: I'm calling a sp "spCustomerDelete". What is the solution then?

I come back with my response after testing your attached sample regarding the second issue.

// Staffan

Hi Staffan,

I believe this would be the code produce by the ISDataSource

<asp:AccessDataSource ID="AccessDataSource1" runat="server" 
            DataFile="~/App_Data/NorthWind.mdb" 
            DeleteCommand="DELETE FROM [Customers] WHERE (([CustomerID] = ?) OR ([CustomerID] IS NULL AND ? IS NULL))" 
            InsertCommand="INSERT INTO [Customers] ([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" 
            SelectCommand="SELECT * FROM [Customers]" 
            
            UpdateCommand="UPDATE [Customers] SET [CompanyName] = ?, [ContactName] = ?, [ContactTitle] = ?, [Address] = ?, [City] = ?, [Region] = ?, [PostalCode] = ?, [Country] = ?, [Phone] = ?, [Fax] = ? WHERE (([CustomerID] = ?) OR ([CustomerID] IS NULL AND ? IS NULL))">

By deleting the OR ([CustomerID] IS NULL AND ? IS NULL). It will become like the code below

<asp:AccessDataSource ID="AccessDataSource1" runat="server" 
            DataFile="~/App_Data/NorthWind.mdb" 
            DeleteCommand="DELETE FROM [Customers] WHERE (([CustomerID] = ?))" 
            InsertCommand="INSERT INTO [Customers] ([CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City], [Region], [PostalCode], [Country], [Phone], [Fax]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" 
            SelectCommand="SELECT * FROM [Customers]" 
            UpdateCommand="UPDATE [Customers] SET [CompanyName] = ?, [ContactName] = ?, [ContactTitle] = ?, [Address] = ?, [City] = ?, [Region] = ?, [PostalCode] = ?, [Country] = ?, [Phone] = ?, [Fax] = ? WHERE (([CustomerID] = ?))">

You can adjust this to your spCustomerDelete.

Hows the second issue?

 Thank you and have a nice day.

Best regards,

Niven Prasetya

My sp has always looked like this:

DELETE tblCustomer WHERE CustomerID = @CustomerID

I don't see where I can make any adjustments here.

// Staffan

Hi Staffan,

It works fine on my WebGrid 6 build 220 and Framework 3 build 705. I have attach a video of my sample.

Please apply the new hotfix for WebGrid and Framework, then please run my attach sample.

If the the issue still persist please change my sample which can replicate your issue.

Thank you and have a nice day.

Best regards,

Niven Prasetya