Imar:

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?

Thanks,

Robin

Hi there,

If you're using a SqlDataSource, you can specifiy a query for Select that contains an INNER JOIN on the other table. That way, you can retrieve both the ID and Name of the related item. Inserts and Updates would still use the Id, coming from the DropDownList.

Hope this helps,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!