I've seen this behavior off and on but could never reproduce it consistently until now. It appears to happen only when using the IdeaBlade DevForce XtraGridBindingManager control to communicate with a database through the IdeaBlade layer. However, the problem does *not* appear to be with IdeaBlade because I can see that the proper data is looked up in memory but it is just not being displayed correctly on the screen.
What I'm trying to do is to display the contents of a master table and one column of a detail table inside one grid. Because a one-to-many relationship exists in the database between the master and the detail tables, that grid column is formatted as a LookupEdit column.
To repro:
- Run the attached script.sql file to create a simple database on a default local instance of SQL Server 2008. This script creates a table Master and a table Details and populates them with the necessary data.
- Build and run the solution. When the application window shows, you will see one or more cells of the Details column in the grid show up empty.
When I tried to reproduce this scenario with XML datasets, the grid worked properly. This seems to suggest that the problem lies with how the XtraGrid control gets its data source bound to the XtraGridBindingManager control.
Hello Steven,
Thank you for your question. I am afraid that we cannot run the project, because some assemblies cannot be resolved. We received the following message:
>> Could not load file or assembly 'IdeaBlade.Verification, Version=3.6.10.0, Culture=neutral, PublicKeyToken=287b5094865421c0' or one of its dependencies. The system cannot find the file specified.
Would you please send us this assembly, so that we can research the problem? We are looking forward to hearing from you.
Thanks,
Uriah.
Added new zip file with this binary
Hello Steven,
I still cannot run the project, as some other assembly is needed.
>>Could not load file or assembly 'IdeaBlade.Persistence.Server, Version=3.6.10.0, Culture=neutral, PublicKeyToken=287b5094865421c0' or one of its dependencies. The system cannot find the file specified.
Thanks,
John.
Updated attached project.
Also, it turns out that it is easier to just create a new database on the default local instance of SQL Server named gridbindingbug by hand and then run the script on it; I couldn't find an easy way of specifying file paths on an unknown machine.
Hi Steven,
Thank you for the attached project. It helped me reproduce this problem. The issue is caused by the fact that GridControl cannot correctly operate complex data types as in case of the Detail class. To operate these data types, I suggest you use unbound columns. If you do not want to use them, I suggest you contact the IdeaBlade support team to resolve this problem.
The
Thanks,
John.
I've tried using an unbound column following the example at http://documentation.devexpress.com/#WindowsForms/CustomDocument1477, but I'm stuck. I can't get the lookup edit control to display the right information or respond to changes. I've attached an updated sample project of what I have. Can someone please show me what I'm missing?
Hi Steven,
I cannot provide an exact answer as I have no experience of working with IdeaBlade components and their data structure. I suggest you contact the IdeaBlade support team to resolve this problem.
Thanks,
John.