Intersoft Community - WebGrid Enterprise - WebGrid bugs

WebGrid bugs

niven — Tue, 28 Sep 2010 02:46:38 GMT

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

WebGrid bugs

staffan.eriksson@semita.se — Mon, 27 Sep 2010 05:05:51 GMT

My sp has always looked like this:

DELETE tblCustomer WHERE CustomerID = @CustomerID

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

// Staffan

WebGrid bugs

niven — Sun, 26 Sep 2010 23:47:05 GMT

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

WebGrid bugs

staffan.eriksson@semita.se — Fri, 24 Sep 2010 04:53:52 GMT

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

WebGrid bugs

niven — Fri, 24 Sep 2010 04:41:22 GMT

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

WebGrid bugs

staffan.eriksson@semita.se — Thu, 23 Sep 2010 03:53:08 GMT

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