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

<%@ Register TagPrefix="telerik" Namespace="Telerik.Web.UI" Assembly="Telerik.Web.UI" %>
<!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">
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        <Scripts>
            <asp:ScriptReference Assembly="Telerik.Web.UI" 
                Name="Telerik.Web.UI.Common.Core.js">
            </asp:ScriptReference>
            <asp:ScriptReference Assembly="Telerik.Web.UI" 
                Name="Telerik.Web.UI.Common.jQuery.js">
            </asp:ScriptReference>
            <asp:ScriptReference Assembly="Telerik.Web.UI" 
                Name="Telerik.Web.UI.Common.jQueryInclude.js">
            </asp:ScriptReference>
        </Scripts>
    </telerik:RadScriptManager>
    <div>
        <telerik:RadGrid ID="RadGrid1" GridLines="None" runat="server" AllowAutomaticDeletes="True"
            DataSourceID="SqlDataSource1" Culture="bg-BG" AllowAutomaticInserts="True" AllowPaging="True"
            AutoGenerateColumns="False" PageSize="5" CellSpacing="0" ShowGroupPanel="True"
            Width="600px" AllowMultiRowSelection="True" AutoGenerateEditColumn="True">
            <PagerStyle Mode="NextPrevAndNumeric" />
            <MasterTableView Width="800px" CommandItemDisplay="Top" AllowFilteringByColumn="true"
                EnableHeaderContextMenu="true" Height="100%" ShowFooter="true" DataSourceID="SqlDataSource1"
                AllowSorting="true" EnableLinqGrouping="false" HorizontalAlign="NotSet" AutoGenerateColumns="False"
                EditMode="EditForms" DataKeyNames="CustomerID">
                <CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
                <RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
                </RowIndicatorColumn>
                <CommandItemSettings ShowExportToPdfButton="true" />
                <ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
                </ExpandCollapseColumn>
                <NestedViewTemplate>
                    <asp:Button ID="Button1" Text="text" runat="server" />>
                </NestedViewTemplate>
                <CommandItemSettings ExportToExcelText="Some Text" ShowExportToExcelButton="true" />
                <Columns>
                    <telerik:GridBoundColumn DataField="CustomerID" FilterControlAltText="Filter CustomerID column"
                        HeaderText="CustomerID" ReadOnly="True" SortExpression="CustomerID" UniqueName="CustomerID">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="CompanyName" FilterControlAltText="Filter CompanyName column"
                        HeaderText="CompanyName" SortExpression="CompanyName" UniqueName="CompanyName">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ContactName" FilterControlAltText="Filter ContactName column"
                        HeaderText="ContactName" SortExpression="ContactName" UniqueName="ContactName">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="ContactTitle" FilterControlAltText="Filter ContactTitle column"
                        HeaderText="ContactTitle" SortExpression="ContactTitle" UniqueName="ContactTitle">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="Address" FilterControlAltText="Filter Address column"
                        HeaderText="Address" SortExpression="Address" UniqueName="Address">
                    </telerik:GridBoundColumn>
                    <telerik:GridBoundColumn DataField="City" FilterControlAltText="Filter City column"
                        HeaderText="City" SortExpression="City" UniqueName="City">
                    </telerik:GridBoundColumn>
                    <telerik:GridButtonColumn UniqueName="ButtonColumn1" ConfirmDialogType="RadWindow"
                        ConfirmText="Are you sure?" Text="Button">
                    </telerik:GridButtonColumn>
                    <telerik:GridNumericColumn FilterControlWidth="75px" DataField="CustomerID" HeaderText="Hectares"
                        NumericType="Number" DataType="System.Decimal" DecimalDigits="1" AllowRounding="true"
                        DataFormatString="{0:N1}">
                        <ItemStyle HorizontalAlign="Right" />
                    </telerik:GridNumericColumn>
                </Columns>
                <CommandItemSettings ShowExportToCsvButton="true" />
                <EditFormSettings>
                    <EditColumn FilterControlAltText="Filter EditCommandColumn column">
                    </EditColumn>
                </EditFormSettings>
            </MasterTableView>
            <FilterMenu EnableImageSprites="False">
            </FilterMenu>
            <ClientSettings AllowColumnsReorder="True">
                <Selecting AllowRowSelect="True" EnableDragToSelectRows="true" />
                <Scrolling AllowScroll="false" UseStaticHeaders="false" />
            </ClientSettings>
        </telerik:RadGrid>
        s
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" SelectCommand="SELECT [CustomerID], [CompanyName], [ContactName], [ContactTitle], [Address], [City] FROM [Customers]"
            OldValuesParameterFormatString="original_{0}"></asp:SqlDataSource>
    </div>
    </div>
    </form>
</body>
</html>
