Best Practice for handling the display of foreign key relationships in a Listview
What is your recommendation for the best way to display the text-equivalent value of a foreign key field in a databound Listview (or any tabular presentation). I am using a DropDownList in the Edit and Insert templates but it really bloats the HTML if you use a DropDownList in the Item and AlternatingItem templates. I could use a View but that means writing Stored Procedures for each Insert, Update & Delete. A data-bindable label or textbox would be perfect - provide it with the key value and it would display the text value. Other than that - how do handle these situations?