Sorting

[Heath Brand]

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

[Administrator]

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.