<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ListarClientes.aspx.cs" Inherits="ListarClientes" %>
<!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 runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:DataGrid ID="DataGrid1" runat="server" AllowPaging="True" CellPadding="4"
DataSourceID="mysqlConnection" ForeColor="#333333"
Width="711px" AllowCustomPaging="True" AllowSorting="True"
BorderWidth="2px" AutoGenerateColumns="False" ShowFooter="True">
<AlternatingItemStyle BackColor="White" ForeColor="#284775" />
<Columns>
<asp:HyperLinkColumn DataTextField="nome" HeaderText="Nome" Target="_self"
Text="nome" DataNavigateUrlField="id"
DataNavigateUrlFormatString="alteraCliente.aspx?id={0}">
</asp:HyperLinkColumn>
<asp:BoundColumn DataField="telefone" HeaderText="Telefone" ReadOnly="True">
</asp:BoundColumn>
<asp:BoundColumn DataField="cidade" HeaderText="Cidade" ReadOnly="True">
</asp:BoundColumn>
<asp:BoundColumn DataField="estado" HeaderText="U.F" ReadOnly="True">
</asp:BoundColumn>
<asp:ButtonColumn CommandName="Delete" Text="Delete"></asp:ButtonColumn>
</Columns>
<EditItemStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<ItemStyle BackColor="#F7F6F3" ForeColor="#333333" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<SelectedItemStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
</asp:DataGrid>
<asp:SqlDataSource ID="mysqlConnection" runat="server"
ConnectionString="<%$ ConnectionStrings:stonehengeConnectionString %>"
ProviderName="<%$ ConnectionStrings:stonehengeConnectionString.ProviderName %>"
SelectCommand="SELECT id,nome, cidade, telefone, estado FROM cliente ">
</asp:SqlDataSource>
</form>
</body>
</html>