iSeller Commerce
iSeller POS Retail
iSeller POS F&B
iSeller POS Express
Crosslight
WebUI
ClientUI
What's New
Download Trial
Web Solution
Mobile Solution
Enterprise Solution
Custom Development
Blog
Community
Latest Development Blogs
ForumPostTopic
Browse By Tag
In WebGrid 6.0 (219) there are the following bugs:
1. If I try to delete or update a record directly after insert an error message is shown. If I reload the page after insert then it is possible to delete or update the record.2. If AllowColumnFreezing="Default" and FreezePaneSettings ActiveFrozenColumns="1" IE hangs when the mouse pointer is moved to add new row. If AllowColumnFreezing="Yes" it works correctly.
// 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
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.
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.
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?
My sp has always looked like this:
DELETE tblCustomer WHERE CustomerID = @CustomerIDI don't see where I can make any adjustments here.// Staffan
or
Choose this if you're already a member of Intersoft Community Forum. You can link your OpenID account to your existing Intersoft Social ID.
Choose this if you don't have an Intersoft account yet. Your authenticated OpenID will be automatically linked to your new Intersoft account.
Enter your Wordpress Blogname