Intersoft Community - WebGrid Enterprise - WebGrid 7 - Updating Structure Dynamically Works...Almost

WebGrid 7 - Updating Structure Dynamically Works...Almost

handy@intersoftpt.com — Fri, 03 Jun 2011 07:09:29 GMT

Hi Yousif,

We are very sorry. It seems, we lost to track this issue due to the long respond time.
But I do still remember the issue. However, would you mind to forward the previous email include the sample? I lost the sample when my computer got crashed.

Regards,
Handy

WebGrid 7 - Updating Structure Dynamically Works...Almost

PRISMAY — Thu, 02 Jun 2011 09:42:45 GMT

Handy,

Has the dynamic grid feature been added to 2011 R1?

WebGrid 7 - Updating Structure Dynamically Works...Almost

handy@intersoftpt.com — Wed, 04 Nov 2009 06:09:32 GMT

Ok, we have received your mail and will try to replicate the condition. I will let you know asap.

Regards,
Handy

WebGrid 7 - Updating Structure Dynamically Works...Almost

PRISMAY — Tue, 03 Nov 2009 08:43:28 GMT

I'm not sure I understand what you mean by where. Our custom grid class does take IsPostBack into consideration along with other aspects, i.e., if it's a fly post back or a custom property and so on.

I can send you the entire class code, but would like to do that privately since it's proprietary code. I'll send an email to tech support with this thread referenced.

WebGrid 7 - Updating Structure Dynamically Works...Almost

handy@intersoftpt.com — Tue, 03 Nov 2009 00:12:52 GMT

Where did you added a column at your scenario and may i know the validation? It would be great if i could have a simple sample that replicate your issue. I think some condition ISPostBack or !ISPostBack should be affected the working code your have.

Regards,
Handy

WebGrid 7 - Updating Structure Dynamically Works...Almost

PRISMAY — Tue, 27 Oct 2009 09:47:05 GMT

I've attached flash videos to see the problem in action. Hopefully that will make the problem more clear. The sequence is in grid-column-dynamic:

The grid is refreshed as it is with no issues
I then remove the Value column from our database structure for the grid
I refresh the grid and the rows/column correctly go away on the update but the column header stays
I then put restore the column in our database grid definition
I refresh the grid and the rows are back

The grid-column-dynamic-page-refresh sequence shows how it behaves when the column is added. Note in this sequence that it's fine when the page is refreshed.

all columns there first. I remove the Value column and refresh the page. Works great.
now I add the column back and refresh the grid. When it comes back, it's off to the right and no column header.
I refresh the page which works great

WebGrid 7 - Updating Structure Dynamically Works...Almost

PRISMAY — Fri, 23 Oct 2009 18:00:24 GMT

Our custom grid is completely database driven including the formatting. So we do the custom structure work ourselves. We also provide transparent "memory" of the grid as users modify it so it stores the grid structure any time a user modifies it, i.e., groups columns, sorts, resizes, removes or adds columns.

We store the info in XML via the grid's SaveTablesStructureToXml into our database and restore it and load it via LoadTablesStructureFromXml.

When we configure the grid, it's based on the grid definition provided by the database. All the columns are created/updated depending on the grid definition provided.

The problem is to keep what's saved in sync with a changed definition structure. This won't happen all that often, but when it does, we want to update the grid transparently without the user having to reload the page.

It's working, mostly, but I'm not sure what I'm missing and am hoping someone can help. The attached CustomGridInitialLoad image shows the grid when initially loaded. I then added a new column to the configuration in the database. The CustomGridAfterRefreshGridData image shows the grid after I click on "Refresh grid data" which shows the column added in the data rows, but it's missing from the column headers.

If I reload the page (see CustomGridAfterPageRefresh image) everything loads just fine. Essentially what I do in my CompareColumnConfiguration method is to:

Iterate through our grid definition structure
check if a column already exists in the current grid Columns collection
if it doesn't, then add it and format it
Now iterate through the grid's Columns collection
check if the column exists in our grid definition structure
if it doesn't, remove it, e.g., this.Columns.Remove(wgc)

When a column is removed from our definition structure and I refresh the grid via the refresh button or sorting or any action that posts the grid data, then it updates like image CustomGridColDelAfterRefreshGridData which shows the rows for the column are gone, but the header is still there. If I refresh the entire page, it loads fine.

The column still there introduces other problems of course since it'll crash the grid if you try to sort on it or anything related to it since it no longer exists.