ASP.NET 2.0 (C#)
LLBL Gen Pro 2
Oracle 10g
Hi guys, I am facing a problem at sorting my LLBLProDataSource that is bound to a Gridview. The problem only occur when I am having a column that is a foreign key to another table:
e.g.
User (ID, Name, CountryCode)
Country(CountryCode, CountryName)
My UserCollection consists of the ID, Name and CountryCode attribute. But I would like to display the CountryName to the system user, hence i included it using partial class that returns the CountryName based on the CountryCode.
When i had done this, I can display the CountryName successfully inside the gridview, but when I try to use the built in sorting for GridView, I am having problems sorting it correctly, can anyone help?
Thanks
yj
