Sorting

Hi, I''m binding a GGC to a DataTable populated with the following query: select * from products order by productname; However, the rows in the GGC are not ordered by productname but by productid. I found out that this is being caused by the following line of code: adapter.MissingSchemaAction = MissingSchemaAction.AddWithKey; which will result in the ProductId column being added as a primary key entry in the TableDescriptor. I was wondering if there is a way to avoid the sorting by primary key? Heath

Hi Heath, This issue is now corrected in our codebase and it''ll be available in the next build. In the meantime, you can call the following method to solve this issue. this.gridGroupingControl1.TableDescriptor.PrimaryKeyColumns.Clear(); Best Regards, Leo.