<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default2.aspx.vb" Inherits="Default2" %>

<%@ Register Assembly="Telerik.Web.UI" Namespace="Telerik.Web.UI" TagPrefix="telerik" %>
<!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">
    <div>
        <asp:ScriptManager ID="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <telerik:RadGrid ID="RadGrid1" runat="server" AllowMultiRowEdit="true" AllowSorting="true"
            DataSourceID="AccessDataSource1" AllowPaging="true" AllowMultiRowSelection="true">
            <MasterTableView DataKeyNames="OrderID" Name="Orders">
                <DetailTables>
                    <telerik:GridTableView PageSize="2" TableLayout="Fixed" PagerStyle-AlwaysVisible="true"
                        PagerStyle-Mode="NextPrevAndNumeric" DataKeyNames="OrderID" DataSourceID="AccessDataSource2"
                        Name="Orders">
                        <ParentTableRelation>
                            <telerik:GridRelationFields DetailKeyField="OrderID" MasterKeyField="OrderID" />
                        </ParentTableRelation>
                    </telerik:GridTableView>
                </DetailTables>
            </MasterTableView>
            <ClientSettings>
                <Selecting AllowRowSelect="true" EnableDragToSelectRows="true" />
            </ClientSettings>
        </telerik:RadGrid>
        <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/Nwind.mdb"
            SelectCommand="SELECT Top 10 OrderID, OrderDate, ShipVia FROM Orders" />
        <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/Nwind.mdb"
            SelectCommand="SELECT * FROM [Order Details] Where OrderID = ?">
            <SelectParameters>
                <asp:Parameter Name="OrderID" Type="string" />
            </SelectParameters>
        </asp:AccessDataSource>
    </div>
    </form>
</body>
</html>
