I will do my best to explain this senario.
I am using an UltraGrid to display data of which I will have no knowedge of at run time. I am parsing an xml file that will create a list of queries and their relations.
when I run through this squence of events the child bands do not display. Is it possible to add child data to the UltraGrid and display it? Am I doing this out of order somehow? Does the data have to be there before the expand event fires? Can I get any alternate suggestions? My biggest problem seems to be that Data is completely dynamic.
What I am doing now is changing the casing of the values as I read them from the datareader. Thanks for all your help. I need to see a working copy of the code so that I know I was not going crazy. It took me hours to try to break your code so I can see what was so different in what we where doing. Turned out to be a data issue.
Thanks again.
I don't believe that you can control whether the relation names are case-sensitive or not; I think that this is mainly due to how the .NET BindingManager works as opposed to the grid. Is there any way for your child table to update the case of its GUID values? I'm not sure what you mean by "...update the data as I am saving it...", unless you mean to convert the GUID at this point, which seems like it would work to me.
-Matt
I found my issue. It is case sensitive when looking for relations values. The parent GUID, 1A6717C4-93BF-4317-95CD-71153904010E, uses capital letters and my child table was using lower case letters 1a6717c4-93bf-4317-95cd-71153904010e.
Can I turn that off or should I update the data as I am saving it to the child table?
It's possible that something was fixed past the 9.1 release that affects this functionality. If you can post a sample project here that I can run, I'd be happy to see if it works in the latest version, or you could submit it to Developer Support so that they can look at it.
Yes, this almost look like my code, but I am still not showing the child data. I have checked the datasource while debugging and the updates are there in the table. Plus the child band reflects the changes to the columns, but when I check the cells in the row of the child band, its value is null.
I am already using the 2009.1 trial addition.