How to access referenced table from ASPX in-line code (datagridview control)

Question

i am trying to bind data to a datagridview control on an ASPX webpage and am using something like this..

<asp:TemplateField HeaderText="MyField">
    <ItemTemplate>
        <%# DataBinder.Eval(Container.DataItem, "MyField") %>
    </ItemTemplate>
</asp:TemplateField>

the problem i am having is that the data for the 'MyField' field is actually an integer that is a reference to a string value in another sql table.

Does anyone know how i can reformat my code line above to show the string value instead of the int value?

Answer 1

You need to change your SQL query to return the string using a JOIN.