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

 

<!DOCTYPE html>

 

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

    <title>Stored Procedures Example</title>

</head>

<body bgcolor="#99ffcc">

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

        database server.</h3>

 

    <form id="form1" runat="server">

 

 

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

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

 

        <br />

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

            style="z-index: 1; left: 15px; top: 142px; position: absolute; height: 24px; width: 274px"

            Text="Select Account to Transfer To:"></asp:Label>

           

        <asp:DropDownList ID="ddlToAccount" runat="server"

                style="z-index: 1; left: 14px; position: absolute; height: 22px; width: 142px; top: 164px"

                AutoPostBack="True">

        </asp:DropDownList>

        <br />

 

        <br />

 

        <asp:Button ID="btnTransferFunds" runat="server" Text="Transfer Funds"

                    style="z-index: 1; left: 14px; top: 273px; position: absolute; height: 33px; bottom: 186px; width: 120px;" OnClick="btnTransferFunds_Click" />

          

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

                              

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

        </asp:DropDownList>

 

       <div style="z-index: 1; left: 17px; top: 322px; position: absolute; height: 304px; width: 669px">

 

            <asp:GridView ID="gvUpdatedAccounts" runat="server" />

      

            <br /><br />

 

            <asp:gridview ID="gvAccounts" runat="server" />

       

       </div>

 

        <br />

 

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

                   style="z-index: 1; left: 81px; top: 198px; position: absolute; width: 70px; height: 20px; right: 558px; margin-top: 6px;" />

 

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

                style="z-index: 1; left: 14px; top: 200px; position: absolute; width: 62px; right: 633px"

                Text="Amount:" />

 

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

                style="z-index: 1; left: 81px; top: 237px; position: absolute; bottom: 236px;"></asp:Label>

 

 

    </form>

</body>

</html>