Columns of two related database tables in one ASP.NET GridView with EntityDataSource

by

OK, much too many hours later I found the solution myself:

Option 1:

It is possible to use the select property in the EntityDataSource which allows to create arbitrary projections of data from several related entities/database tables (in my case: OrderID from Order entity and City from the
Address entity)

Drawback: Using select in the EntityDataSource makes using Insert, Update and Delete in the GridView impossible!

Option 2:

The EntityDataSource must have the include property to include the related address property along with the queried orders. The markup looks likes this:

<asp:EntityDataSource ID="EntityDataSourceOrders" runat="server" 
    ConnectionString="name=MyEntitiesContext" 
    DefaultContainerName="MyEntitiesContext" 
    EntitySetName="Order" Include="Address"
    EnableDelete="True" EnableInsert="True" 
    EnableUpdate="True">
</asp:EntityDataSource>

Then the columns collection of the GridView can have a template field like this:

<asp:TemplateField HeaderText="City" >
  <ItemTemplate>
    <asp:Label ID="LabelCity" runat="server" Text="<%# Eval("Address.City") %>">
    </asp:Label>
  </ItemTemplate>
</asp:TemplateField>

Here Eval is important. Bind does not work. Also using a BoundField as a column…

<asp:BoundField DataField="Address.City" HeaderText="City" />

… is NOT possible. So it is not possible in the GridView to edit the City (which makes sense because its a related field belonging to another table and perhaps to many other orders). But it is possible to edit flat fields of the order entity and also the “AddressID” of the order to assign another address.

More Related Contents:

  1. GridView sorting: SortDirection always Ascending
  2. sorting and paging with gridview asp.net
  3. Prevent HTML encoding in auto-generated GridView columns
  4. GridView – Show headers on empty data source
  5. How to delete a row from GridView?
  6. Paging & Sorting grids with ASP.Net MVC
  7. Get DataKey values in GridView RowCommand
  8. How to get the cell value by column name not by index in GridView in asp.net
  9. how to bind a dropdownlist in gridview?
  10. How to hide columns in an ASP.NET GridView with auto-generated columns?
  11. Export GridView to multiple Excel sheet
  12. Conditionally hide CommandField or ButtonField in Gridview
  13. Implement JQuery Datatable in ASP.NET GridView
  14. Gridview row editing – dynamic binding to a DropDownList
  15. Server.MapPath(“.”), Server.MapPath(“~”), Server.MapPath(@”\”), Server.MapPath(“/”). What is the difference?
  16. What should I do if the current ASP.NET session is null?
  17. How to get the current logged in user ID in ASP.NET Core?
  18. How do you clear your Visual Studio cache on Windows Vista?
  19. Uploading Files in ASP.net without using the FileUpload server control
  20. HTTPModule Event Execution Order?
  21. How do you globally set the date format in ASP.NET?
  22. ASP.NET Temporary files cleanup
  23. SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified [closed]
  24. NuGet: ‘X’ already has a dependency defined for ‘Y’
  25. How to add ASP.NET MVC5 Identity Authentication to existing database
  26. Script not served by static file handler on IIS7.5
  27. Asp.net – Add blank item at top of dropdownlist
  28. WCF Service with SignalR
  29. ASP.NET Return image from .aspx link
  30. Is using a singleton for the connection a good idea in ASP.NET website

Leave a Comment