ASP Page for accessing database to PDF locations

[TCPDWPZN]

Hi All. My first post so i hope someone can really assist. Our company uses a DMS that stores PDF's of all statements and invoices on a system. They are referenced by .NET app that calls the PDF's up via a database that usually just uses the table requirements (search criteria) to find and display them.

Attached is what i need to build. Ignore the inputs on the left. This was an ASP page that got the input for a customer number and the type of statement they want which would then go read the DB to find all related PDF's. How do i build this list view? Cause all i have seen wit dot net is that you can build lists with buttons and text but not a list that will also all the user to input. Like in the image each 1 has a text box so they can enter which page they want of the statement. Alternatively how can i build this list and then all them to select 1 of the statements listed and then coallate the PDF's (they are stored as separate documents, i.e. Page 1 of 4 etc), coallate them and then display this for them to use/save?

Please do assist i will be thankful for any suggestions. Any further information please feel free to let me know. (darrenwayne@telkomsa.net)

Thanks.

 

[demausdauth]

Is this going to be a web app or a windows app? If it is a web app then I would say use a datalist for the grid part, i am not sure which of the data controls were available in .NET 1.1 for a windows app.

 

[TCPDWPZN]

Web App

Is this going to be a web app or a windows app? If it is a web app then I would say use a datalist for the grid part, i am not sure which of the data controls were available in .NET 1.1 for a windows app.

Hi sorry should of stated. It's a web app that they retrieve documents of a secure dms server. DataList ok i get but then I havent seen a user input part of that. So do you think the list view's button can just collate the multiple documents for me and open it up? Or as a feature allow for a zip as well?

If i show you the list and display function's would you be able to tell me what the command would be to do so?

Thanks for the pointer.

 

[demausdauth]

Here is one way you could build the datalist.

<ItemTemplate>
            <table>
                <tr>
                    <td>
                        <asp:ImageButton ID="imgbtnFind" runat="server" CommandName="FindButton" />
                        <asp:ImageButton ID="imgbtnSend" runat="server" CommandName="SendButton" />
                    </td>
                     <td>
                         <asp:LinkButton ID="lbDocument" runat="server" CommandName="DocButton" Text='<%# DataBinder.Eval(Container.DataItem, "DocumentName") %>' CommandArgument='<%# DataBinder.Eval(Container.DataItem, "DocumentName") %>' ></asp:LinkButton>
                    </td>
                     <td>
                         <asp:TextBox ID="txtInputPage" runat="server" Columns="2" MaxLength="3" >1</asp:TextBox> of <asp:Label ID="lblTotalPages" runat="server" ></asp:Label>
                    </td>
                    <td>
                         <asp:Label ID="lblInvoiceNum" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "InvoiceNumber") %>'></asp:Label>                        
                    </td>   
                     <td>
                         <asp:Label ID="lblDocumentDate" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "DocumentDate") %>'></asp:Label>
                    </td>
                     <td>
                         <asp:Label ID="lblDocDeliverNum" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "DeliveryNumber") %>'></asp:Label>
                    </td>
                     <td>
                         <asp:Label ID="lblCustAcctNum" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "CustomerAccount") %>'></asp:Label>
                    </td>
                     <td>
                         <asp:Label ID="lblCustAcctPONum" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "CustomerPONmber") %>'></asp:Label>
                    </td>
                     <td>
                         <asp:Label ID="lblIndexDate" runat="server" Text='<%# DataBinder.Eval(Container.DataItem, "IndexDate") %>'></asp:Label>
                    </td>                                      
                </tr>
            </table>
        </ItemTemplate>

The text box txtInputPage can be searched for in the codebehind after a button is clicked and then you would know whcih page was selected.

 

[TCPDWPZN]

Hi. Thanks for that. Will look at changing the method later. Right now i have a very important problem. My application was developed and tested on a server with one component version. The production box has a different version of the same COM's.

How do i import that PROD version to my local machine and recompile the application referencing this older version? My friend told me to just install the prod version locally and compile and then push the changed (compiled files) back to prod and see. But damn the same issues constantly!! any help on how to do this process? prod version uses interactive user and remote server location to point to. dev version had a custom user and no server location (it was blocked off).

Please help...