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

<!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>
    <telerik:RadStyleSheetManager ID="RadStyleSheetManager1" runat="server" />
</head>
<body>
    <form id="form1" runat="server">
    <telerik:RadScriptManager ID="RadScriptManager1" runat="server">
        <Scripts>
            <%--Needed for JavaScript IntelliSense in VS2010--%>
            <%--For VS2008 replace RadScriptManager with ScriptManager--%>
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.Core.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQuery.js" />
            <asp:ScriptReference Assembly="Telerik.Web.UI" Name="Telerik.Web.UI.Common.jQueryInclude.js" />
        </Scripts>
    </telerik:RadScriptManager>

    <script type="text/javascript">
		//Put your Java Script code here.
    </script>

    <telerik:RadAjaxManager ID="RadAjaxManager1" runat="server">
    </telerik:RadAjaxManager>
    <div>
        <telerik:RadGrid runat="server" AllowAutomaticUpdates="true" AutoGenerateEditColumn="true" ID="RadGrid1" AllowAutomaticInserts="true"  DataSourceID="SqlDataSource1">
<MasterTableView AutoGenerateColumns="False" CommandItemDisplay="Top" DataKeyNames="OrderID" 
                DataSourceID="SqlDataSource1">
<RowIndicatorColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</RowIndicatorColumn>

<ExpandCollapseColumn>
<HeaderStyle Width="20px"></HeaderStyle>
</ExpandCollapseColumn>
    <Columns>
        <telerik:GridBoundColumn DataField="OrderID" DataType="System.Int32" 
            HeaderText="OrderID" ReadOnly="True" SortExpression="OrderID" 
            UniqueName="OrderID">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="CustomerID" HeaderText="CustomerID" 
            SortExpression="CustomerID" UniqueName="CustomerID">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="EmployeeID" DataType="System.Int32" 
            HeaderText="EmployeeID" SortExpression="EmployeeID" UniqueName="EmployeeID">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="OrderDate" DataType="System.DateTime" 
            HeaderText="OrderDate" SortExpression="OrderDate" UniqueName="OrderDate">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="RequiredDate" DataType="System.DateTime" 
            HeaderText="RequiredDate" SortExpression="RequiredDate" 
            UniqueName="RequiredDate">
        </telerik:GridBoundColumn>
        <telerik:GridDateTimeColumn DataField="ShippedDate" DataType="System.DateTime" 
            HeaderText="ShippedDate" SortExpression="ShippedDate" UniqueName="ShippedDate"></telerik:GridDateTimeColumn>
       <%-- <telerik:GridBoundColumn DataField="ShippedDate" DataType="System.DateTime" 
            HeaderText="ShippedDate" SortExpression="ShippedDate" UniqueName="ShippedDate">
        </telerik:GridBoundColumn>--%>
        <telerik:GridBoundColumn DataField="ShipVia" DataType="System.Int32" 
            HeaderText="ShipVia" SortExpression="ShipVia" UniqueName="ShipVia">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="Freight" DataType="System.Decimal" 
            HeaderText="Freight" SortExpression="Freight" UniqueName="Freight">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ShipName" HeaderText="ShipName" 
            SortExpression="ShipName" UniqueName="ShipName">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ShipAddress" HeaderText="ShipAddress" 
            SortExpression="ShipAddress" UniqueName="ShipAddress">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ShipCity" HeaderText="ShipCity" 
            SortExpression="ShipCity" UniqueName="ShipCity">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ShipRegion" HeaderText="ShipRegion" 
            SortExpression="ShipRegion" UniqueName="ShipRegion">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ShipPostalCode" HeaderText="ShipPostalCode" 
            SortExpression="ShipPostalCode" UniqueName="ShipPostalCode">
        </telerik:GridBoundColumn>
        <telerik:GridBoundColumn DataField="ShipCountry" HeaderText="ShipCountry" 
            SortExpression="ShipCountry" UniqueName="ShipCountry">
        </telerik:GridBoundColumn>
    </Columns>
</MasterTableView>
        </telerik:RadGrid>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @OrderID" 
            InsertCommand="INSERT INTO [Orders] ([CustomerID], [EmployeeID], [OrderDate], [RequiredDate], [ShippedDate], [ShipVia], [Freight], [ShipName], [ShipAddress], [ShipCity], [ShipRegion], [ShipPostalCode], [ShipCountry]) VALUES (@CustomerID, @EmployeeID, @OrderDate, @RequiredDate, @ShippedDate, @ShipVia, @Freight, @ShipName, @ShipAddress, @ShipCity, @ShipRegion, @ShipPostalCode, @ShipCountry)" 
            SelectCommand="SELECT * FROM [Orders]" 
            UpdateCommand="UPDATE [Orders] SET [CustomerID] = @CustomerID, [EmployeeID] = @EmployeeID, [OrderDate] = @OrderDate, [RequiredDate] = @RequiredDate, [ShippedDate] = @ShippedDate, [ShipVia] = @ShipVia, [Freight] = @Freight, [ShipName] = @ShipName, [ShipAddress] = @ShipAddress, [ShipCity] = @ShipCity, [ShipRegion] = @ShipRegion, [ShipPostalCode] = @ShipPostalCode, [ShipCountry] = @ShipCountry WHERE [OrderID] = @OrderID">
            <DeleteParameters>
                <asp:Parameter Name="OrderID" Type="Int32" />
            </DeleteParameters>
            <UpdateParameters>
                <asp:Parameter Name="CustomerID" Type="String" />
                <asp:Parameter Name="EmployeeID" Type="Int32" />
                <asp:Parameter Name="OrderDate" Type="DateTime" />
                <asp:Parameter Name="RequiredDate" Type="DateTime" />
                <asp:Parameter Name="ShippedDate" Type="DateTime" />
                <asp:Parameter Name="ShipVia" Type="Int32" />
                <asp:Parameter Name="Freight" Type="Decimal" />
                <asp:Parameter Name="ShipName" Type="String" />
                <asp:Parameter Name="ShipAddress" Type="String" />
                <asp:Parameter Name="ShipCity" Type="String" />
                <asp:Parameter Name="ShipRegion" Type="String" />
                <asp:Parameter Name="ShipPostalCode" Type="String" />
                <asp:Parameter Name="ShipCountry" Type="String" />
                <asp:Parameter Name="OrderID" Type="Int32" />
            </UpdateParameters>
            <InsertParameters>
                <asp:Parameter Name="CustomerID" Type="String" />
                <asp:Parameter Name="EmployeeID" Type="Int32" />
                <asp:Parameter Name="OrderDate" Type="DateTime" />
                <asp:Parameter Name="RequiredDate" Type="DateTime" />
                <asp:Parameter Name="ShippedDate" Type="DateTime" />
                <asp:Parameter Name="ShipVia" Type="Int32" />
                <asp:Parameter Name="Freight" Type="Decimal" />
                <asp:Parameter Name="ShipName" Type="String" />
                <asp:Parameter Name="ShipAddress" Type="String" />
                <asp:Parameter Name="ShipCity" Type="String" />
                <asp:Parameter Name="ShipRegion" Type="String" />
                <asp:Parameter Name="ShipPostalCode" Type="String" />
                <asp:Parameter Name="ShipCountry" Type="String" />
            </InsertParameters>
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>
