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?
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.