Is there a way to add the value from a navigation key on a DataGrid column that is bound to a field from it's Entity container field. This sounds hard to describe!
I have a field that holds a weight, same table has a referenced table for types of weight i.e. lbs, kgs, etc... So I want the column to show 6kg instead of 6.
My first idea:
<asp:BoundColumn DataField="Weight" DataFormatString="{0:<%# Eval("WeightType.WeightType") %>}" HeaderText="Weight ></asp:BoundColumn>
I know illegal as all get out, so is there a way to concatenate this?