<%@ Page Language="C#" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<script runat="server">

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            for (int i = 0; i < 26; i++)
            {
                DropDownList1.Items.Add(i.ToString());
                DropDownList2.Items.Add(i.ToString());
            }
        }
    }
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:EntityDataSource ID="EntityDataSource1" runat="server" ConnectionString="name=SchoolEntities"
            DefaultContainerName="SchoolEntities" EnableFlattening="False" EntitySetName="Person"
            Select="it.[PersonID], it.[LastName], it.[FirstName], it.[HireDate], it.[EnrollmentDate]"
            Where="it.[PersonID] > @IDPerson && it.[PersonID] < @IDPerson1" AutoGenerateOrderByClause="true">
            <WhereParameters>
                <asp:ControlParameter ControlID="DropDownList1" Name="IDPerson" DefaultValue="0"
                    Type="Int32" />
                <asp:ControlParameter ControlID="DropDownList2" Name="IDPerson1" DefaultValue="10"
                    Type="Int32" />
            </WhereParameters>
            <OrderByParameters>
                <asp:ControlParameter ControlID="DropDownList3" DefaultValue="FirstName" Type="String" />
            </OrderByParameters>
        </asp:EntityDataSource>
        Entre
        <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
        </asp:DropDownList>
        E
        <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True">
            <asp:ListItem Text="10" Value="10" />
        </asp:DropDownList>
        &nbsp; Ordenar por:&nbsp; <asp:DropDownList ID="DropDownList3" runat="server" 
            AutoPostBack="True">
            <asp:ListItem Text="PersonID" Value="PersonID" />
            <asp:ListItem Text="FirstName" Value="FirstName" />
            <asp:ListItem Text="LastName" Value="LastName" />
        </asp:DropDownList>
        <br />
        <asp:GridView ID="GridView1" runat="server" DataSourceID="EntityDataSource1">
        </asp:GridView>
    </div>
    </form>
</body>
</html>
