markup

<%@ Page Title="" Language="C#" MasterPageFile="~/MasterBadge1.master" AutoEventWireup="true" CodeFile="aSelectEventExport.aspx.cs" Inherits="aSelectEventExport" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

    <center>
        <asp:Label ID="Label1" runat="server" Text="Label" Style="font-size: large; color: #FF3300;
            font-weight: 500"></asp:Label>
  <br /><br />

        <asp:Label ID="Label2" runat="server" Text="Select Events To Export" Style="font-size: large;
            color: #FFFFFF; font-weight: 700; text-decoration: underline;"></asp:Label>
 <br /><br />
 <br />
    <asp:TextBox ID="txtSearchEvent" runat="server" Height="19px" Width="201px"></asp:TextBox>&nbsp;
    <asp:Button ID="SearchEvent" runat="server" Text="Search" onclick="SearchEvent_Click" Width="127px" Height="20px" />
&nbsp;
        <asp:Button ID="bShowAll" runat="server" Height="19px" onclick="bShowAll_Click"
            Text="Show All" />
<table>
<%--<tr>
<td align="center">
 <asp:DropDownList ID="DropDownList1" runat="server"
        DataSourceID="SqlDataSource3" DataTextField="CME_Type"
        DataValueField="CME_Type_ID" AutoPostBack="True">
    </asp:DropDownList>
    <asp:SqlDataSource ID="SqlDataSource3" runat="server"
        ConnectionString="<%$ ConnectionStrings:CME_RFID %>"
        ProviderName="System.Data.SqlClient"
        SelectCommand="SELECT CME_Type,CME_Type_ID FROM CME_RFIDReader.CME_Type"></asp:SqlDataSource>
</td>
</tr>--%>
<tr>
<td>&nbsp;</td>
</tr>

<tr>
<td>

    &nbsp;<asp:Button ID="btnMenu" runat="server" Text="Return to Menu" OnClick="btnMenu_Click" />&nbsp;&nbsp;<asp:Button ID="btnLogOff" runat="server" Text="Log Off" OnClick="btnLogOff_Click"/>

</td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
<tr>
<td>
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1" AllowPaging="True"
            AllowSorting="True" AutoGenerateColumns="False" BackColor="#CCCCCC" BorderColor="White"
            BorderStyle="Solid" BorderWidth="3px" CellPadding="4" DataKeyNames="EventID"
            CellSpacing="2" ForeColor="Black" Width="984px" EmptyDataText="No Events Found"
        OnSelectedIndexChanged="GridView1_SelectedIndexChanged" OnRowEditing ="GridView1_RowEditing">
            <RowStyle BackColor="White" />
            <Columns>
                <asp:CommandField ButtonType="Button" CausesValidation="False"
                    DeleteText="" EditText="Add Track ID" InsertText="" NewText=""
                    SelectText="" ShowEditButton="True" UpdateText="Commit" />
                <asp:CommandField ButtonType="Button"
                    DeleteText="" EditText="" InsertText="" NewText=""
                    SelectText="Export" UpdateText="" InsertVisible="False"
                    ShowCancelButton="False" ShowSelectButton="True" CancelText="" />
                <asp:BoundField DataField="CME_Event_Track_ID" HeaderText="CME Track ID" SortExpression="CME_Event_Track_ID" />
                <asp:BoundField DataField="EventID" HeaderText="Event ID" SortExpression="EventID" Visible="False" />
                <asp:BoundField DataField="Event_Type" HeaderText="Event Type" SortExpression="Event_Type" Visible="False" />
                <asp:BoundField DataField="Event_Name" HeaderText="Event Name" SortExpression="Event_Name" />
                <asp:BoundField DataField="Event_Desc" HeaderText="Event Desc" SortExpression="Event_Desc" />
                <asp:BoundField DataField="EventDate" HeaderText="Event Date" SortExpression="EventDate" />
                <asp:BoundField DataField="EventCount" HeaderText="Attendance Count" SortExpression="EventCount" />
                <asp:BoundField DataField="MissingRFID" HeaderText="Number Of Missing RFID" SortExpression="MissingRFID" />
            </Columns>
            <FooterStyle BackColor="#CCCCCC" />
            <PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
            <EmptyDataTemplate>
                &nbsp;
            </EmptyDataTemplate>
            <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
 </asp:GridView>
</td>
</tr>
<tr>
<td>
&nbsp;</td>
</tr>
</table>
</center>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:CME_RFID %>" ProviderName="System.Data.SqlClient"
        SelectCommand="SELECT * FROM  CME_RFIDReader.vAdminExportStat order by Event_Date DESC"
        UpdateCommand="UPDATE CME_RFIDReader.CME_Events SET CME_Event_Track_ID = @CME_Event_Track_ID WHERE EventID = @EventID">
</asp:SqlDataSource>
</asp:Content>