Hi there
I have a problem with Ultragrid whereby it's losing the column layouts I set at design-time when the app is run. I'm getting this in several places in my app and it seems to occur at random, the grids are working fine, then they just lose their settings, even when that part of the app hasn't been worked on.
I've had a good read through what's been posted previously on this, and I understand that this is probably due to the runtime datasource not matching what was set at design-time. I can't really understand how this would be the case as the full column list displayed at design-time matches up the columns shown at runtime.
My questions are;
E.g.
Parent object is a CustomerClass, and CustomerClass has a child collection of CustomerClass.OrdersList.
The form is bound to the CustomerBindingSource, which has a datasource of CustomerClass
the grid on the form is bound to a OrdersBindingSource, which has a datasource of CustomerClass and a datamember of "OrdersList".
Any help in getting to the bottom of this would be much appreciated, it is driving me nuts!
tom_redox said:How do I check that this is the case - i.e. what's the bet way to debug this. I take it the grid doesn't throw an exception to say the datasource didn't match up with the layout?
There's no way to trap for this. But if there were, I'm not sure I see how that would help.
tom_redox said:What are the possible causes of this - how does the grid decide whether the datasource has changed? Is it just looking for matching field names and datatypes or is there more to it than that?
I don't think the grid looks at the data types of the field. It looks at the columns (number of columns and the keys of the columns) and also the bands (number and keys). The most common problem I encounter is that people get the keys of the bands wrong. The key isn't always what you think it is. For example, when using a DataSet, the key of the child band is the name of the relationship, not the child table.
tom_redox said:What's the best practice for setting up the bindingsources for grids? Currently I have a bindingsource for the form which has a child list property that is displayed in the grid. The grid is bound to a second bindingsouce which has its datasource set the form's datasource and the datamember set to the child list property. At runtime all I do is then set the parent bindingsource's datasource to an instance of the class. Does that sound right?
I'm not sure I follow you there. If you want to set up the layout of the grid at design-time, then there are really two ways to do it:
Personally, I have found that the BindingManager in DotNet is a bit quirky and sometimes sends reset notifications at unexpected times. So I prefer to set up my layouts at run-time in the InitializeLayout event of the grid. That way, there is never any chance of losing it.
Another way to do it is to set up the layout at design-time and save it using the layout wizard. You can store the layout to a file or into the grid's Layouts collection, then load it at run-time.
Hi Mike
Thanks for your detailed response. I should have made it clearer in my initial message that the grid is bound to a collection object (specifically a csla collection implementing all the MS binding interfaces).
Mike Saltzman"] There's no way to trap for this. But if there were, I'm not sure I see how that would help.
My thinking was that it would be easier to find the issue if the grid threw a message along the lines of "Key "CustomerID was not found, grid layout reset" - this would then give me a start on working out where the problem lay.
Mike Saltzman"] I don't think the grid looks at the data types of the field. It looks at the columns (number of columns and the keys of the columns) and also the bands (number and keys). The most common problem I encounter is that people get the keys of the bands wrong. The key isn't always what you think it is. For example, when using a DataSet, the key of the child band is the name of the relationship, not the child table.
That's interesting to know. Our grids are based on custom collection classes, how do the keys for the bands work for these?
A couple of other question on this, do keys need to be unique for columns across bands. E.g. if the Customer (Band 0) has a Date Entered field and so does the child OrdersList collection (Band 1), would that cause an issue?
Also, we use the System.ComponentModel DisplayName attribute on our classes to set a friendly name for each property of the class. This is then used by the grid to set the column headings. Do these values play any role when assessing whether the runtime and designtime schemas match and are duplicates in these column headings an issue?
Mike Saltzman"] Personally, I have found that the BindingManager in DotNet is a bit quirky and sometimes sends reset notifications at unexpected times. So I prefer to set up my layouts at run-time in the InitializeLayout event of the grid. That way, there is never any chance of losing it.
Ouch.. so effectively that means setting the key, column header text plus any formatting, plus any custom editors and the displaystyle etc for every column manually in code?
I guess I could cut and paste this from the auto-generated designer code after the first setup of the grid?
tom_redox said:My thinking was that it would be easier to find the issue if the grid threw a message along the lines of "Key "CustomerID was not found, grid layout reset" - this would then give me a start on working out where the problem lay.
Ah, yes, I see your point. I was thinking in terms of trying to fix it in an event. But yes, if you could trap when it happens, it might help us narrow it down and avoid / fix the issue.
Unfortunately, there is no such notification.
tom_redox said:That's interesting to know. Our grids are based on custom collection classes, how do the keys for the bands work for these?
That depends entirely on the BindingManager and the classes themselves. Any time I am unsure what the key of the bands will be, what I do is simply bind a new grid to the data source at run-time, loop through the Bands collection, and display the keys.
tom_redox said:A couple of other question on this, do keys need to be unique for columns across bands. E.g. if the Customer (Band 0) has a Date Entered field and so does the child OrdersList collection (Band 1), would that cause an issue?
No, you can have a column with the same key in different bands and that is no problem.
tom_redox said:Also, we use the System.ComponentModel DisplayName attribute on our classes to set a friendly name for each property of the class. This is then used by the grid to set the column headings. Do these values play any role when assessing whether the runtime and designtime schemas match and are duplicates in these column headings an issue?
No, this only affects the display, it is not used in anything relating to structure.
tom_redox said: Ouch.. so effectively that means setting the key, column header text plus any formatting, plus any custom editors and the displaystyle etc for every column manually in code? I guess I could cut and paste this from the auto-generated designer code after the first setup of the grid?
You can't set the Key. The key comes from the data source. And the DisplayName field will automatically get picked up from the DataSource as well and applied to the column header.
Customer editors, display styles, formatting, column size and positions, etc. are the things you would need to set up. But you only need to write the code once and you will never lose your layout again - barring a hard drive crash or something like that. :)
That's great info, many thanks.
Since writing the last post I have discovered something decidedly odd: When I start VS I get the problem with the grid not retaining it's layout at runtime, and now VS cheerfully announces that it cant find the collection name in the binding source - this would explain why it is resetting the grid.
If I stick a breakpoint in the autogenerated code, then run the code, hit the breakpoint, then carry on I get no more problems, it all works as expected and the layout is retained.
Sounds like a timing issue to me? My GUI is in a different assembly to the classes the GUI is bound to, so I'm wondering if there is an issue there somewhere, not necessarily an IG issue, maybe just a problem with the assemblies registering in time.
I'm also now getting a memory leak somewhere, devenv.exe hit 600mb before all the IG controls announced they couldn't paint.
Something very weird is afoot here..! The problem is with the both the IG and .Net Controls code being blackboxes, and neither reporting exceptions, I'm absolutely blind on what can be happening.
Hi Tom,
I'm afraid you lost me with that last post. You are starting VS and then getting an error at run-time? And you weren't getting this error before?
If a breakpoint is fixing it, somehow, then I would agree it sounds like a timing issue, but I can't even begin to guess what the issue might be without seeing a sample in action so I could debug it.
Also, I'm not sure that just because the memory usage is going up that there's a leak. There's only a leak if it doesn't go back down again when you close VS. Or if it continues to go up when you repeat the same actions.
Thanks for all your help and patience on this one. We just installed 9.2 and suddenly all our issues seem to have (fingers crossed) sorted themselves out. Grids that weren't working are now displaying correctly.
I'm sure you won't remember, but we had issues with ICancelAddNew and IEditableObject previously which have been fixed in this version, I'm wondering if somehow these changes have something to do with it.
Anyway, for the time being the issue seems sorted [:)]
I do remember. And I'm glad it's all working now. :)
Hello Tatjana,
Looking at the attached screenshots, I see that the issue exist only into your child band, so maybe one possible reason for this issue, could be the relation between parent and child tables, but without more details about both machines and your scenario will be very difficult to find the issue. Please send us more details and I`ll be glad to help you.
Regards
It never worked consistently for us, so we completely abandoned the designer and wrote some helper classes that hide all the columns and bands in the grid. We then have methods that allow us to quickly turn on the bands we want and to show columns by passing in the field name and to optionally set lots of other regularly used column properties (caption, width, style, ultra drop down etc).
It's a pain to do initially, but in the end I think it's faster than setting the properties via the designer and it is completely consistent. I'd recommend that approach over wasting time with the designer which doesn't provide sufficient information to allow you to debug why values aren't retained.
Was this ever resolved?
I have just posted same problem [http://ko.infragistics.com/community/forums/p/85323/425787.aspx#425787] when I found this thread. I am wondering if there was any solution found?
I am weighing to reinforce that there is a major issue with the ultragrid, combo and udd layouts getting lost. I am running VS 2005 and Infragistics Netadvantage 2010.3 WinForms. I reported this problem back as early as Netadvantage 2008. Here is my latest assessment of what is happening. In my instance the layout is not 'getting' lost at run time, it is not getting saved at design time. Mike, referring to your remark in this thread from 09/09/2009 - 'Personally, I have found that the BindingManager in DotNet is a bit quirky and sometimes sends reset notifications at unexpected times. So I prefer to set up my layouts at run-time in the InitializeLayout event of the grid. That way, there is never any chance of losing it.'. You may very well be right, something is sending a reset notification to the grid layout before it gets saved. I have been dealing with this problem for many years and recently it began to get worse. I would be working in design mode on a form which has many ultragrids, ultracombos and Ultradropdowns, run a debug and every grid, combo etc layout looked fine. I then configured the application for a release build and ran the build. Then ran the release executable where upon several of the grids, combos and dropdowns layouts were lost. Then I go back into design mode and sure enough the layouts were gone again. Even though I protect myself by saving every layout, it is extremely tedious and time consuming to have to restore the layout for each and every grid, combo, dropdown. Since I have concluded that the problem is occurring during the save of the form/project, here are the steps I have taken to try to mitigate the problem. I have turned off ALL autosave features of the Visual Studion environment. I make sure I close all forms before doing a switch of configuration to release build. I just started employing these steps a few days ago, so I can not attest that they have eliminated the problem, I merely offer them to anyone else encountering this issue. I apologize for the length of this but not for the necessity of expressing it. This is more than frustrating - We just released this application into production in August and making necessary updates has become a nightmare of not knowing if a grid layout has been reset.
Hi,
wrlucas said: Hmmm. Because this wasn't really resolved in the product, I am experiencing the same problem. I can reset the all the settings on a grid, run in debug mode and see the changes were in fact saved and implemented. I can see the grid after running the application and see that the formatting was lost. I am using version 10.3.20103.1000 of the ultragrid for windows. Setting all these settings at runtime might be a work around but it is not a fix.
Hmmm. Because this wasn't really resolved in the product, I am experiencing the same problem. I can reset the all the settings on a grid, run in debug mode and see the changes were in fact saved and implemented. I can see the grid after running the application and see that the formatting was lost.
I am using version 10.3.20103.1000 of the ultragrid for windows.
Setting all these settings at runtime might be a work around but it is not a fix.
I'm afraid I do not understand what you are asking here. If you are resetting all the settings on the grid, then what settings are you talking about saving?
If you are trying to set up your grid layout at design-time and keep that layout at run-time, you must make sure that the data structure you set up at design-time matches the run-time data structure exactly. This means that all of the band and column keys must be exactly the same.
You must also use the SetDataBinding method of the grid instead of setting the DataSource and/or DataMember propeties on the grid at run-time.