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

<!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" />
	<telerik:RadGrid runat="server" AutoGenerateColumns="False" AllowSorting="True" AutoGenerateEditColumn="True"
		AllowAutomaticUpdates="True" AllowAutomaticInserts="True" AllowAutomaticDeletes="True"
		ID="RadGrid1" AllowPaging="True" CellSpacing="0" DataSourceID="SqlDataSource1"
		GridLines="None">
		<MasterTableView InsertItemDisplay="Top" InsertItemPageIndexAction="ShowItemOnCurrentPage"
			AutoGenerateColumns="true" CommandItemDisplay="Top" TableLayout="Fixed" DataSourceID="SqlDataSource1">
			<CommandItemSettings ExportToPdfText="Export to PDF"></CommandItemSettings>
			<RowIndicatorColumn Visible="True" FilterControlAltText="Filter RowIndicator column">
			</RowIndicatorColumn>
			<ExpandCollapseColumn Visible="True" FilterControlAltText="Filter ExpandColumn column">
			</ExpandCollapseColumn>
			<EditFormSettings>
				<EditColumn FilterControlAltText="Filter EditCommandColumn column">
				</EditColumn>
			</EditFormSettings>
		</MasterTableView>
		<FilterMenu EnableImageSprites="False">
		</FilterMenu>
	</telerik:RadGrid>
	<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MySqlNorthwindConnectionString %>"
		ProviderName="<%$ ConnectionStrings:MySqlNorthwindConnectionString.ProviderName %>"
		SelectCommand="SELECT OrderID, CustomerID, EmployeeID, OrderDate FROM orders"
		DeleteCommand="DELETE FROM orders WHERE OrderID = @OrderID" 
		InsertCommand="INSERT INTO order] (OrderID, CustomerID, EmployeeID, OrderDate) VALUES (OrderID, CustomerID, EmployeeID, OrderDate)"
		UpdateCommand="UPDATE orders SET CustomerID = CustomerID, EmployeeID = EmployeeID, OrderDate = @OrderDate WHERE OrderID = @OrderID">
		<DeleteParameters>
			<asp:Parameter Name="OrderID" Type="Int32" />
		</DeleteParameters>
		<InsertParameters>
			<asp:Parameter Name="OrderID" Type="Int32" />
			<asp:Parameter Name="CustomerID" Type="String" />
			<asp:Parameter Name="EmployeeID" Type="Int32" />
			<asp:Parameter Name="OrderDate" Type="DateTime" />
		</InsertParameters>
		<UpdateParameters>
			<asp:Parameter Name="CustomerID" Type="String" />
			<asp:Parameter Name="EmployeeID" Type="Int32" />
			<asp:Parameter Name="OrderDate" Type="DateTime" />
			<asp:Parameter Name="OrderID" Type="Int32" />
		</UpdateParameters>
	</asp:SqlDataSource>
	</form>
</body>
</html>
