<%@ page language="VB" %>

<script runat="server">

</script>

<html>
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" Runat="server" SelectCommand="SELECT CustomerID, CompanyName, ContactName, ContactTitle, Address, City, Country FROM Customers"
            ConnectionString="data source=W2000;Integrated Security=SSPI;Initial catalog=northwind">
        </asp:SqlDataSource>
        <asp:GridView ID="GridView1" Runat="server" DataSourceID="SqlDataSource1" DataKeyNames="CustomerID"
            AutoGenerateColumns="False" BorderWidth="1px" BackColor="White" CellPadding="4"
            BorderColor="#CC9966" AllowPaging="True" AllowSorting="True" BorderStyle="None"
            Font-Names="Verdana" Font-Size="XX-Small">
            <FooterStyle ForeColor="#330099" BackColor="#FFFFCC" Font-Size="XX-Small" HorizontalAlign="Center">
            </FooterStyle>
            <PagerStyle BackColor="#FFFFC0" HorizontalAlign="Center" ForeColor="Black" Font-Bold="False" Font-Italic="False" Font-Names="Verdana" Font-Size="XX-Small">
            </PagerStyle>
            <HeaderStyle ForeColor="White" Font-Bold="True" BackColor="#FFFFC0">
            </HeaderStyle>
            <Columns>
                <asp:BoundField ReadOnly="True" HeaderText="CustomerID" DataField="CustomerID" SortExpression="CustomerID">
                </asp:BoundField>
                <asp:BoundField HeaderText="CompanyName" DataField="CompanyName" SortExpression="CompanyName">
                </asp:BoundField>
                <asp:BoundField HeaderText="ContactName" DataField="ContactName" SortExpression="ContactName">
                </asp:BoundField>
                <asp:BoundField HeaderText="ContactTitle" DataField="ContactTitle" SortExpression="ContactTitle">
                </asp:BoundField>
                <asp:BoundField HeaderText="Address" DataField="Address" SortExpression="Address">
                </asp:BoundField>
                <asp:BoundField HeaderText="City" DataField="City" SortExpression="City">
                </asp:BoundField>
                <asp:BoundField HeaderText="Country" DataField="Country" SortExpression="Country">
                </asp:BoundField>
            </Columns>
            <SelectedRowStyle ForeColor="#663399" Font-Bold="True" BackColor="#FFCC66">
            </SelectedRowStyle>
            <RowStyle ForeColor="#330099" BackColor="White">
            </RowStyle>
        </asp:GridView>
    
    </div>
    </form>
</body>
</html>
