Hey Mike,

Just getting my properties mixed up I suppose. I meant DataMember, which I still don't understand how that is meant to work. I changed this to ValueMember and all is well. After viewing the Call Stack and noticing that the system was trying to convert the string to an integer this became quite apparent.

Anyway, thank you so much for your help. It has been invaluable as always.

See ya next time I get a headache.

Cheers. 

Hi,

If you are seeing the DataValue instead of the DisplayMember, then this usually indicates a problem with the DataTypes.

You have to make sure that the values in the ValueMember column of the dropdown are the same DataType as the values in the grid cells.

rzabransky said:

with the UltraCombo set as the EditorComponent of a column

This is not a problem and should work, but it's not the most efficient way to provide a dropdown list in a cell. Unless you are using multi-select, or EditorButtons, or a DataFilter you are better off using the UltraDropDown control as the ValueList of the column.

But since you are assigning an EditorComponent to the column, make sure you are not also assigning a ValueList to the same column. That could also cause a problem like you describe.

Hey Mike,

Thanks for the information. It is quite useful. I have rechecked my properties and found no ILists. I did find a few properties which may be suspects, such as one band containing two IBindingLists (where an Inventory can have both Clients and Tickets). Alternatively I have an UltraGridRow property so that my ListObjects point back to their row. I'm not sure if these are cause for concern, since I haven't tested them.

I decided it best to remove the IBindingList from my UltraCombo because you mentioned the exception may be caused by the child data already being in a relationship (which I believe it is). This resolved numerous exceptions that were causing performance hits on the program.

Instead, I am now binding my UltraCombo to a simpler DataTable. However, I am still having problems with the DataValue/DisplayMember not being displayed properly. It seems I still cannot change the value of the column through the drop down or other means, and when forcing a commit on the cell the display text is removed and the data value is shown.

As such: The Data Value ex) 5 is always shown over the display member ex) RZabransky. When switching to RZabransky2 the data value will remain at 5. 

I have never seen this behaviour before, and frankly I'm at a loss as to how this could happen. Additional information which may or may not be relevant is that the UltraGrid is displayed in a dialog with the UltraCombo set as the EditorComponent of a column. When attempting to change the value of that column their are numerous FormatExceptions, which are actually typical when using ShowDialog() so I didn't pay much attention to them.

Thanks again.

Hi,

Okay, this call stack indicates that the exception is occurring when you set the DataSource property on an UltraGridBase. So this could be an UltraGrid, UltraCombo, or UltraDropDown. I think you are saying it's an UltraCombo.Is that right?

The actual exception is occurring when the CurrencyManager in DotNet is trying to add a new row to the data source. This is not something the grid does. It happens when the grid asks the CurrencyManager for the data structure so that it can create the columns and bands to display the data. When the CurrencyManager encounter a field in the root table that should be represented as a list, it tries to get the data structure of the child data. If it cannot get it from the property type, what it does is it tries to add a new row to the child rows collection of the first parent row. It then uses the child row to determine the structure and then cancels it.

So my guess is that you are binding the combo to a hierarchical data source and one of the fields in the data source is an IList and not an IBindingList. I know you said that this is not the case, but it's the only way I know of that you get that exception. Perhaps there is some other reason that it is happening in this particular case - maybe there is some other type that causes the same Exception. 

I recommend that you examine the fields in the data source you are using for the combo very carefully and make absolutely sure that there are no public properties which return a type which implements IList and not IBindingList.

Another possibility is that the data you are binding to is already a set of child data in a relationship. In fact, judging by the DataMember you are using here (Inventories.Clients.Tickets) that looks like it may be the case. In that case, if there is currently no data in the table, the same thing will happen - the UltraCombo will be unable to determine the data structure without adding a row. And it may be that the CurrencyManager cannot create a new row in this case, because it doesn't have enough context in terms of the parents rows.

Another thing you might want to try, just as a test, is to bind the same DataSource to some other controls. For example, you could bind an UltraWinGrid, a DataGridView, or ComboBox to the same data, just to see what happens. I expect you will get the same exception in all cases.