Hi,
I have used ADO.NET Entity Data Model which has generated an .EDMX file automatically, therefore I didn't write any SQL. This scaffolding automatically resolves PK/FK relationships and substitutes the IDs/PK of parent table with another more descriptive column. In my case, when I view the Orders (child) table, it shows me the FirstName field from Customers (parent) table instead of the PK which is CustomerID.
Now I would like to see the full name of a customer instead of the FirstName. I have seen some posts which describe how to do it using a Literal control but I want to know how do we populate dropdown lists. In ForeignKey_Edit.acsx.cs, a method PopulateListControl() is called on Page Load event which is probably doing all the stuff I am after but I cant find a way to override it. Or may be there is another way to do this.
Please help me
Many thanks