Intersoft Community - WebGrid Enterprise - Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

Michael — Thu, 15 Oct 2009 02:58:02 GMT

Thanks for the additional note.

I am very grateful for such advice!

Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

technical@intersoftpt.com — Thu, 15 Oct 2009 01:57:05 GMT

Hello Michael,
Thank you for pointing out the issue in this scenario.
We have been able to replicate your problem with the exact error message you reported, and will fix it in the upcoming hotfix.
The work item # is 431 for your tracking reference.

As an additional note for the complete solution, you'll need to clear the cached data source upon the data update process to avoid data-locking issue that may happen during the batch update process. This is only required if you're binding to datasource object through InitializeDataSource event.

For example,

protected void grdProductLine_BatchUpdate(object sender, BatchUpdateEventArgs e)
        {
            DataRowState rs = DataRowState.Added | DataRowState.Deleted;
            DataSet dsModified = ((DataSet)grdProductLine.GetCachedDataSource()).GetChanges(rs);
            if (dsModified != null)
            {
                PutDataMaintenanceProductLine(dsModified);
                grdProductLine.ClearCachedDataSource(); // clear data cache after update
            }
        }

Note: You'll need to apply the above codes _in addition_ to applying the upcoming hotfix.

Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

technical@intersoftpt.com — Thu, 15 Oct 2009 01:08:29 GMT

Hello Michael,

Thank you for pointing out the issue in this scenario.

We have been able to replicate your problem with the exact error message you reported, and will fix it in the upcoming hotfix.

The work item # is 431 for your tracking reference.

Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

Michael — Tue, 06 Oct 2009 10:06:03 GMT

The code was always executed!

Thanks for tip.

Michael

Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

james — Tue, 06 Oct 2009 08:47:24 GMT

Michael,

Make sure your column-level initialization codes are not inside !IsPostBack or other conditions. That means, those codes should always be executed during PrepareDataBinding.

Hope this helps,
James.

Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

Michael — Tue, 06 Oct 2009 08:12:19 GMT

Now I set the property on the individual column (in PrepareDataBinding Event), but i get the same error message!

            WebGridColumn Dependencies = grd.RootTable.Columns[0];
            WebGridColumn ID = grd.RootTable.Columns[1];
            WebGridColumn ProductID = grd.RootTable.Columns[2];
            WebGridColumn AttributeID = grd.RootTable.Columns[3];
            WebGridColumn Setpoint = grd.RootTable.Columns[4];
            WebGridColumn Min = grd.RootTable.Columns[5];
            WebGridColumn Max = grd.RootTable.Columns[6];
            WebGridColumn FormatID = grd.RootTable.Columns[7];
            WebGridColumn ValueIndex = grd.RootTable.Columns[8];

            Dependencies.UseValueListForSorting = ValueListSorting.No;
            ID.UseValueListForSorting = ValueListSorting.No;
            ProductID.UseValueListForSorting = ValueListSorting.Yes;
            AttributeID.UseValueListForSorting = ValueListSorting.Yes;
            Setpoint.UseValueListForSorting = ValueListSorting.No;
            Min.UseValueListForSorting = ValueListSorting.No;
            Max.UseValueListForSorting = ValueListSorting.No;
            FormatID.UseValueListForSorting = ValueListSorting.Yes;
            ValueIndex.UseValueListForSorting = ValueListSorting.No;

It's interesting that the data is still inserted into the database!

Michael

Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

Glayaar — Tue, 06 Oct 2009 02:28:53 GMT

We failed to open the Database you attach in the previous post. However, using the setting in the code we are able to replicate the issue in our environment. An issue report has been sent to our developer.

In order to solve this issue, we suggest to set the UseValueListForSorting property on the individual column that has WebValueList. For example in the first sample the code used:

grdObj.RootTable.Columns[1].UseValueListForSorting = ValueListSorting.Yes;
grdObj.RootTable.Columns[2].UseValueListForSorting = ValueListSorting.Yes;

Instead of:

grdObj.RootTable.UseValueListForSorting = ValueListSorting.Yes;

Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

Michael — Fri, 02 Oct 2009 03:53:45 GMT

Hi Glenn

I send you Database-Backup (SQL Server 2008) file and my sample. I hope you can now replicate the issue.

After changing Connectionstring you should be able to run the sample and get the error like my last post.

In Event grdProductLine_PrepareDataBinding you can commenting out following line (samlpe run without error):

grdProductLine.RootTable.UseValueListForSorting = ValueListSorting.Yes;

Thanks for help!

Regards

Michael

Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

Glayaar — Thu, 01 Oct 2009 04:57:37 GMT

Based on the sample created using the scenario you describe, the issue could not be replicated. Feel free to modify the sample in order to replicate the sample.

Possible Bug - Can't add/delete record if UseValueListForSorting=Yes (with grouped columns)

Michael — Wed, 30 Sep 2009 04:41:01 GMT

I have a table with 3 columns:

- ID [GUID] autoincrement

- LineID [GUID] foreignkey

- ProductID [GUID] foreignkey

For columns LineID and ProductID I use ValueLists.

I set UseValueListForSorting = ValueListSorting.Yes because I want to sort by the DataTextField of Valuelist.

If the data are not grouped I can add or delete rows without problems.

But are the data grouped by LineID I get an errormessage like attached picture.

Regards

Michael