<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="StoredProcedureExample1.aspx.cs" Inherits="Database.StoredProcedureExample1" %>
<!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">Enter Account ID or Customer Name:</asp:Label>
<br />
<br />
<asp:Button ID="btnFindAccount" runat="server" Text="Find Account by
ID"
style="z-index: 1; left: 187px; top: 106px; position: absolute; height: 28px;"
Width="180px" OnClick="btnFindAccount_Click" /> <br />
<asp:Button ID="btnFindAccountsByName" runat="server" Text="Find Accounts By
Name"
style="z-index: 1; left: 188px; top: 143px; position: absolute; height: 28px; bottom: 321px;"
Width="180px" OnClick="btnFindAccountsByName_Click" />
<asp:Button ID="btnDisplayAccounts" runat="server" Text="Display Accounts"
style="z-index: 1; left: 383px; top: 106px; position: absolute; width: 129px; height: 64px; bottom: 322px;" OnClick="btnDisplayAccounts_Click" />
<br /><br />
<asp:TextBox ID="txtName" runat="server"
style="z-index: 1; left: 12px; top: 106px; position: absolute; width: 158px; height: 23px" />
<asp:gridview ID="gvCustomers" runat="server"
style="z-index: 1; left: 17px; top: 190px; position: absolute;
height: 133px; width: 187px">
</asp:gridview>
</form>
</body>
</html>