<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="StoredProcedureExample2.aspx.cs" Inherits="Database.StoredProcedureExample2" %>

<!DOCTYPE html>

<title>Stored Procedures Example</title>

</head>

<h3>This example demonstrates the use of a executing a Stored Procedure on the

database server.</h3>

<asp:Label ID="lblDisplay" runat="server" Font-Bold="True"

style="z-index: 1; left: 15px; top: 77px; position: absolute">Select Account:</asp:Label>

<br />

<asp:Button ID="btnWithdraw" runat="server" Text="Withdraw"

style="z-index: 1; left: 175px; top: 137px; position: absolute; height: 28px; width: 108px;" OnClick="btnWithdraw_Click" /> <br />

<asp:Button ID="btnDeposit" runat="server" Text="Deposit"

style="z-index: 1; left: 176px; top: 95px; position: absolute; height: 28px; bottom: 369px; width: 108px;" OnClick="btnDeposit_Click" />

<asp:DropDownList ID="ddlAccounts" runat="server" AutoPostBack="True"

style="z-index: 1; left: 15px; top: 100px; position: absolute; height: 22px; width: 142px" OnSelectedIndexChanged="ddlAccounts_SelectedIndexChanged">

</asp:DropDownList>

<asp:TextBox ID="txtAmount" runat="server"

style="z-index: 1; left: 85px; top: 134px; position: absolute; width: 70px; height: 20px; right: 554px; margin-top: 6px;" />

<asp:gridview ID="gvAccount" runat="server"

style="z-index: 1; left: 16px; top: 206px; position: absolute;

height: 133px; width: 187px">

</asp:gridview>

<asp:Label ID="Label1" runat="server"

style="z-index: 1; left: 27px; top: 138px; position: absolute; width: 62px; right: 620px"

Text="Amount:" />

<asp:Label ID="lblMessage" runat="server"

style="z-index: 1; left: 83px; top: 171px; position: absolute"></asp:Label>

</form>

</body>

</html>