<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server" />
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            SelectCommand="SELECT [EmployeeID], [LastName], [FirstName], [City], [Title] FROM [Employees]">
        </asp:SqlDataSource>
    </div>
    <telerik:RadGrid ID="RadGrid1" runat="server" DataSourceID="SqlDataSource1" GridLines="None"
        OnCreateColumnEditor="RadGrid1_CreateColumnEditor">
        <MasterTableView AutoGenerateColumns="False" CellSpacing="-1" DataKeyNames="EmployeeID"
            DataSourceID="SqlDataSource1">

            <Columns>
                <telerik:GridEditCommandColumn>
                </telerik:GridEditCommandColumn>
                <telerik:GridBoundColumn DataField="EmployeeID" DataType="System.Int32" HeaderText="EmployeeID"
                    ReadOnly="True" SortExpression="EmployeeID" UniqueName="EmployeeID">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="LastName" HeaderText="LastName" SortExpression="LastName"
                    UniqueName="LastName">
                </telerik:GridBoundColumn>
                <telerik:GridBoundColumn DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName"
                    UniqueName="FirstName">
                </telerik:GridBoundColumn>
                <telerik:GridDropDownColumn DataField="City" HeaderText="City" SortExpression="City"
                    EnableEmptyListItem="true" DataSourceID="SqlDataSource1" ListTextField="City"
                    ListValueField="City" UniqueName="City">
                </telerik:GridDropDownColumn>
                <telerik:GridHyperLinkColumn DataNavigateUrlFields="Title" DataTextField="Title"
                    HeaderText="Job Title" UniqueName="JobFileHyperLink" Target="_blank" DataNavigateUrlFormatString="~/default.aspx?Title={0}">
                </telerik:GridHyperLinkColumn>
            </Columns>
        </MasterTableView>
    </telerik:RadGrid>
    </form>
</body>
</html>
