Intersoft Community - WebGrid Enterprise - RowState issue when Grouping a Column with UseValueListForSorting set to Yes

RowState issue when Grouping a Column with UseValueListForSorting set to Yes

Glayaar — Mon, 15 Nov 2010 00:08:59 GMT

I have just been updated about this issue, a fix will be available in the next hotfix release.

RowState issue when Grouping a Column with UseValueListForSorting set to Yes

Glayaar — Thu, 05 Aug 2010 00:33:32 GMT

It seemsthe issue is caused by a bug in our WebGrid. A bug report has been submitted to our developer.

In the mean time, you could try using this workaround. The idea is to check whether the row has ny field changed, if there is no change invoke the acceptchanges function to reset the rowstate. Here is the snippet, the snippet is in C#:

void WebGrid1_InitializeRow(object sender, ISNet.WebUI.WebGrid.RowEventArgs e)
{
    if (e.Row.Type == RowType.Record)
    {
        DataRowView dr = (DataRowView)e.Row.DataRow;
        try
        {
            bool identicalRow = true;
            if (dr.Row.RowState == DataRowState.Modified)
            {
                for (int i = 0; i < dr.Row.Table.Columns.Count; i++)
                {
                    if (dr.Row[i, DataRowVersion.Original].ToString() != dr.Row[i, DataRowVersion.Current].ToString())
                    {
                        identicalRow = false;
                        break;
                    }
                }
                if (identicalRow)
                    dr.Row.AcceptChanges();
            }

            e.Row.Cells.GetNamedItem("RowState").Value = dr.Row.RowState.ToString();
            e.Row.Cells.GetNamedItem("RowState").Text = dr.Row.RowState.ToString();
        }
        catch (Exception excp)
        {
            //e.Row.Cells.GetNamedItem("RowState").Value = "ERROR"
            //e.Row.Cells.GetNamedItem("RowState").Text = "ERROR"
        }
    }
}

RowState issue when Grouping a Column with UseValueListForSorting set to Yes

sfrench@sierradata.com — Wed, 04 Aug 2010 20:20:14 GMT

Hello,

We ran into this issue while trying to track down something else. When you load a set of rows using InitializeDataSource they should each start with a RowState of 'Unchanged'. The RowState should stay this way unless is it deleted or modified. We've found that if you group a grid on a column that is using a WebValueList and the setting UseValueListForSorting is set to 'Yes' that EVERY row in the grid will have a RowState of Modified. That means if you do processing of rows on PostBack as we do that EVERY row will be updated. In our case that means getting row/cell values passed to a stored procedure. We probably wouldn't have noticed this except we were getting an error that was totally unrelated to the row we were updating.

I've put together an example that should work if you drop it in the WebGridSamples project.

Load the page in a browser.
I've added a new column that displays the RowState on the far right.
Group by CustomerID which is setup with a ValueList and UseValueListForSorting="Yes".
Open some of the groups and you will see every row has a RowState of "Modified". These should have remained "Unchanged" until the row is updated or deleted.
If you need confirmation this is wrong reload the page and try grouping by Contact Title. The RowStates will remain "Unchanged". Remove UseValueListForSorting="Yes" from the CustomerID column and reload again. The RowStates will not change after grouping by CustomerID.

I did an update today and am running version 7.0.7200.403 but the issue is still there.

Any help would be much appreciated as this is a current issue in our live application. Customers are experiencing adverse results due to this error.

Thanks,
Scott French