Show GridView specific column value from another Table using Entity Framework in ASP.Net

Hi Rezu2215,

Refer below sample.

Database

For this sample I have used of NorthWind database that you can download using the link given below.

Download Northwind Database

HTML

<asp:GridView ID="gvProducts" runat="server" AutoGenerateColumns="false">
    <Columns>
        <asp:BoundField DataField="ProductID" HeaderText="Id" />
        <asp:BoundField DataField="ProductName" HeaderText="Product Name" />
        <asp:TemplateField HeaderText="Category Name">
            <ItemTemplate>
                <asp:Label ID="Label1" Text='<%# GetCategoryName(Convert.ToInt32(Eval("CategoryID")))%>'
                    runat="server" />
            </ItemTemplate>
        </asp:TemplateField>
    </Columns>
</asp:GridView>

Namespaces

C#

using NorthwindModel;

VB.Net

Imports NorthwindModel

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    NorthwindEntities entity = new NorthwindEntities();
    gvProducts.DataSource = entity.Products.Take(10).ToList();
    gvProducts.DataBind();
}

public string GetCategoryName(int categoryID)
{
    NorthwindEntities entity = new NorthwindEntities();
    return entity.Categories.Where(x => x.CategoryID == categoryID).Select(x => x.CategoryName).FirstOrDefault();
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    Dim entity As NorthwindEntities = New NorthwindEntities()
    gvProducts.DataSource = entity.Products.Take(10).ToList()
    gvProducts.DataBind()
End Sub

Public Function GetCategoryName(ByVal categoryID As Integer) As String
    Dim entity As NorthwindEntities = New NorthwindEntities()
    Return entity.Categories.Where(Function(x) x.CategoryID = categoryID).[Select](Function(x) x.CategoryName).FirstOrDefault()
End Function

Screenshot