<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="AllShows.aspx.vb" Inherits="Metallica.Webforms_AllShows" %>

<!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>All Shows</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Panel
            ID="Panel1" runat="server" Height="8px" Width="537px">
            <a href="Index.aspx"><span style="font-size: 10pt; font-family: Arial">Home</span></a>&nbsp;
            &nbsp; <a href="AllSongs.aspx"><span style="font-size: 10pt; font-family: Arial">View All Songs</span></a>&nbsp;
            &nbsp; <a href="SongStats.aspx"><span style="font-size: 10pt; font-family: Arial">View Song
                Statistics</span></a>&nbsp;&nbsp; &nbsp;<a href="AllShows.aspx"><span style="font-size: 10pt; font-family: Arial">View All Shows</span></a>&nbsp;&nbsp;
            &nbsp;<a href="UserFiles/AddShow.aspx"><span style="font-size: 10pt; font-family: Arial">Add
                a Show</span></a>&nbsp;&nbsp; &nbsp;<asp:LinkButton ID="lbSignOut" runat="server" Font-Names="Arial" Font-Size="Small"
            Visible="False">Log Out</asp:LinkButton></asp:Panel>
        <br />
         <br /><strong><span style="font-size: 16pt; font-family: Arial">All Shows<br />
        </span></strong><span style="font-size: 10pt">
            <br />
        </span>
        <asp:GridView ID="gvData" runat="server" AutoGenerateColumns="False" BackColor="White"
            BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource1"
            EmptyDataText="-" Font-Names="Arial" Font-Size="Small" GridLines="Vertical">
            <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
            <Columns>
                <asp:BoundField DataField="Year" HeaderText="Year" SortExpression="Year">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:BoundField>
                <asp:BoundField DataField="Month" HeaderText="Month" SortExpression="Month">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:BoundField>
                <asp:BoundField DataField="Day" HeaderText="Day" SortExpression="Day">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:BoundField>
                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                <asp:BoundField DataField="State" HeaderText="State" SortExpression="State" />
                <asp:BoundField DataField="Country" HeaderText="Country" SortExpression="Country" />
                <asp:BoundField DataField="Venue" HeaderText="Venue" SortExpression="Venue" />
                <asp:HyperLinkField DataNavigateUrlFields="ShowNumber" DataNavigateUrlFormatString="~/Webforms/DisplayShow.aspx?ShowNumber={0}"
                    HeaderText="Setlist" NavigateUrl="~/Webforms/DisplayShow.aspx" Text="view">
                    <ItemStyle HorizontalAlign="Center" />
                </asp:HyperLinkField>
                <asp:BoundField DataField="Notes" HeaderText="Notes" SortExpression="Notes" />
            </Columns>
            <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
            <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
            <HeaderStyle BackColor="#000084" Font-Bold="True" Font-Underline="True" ForeColor="White" />
            <AlternatingRowStyle BackColor="#DCDCDC" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Metallica.My.MySettings.csMetallica %>"
            SelectCommand="SELECT [Year], [Month], [Day], [City], [State], [Country], [Venue], [Notes], [ShowNumber] FROM [Show] ORDER BY [Year], [Month], [Day]">
        </asp:SqlDataSource>
    
    </div>
    </form>
</body>
</html>
