How to set a parameter as a text file

[315hughes]

Hi everyone i am slowly learning a bit of asp and I have managed to make a TextBox value update a column in a table.

What I would now like it to do is, rather than the parameter being the TextBox, is to update the table based on a text file from my desktop.

Here is my asp so far. How should i go about approaching this.

Thanks for any help in advance.

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
        <br />
        <asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
        </asp:DataList>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:bookConnectionString %>" 
            InsertCommand="InsertInToIntTableStoredProcedure" 
            InsertCommandType="StoredProcedure" 
            SelectCommand="InsertInToIntTableStoredProcedure" 
            SelectCommandType="StoredProcedure">
            <InsertParameters>
                <asp:Parameter Name="ProdID" Type="Int32" />
            </InsertParameters>
            <SelectParameters>
                <asp:ControlParameter ControlID="TextBox1" Name="ProdID" PropertyName="Text" 
                    Type="Int32" />
            </SelectParameters>
        </asp:SqlDataSource>

Also after playing with what i currently have why do i have to have the datalist bit to make this to work?

<asp:DataList ID="DataList1" runat="server" DataSourceID="SqlDataSource1">
        </asp:DataList>

[Frinavale]

You would need to have the user select the text file to upload to the server.

The server would then have to take the necessary steps to validate the file uploaded and then read from the text file in order to update your database.

Or if you are planning on just storing the text file into the database, you could skip the reading part.

-Frinny

[315hughes]

I will just be attempting to store the values of the text file into a database. will i need to do this in the VB code behind?

[Frinavale]

Yes you will have to do this in your server-side code.
This is business logic and cannot be handled automatically for you.

-Frinny