<%@ 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.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:RadComboBox runat="server" ID="RadComboBox1" 
            DataSourceID="SqlDataSource1" DataTextField="CategoryName" 
            DataValueField="CategoryID" AutoPostBack="true">
        </telerik:RadComboBox>
        <telerik:RadComboBox runat="server" ID="RadComboBox2" DataTextField="ProductName" 
            DataValueField="ProductID" DataSourceID="SqlDataSource2" AutoPostBack="true">
        </telerik:RadComboBox>
        
        <asp:SqlDataSource runat="server" ID="SqlDataSource1" 
            ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" 
            SelectCommand="SELECT [CategoryID], [CategoryName] FROM [Categories]">
        </asp:SqlDataSource>
        <asp:SqlDataSource runat="server" ID="SqlDataSource2" 
            ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" 
            SelectCommand="SELECT [ProductID], [ProductName] FROM [Products] WHERE ([CategoryID] = @CategoryID)">
            <SelectParameters>
                <asp:ControlParameter ControlID="RadComboBox1" 
                    Name="CategoryID" PropertyName="SelectedValue" Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>
