<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="Telerik.Web.UI"  Namespace="Telerik.Web.UI" TagPrefix="telerik"%>
<%@ Register assembly="System.Web.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" namespace="System.Web.UI.WebControls" tagprefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <asp:ScriptManager runat="server" ID="ScriptManager1"></asp:ScriptManager>
    <div>
    
        <telerik:RadGrid runat="server" ID="RadGrid1" AllowPaging="True" 
            AllowSorting="True" AutoGenerateEditColumn="True" 
            DataSourceID="EntityDataSource1" GridLines="None" Skin="Telerik"
            AutoGenerateColumns="false" AllowAutomaticUpdates="true">
            <MasterTableView AutoGenerateColumns="False" DataKeyNames="OrderID" 
                            DataSourceID="EntityDataSource1" >
                <Columns>               
                    <telerik:GridBoundColumn DataField="OrderID" DataType="System.Int32" 
                        HeaderText="OrderID" ReadOnly="True" SortExpression="OrderID" 
                        UniqueName="OrderID">
                    </telerik:GridBoundColumn>                   
                    <telerik:GridBoundColumn DataField="ShipAddress" HeaderText="ShipAddress" 
                        SortExpression="ShipAddress" UniqueName="ShipAddress">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ShipCity" HeaderText="ShipCity" 
                        SortExpression="ShipCity" UniqueName="ShipCity">
                    </telerik:GridBoundColumn>                                                       
                    <telerik:GridDropDownColumn DataField="Employees.EmployeeID" 
                        ListTextField="FullName" 
                        ListValueField="EmployeeID" HeaderText="Employees" 
                        UniqueName="Employees" DataSourceID="EntityDataSource2">
                    </telerik:GridDropDownColumn>
                    
                </Columns>
            </MasterTableView>
        </telerik:RadGrid>
    
        <asp:EntityDataSource ID="EntityDataSource1" runat="server" 
            ConnectionString="name=NorthwindEntities" 
            DefaultContainerName="NorthwindEntities" EnableDelete="True" 
            EnableInsert="True" EnableUpdate="True" EntitySetName="Orders">
        </asp:EntityDataSource>
        
        <asp:EntityDataSource ID="EntityDataSource2" runat="server" 
            ConnectionString="name=NorthwindEntities" 
            DefaultContainerName="NorthwindEntities"
            EntitySetName="Employees" 
            Select="it.[EmployeeID], (it.[LastName] + ' ' + it.[FirstName]) as FullName">
        </asp:EntityDataSource>
                
    
    </div>
    </form>
</body>
</html>
