<%@ Page Language="VB" AutoEventWireup="true" CodeFile="StoredProcedures.aspx.vb" Inherits="StoredProcedures" %>

<!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 id="Head1" runat="server">
    <title>Procedury składowane</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
       <asp:GridView ID="OrderGridView" runat="server"
          AutoGenerateColumns="False" DataKeyNames="SalesOrderID" 
          onselectedindexchanged="OrderGridView_SelectedIndexChanged">
          <Columns>
             <asp:ButtonField CommandName="Select" Text="Szczegóły" />
             <asp:BoundField DataField="SalesOrderID" HeaderText="ID zamówienia" />
             <asp:BoundField DataField="OrderDate" HeaderText="Data zamówienia" />
             <asp:BoundField DataField="CompanyName" HeaderText="Firma" />
             <asp:BoundField DataField="Contact" HeaderText="Kontakt" />
             <asp:BoundField DataField="TotalDue" HeaderText="Wartość całkowita" />
          </Columns>
       </asp:GridView>
       
       <asp:Panel ID="OrderDetailsPanel" runat="server">
          <asp:GridView ID="OrderDetailsGridView" runat="server" 
             AutoGenerateColumns="False">
             <Columns>
                <asp:BoundField DataField="Name" HeaderText="Produkt" />
                <asp:BoundField DataField="OrderQty" HeaderText="Ilość" />
                <asp:BoundField DataField="UnitPrice" HeaderText="Cena jednostkowa" />
                <asp:BoundField DataField="LineTotal" HeaderText="Wartość całkowita" />
             </Columns>
          </asp:GridView>
       </asp:Panel>
    </div>
    </form>
</body>
</html>
