document.write('
Data hosted with ♥ by Pastebin.com - Download Raw - See Original
  1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="ListarClientes.aspx.cs" Inherits="ListarClientes" %>
  2.  
  3. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  4.  
  5. <html xmlns="http://www.w3.org/1999/xhtml">
  6. <head runat="server">
  7.     <title></title>
  8.     </head>
  9. <body>
  10.     <form id="form1" runat="server">
  11.  
  12.     <asp:DataGrid ID="DataGrid1" runat="server" AllowPaging="True" CellPadding="4"
  13.         DataSourceID="mysqlConnection" ForeColor="#333333"
  14.         Width="711px" AllowCustomPaging="True" AllowSorting="True"
  15.         BorderWidth="2px" AutoGenerateColumns="False" ShowFooter="True">
  16.         <AlternatingItemStyle BackColor="White" ForeColor="#284775" />
  17.         <Columns>
  18.             <asp:HyperLinkColumn DataTextField="nome" HeaderText="Nome" Target="_self"
  19.                 Text="nome" DataNavigateUrlField="id"
  20.                 DataNavigateUrlFormatString="alteraCliente.aspx?id={0}">
  21.             </asp:HyperLinkColumn>
  22.             <asp:BoundColumn DataField="telefone" HeaderText="Telefone" ReadOnly="True">
  23.             </asp:BoundColumn>
  24.             <asp:BoundColumn DataField="cidade" HeaderText="Cidade" ReadOnly="True">
  25.             </asp:BoundColumn>
  26.             <asp:BoundColumn DataField="estado" HeaderText="U.F" ReadOnly="True">
  27.             </asp:BoundColumn>
  28.             <asp:ButtonColumn CommandName="Delete" Text="Delete"></asp:ButtonColumn>
  29.         </Columns>
  30.         <EditItemStyle BackColor="#999999" />
  31.         <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
  32.         <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
  33.         <ItemStyle BackColor="#F7F6F3" ForeColor="#333333" />
  34.         <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
  35.         <SelectedItemStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
  36.     </asp:DataGrid>
  37.     <asp:SqlDataSource ID="mysqlConnection" runat="server"
  38.         ConnectionString="<%$ ConnectionStrings:stonehengeConnectionString %>"
  39.         ProviderName="<%$ ConnectionStrings:stonehengeConnectionString.ProviderName %>"
  40.         SelectCommand="SELECT id,nome, cidade, telefone, estado FROM cliente ">
  41.     </asp:SqlDataSource>
  42.     </form>
  43. </body>
  44. </html>
');