<%@ page language="C#" masterpagefile="~/RotarySevaTrust.master" autoeventwireup="true" inherits="monthly_report, App_Web_monthly report.aspx.cdcab7d2" title="Welcome to Rotary Seva Trust" %>


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


<form id="form1" runat="server">
    <div class="wrapper row4">
        <div id="container" class="clear">
            <!-- ####################################################################################################### -->
            <div id="wrapper_main">
                <div id="wrapper_left">
                    <h2 class="title">
                        Select Categry:</h2>
                        
                    <div id="hpage_quicklinks">
                        <ul class="clear">
                        <asp:DataList ID="DataList1" runat="server" Width="200px"
                                DataSourceID="AccessDataSource2" style="text-align: left" OnItemCommand="DataList1_ItemCommand">
                                <ItemTemplate>
                                    <table border="0">
                                        <tr>
                                            <td>
                                                <asp:LinkButton ID="LinkButton1" runat="server" CommandName="Edit" Font-Size= "13px"
                                                    Text='<%# Eval("Category", "{0}") %>'></asp:LinkButton>
                                                <hr style="color: #800000; margin-top: 0px; margin-bottom: 0px" />
                                            </td>
                                        </tr>
                                    </table>
                                </ItemTemplate>
                            </asp:DataList>
                            <asp:AccessDataSource ID="AccessDataSource2" runat="server" 
                                DataFile="~/App_Data/superwit.mdb" 
                                SelectCommand="SELECT distinct[Category] FROM [reports] WHERE ([sr_no] &lt;&gt; ?)">
                                <SelectParameters>
                                    <asp:Parameter DefaultValue="0" Name="Sr_No" Type="String" />
                                </SelectParameters>
                            </asp:AccessDataSource>  
                                 </ul> <br />         
                       </div>
                    
                    </div> 

   
   
   
   <div id="wrapper_right">
                    <h2 class="title">
                        Monthly Reports:</h2>
                    <div id="hpage_latestnews">


                
                            <asp:GridView ID="GridView1" runat="server" BackColor="#CCCCCC" 
                                BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4" 
                                CellSpacing="2" ForeColor="Black" style="font-family: Verdana; font-size: 9pt" 
                                Width="720px" AutoGenerateColumns="False" DataKeyNames="sr_no" 
                                DataSourceID="AccessDataSource1">
                                <RowStyle BackColor="White" />
                                <Columns>
                                    <asp:BoundField DataField="sr_no" HeaderText="Sr No" ReadOnly="True" 
                                        SortExpression="sr_no" />
                                         <asp:BoundField DataField="Category" HeaderText="Category" ReadOnly="True" 
                                        SortExpression="Category" />
                                    <asp:BoundField DataField="Heading" HeaderText="Heading" 
                                        SortExpression="Heading" />
                                    <asp:TemplateField HeaderText="File" SortExpression="URL">
                                        <EditItemTemplate>
                                            <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("URL") %>'></asp:TextBox>
                                        </EditItemTemplate>
                                        <ItemTemplate>
                                            <asp:HyperLink ID="HyperLink1" runat="server" 
                                                NavigateUrl='<%# Eval("URL", "reports/{0}") %>' Text='<%# "View File" %>'></asp:HyperLink>
                                        </ItemTemplate>
                                    </asp:TemplateField>
                                    <asp:BoundField DataField="Upload_Date" HeaderText="Uploaded Date" 
                                        SortExpression="Upload_Date" />
                                </Columns>
                                <FooterStyle BackColor="#CCCCCC" />
                                <PagerStyle BackColor="#CCCCCC" ForeColor="Black" HorizontalAlign="Left" />
                                <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
                                <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
                            </asp:GridView>
                            <asp:AccessDataSource ID="AccessDataSource1" runat="server" 
                                DataFile="~/App_Data/superwit.mdb" 
                                SelectCommand="SELECT * FROM [reports] WHERE ([category] = ?) ORDER BY [sr_no]">
                                <SelectParameters>
                                                <asp:ControlParameter ControlID="TextBox1" Name="Category" 
                                                    PropertyName="Text" Type="String" />
                                            </SelectParameters>
                            </asp:AccessDataSource>
                        
                        <asp:TextBox ID="TextBox1" runat="server" Text="Label" Visible="false"></asp:TextBox><br /><br /><br /> <br /><br />
    </div> </div> </div> </div> </div> </form> 
</asp:Content>

