evismaniac
IS-IT--Management
wondered if anyone could give me a bit of advice on asp.net. im a newbie so go easy on me 
im coding a site using vb.net, that uploads word and pdf documents to a location which they can then later be viewed and downloaded if requried,
what iv got is an sql database that holds all the details that the user enters into the form when uploading, along with the actual file, e.i title, author, date, and it all works fine! What i want to do is to use the file LOCATION in the appropriate sql table. i.e column name is "fileLocation" then in there the specific location of the uploaded file e.g "documents\test.doc"
so what i need to be able to do is upload the required ".doc" or ".pdf" files to a folder called "documents\" which is in the same location as the "upload.aspx" and then insert the location and filename of the uploaded file into the "fileLocation" field in the database !
im guessing some sort of ftp command in the code or something? seems so easy in theory but i cant get my head round how to do it. any ideas would be a great help!
p.s the database table is called tblPaper.
Thanks
im coding a site using vb.net, that uploads word and pdf documents to a location which they can then later be viewed and downloaded if requried,
what iv got is an sql database that holds all the details that the user enters into the form when uploading, along with the actual file, e.i title, author, date, and it all works fine! What i want to do is to use the file LOCATION in the appropriate sql table. i.e column name is "fileLocation" then in there the specific location of the uploaded file e.g "documents\test.doc"
so what i need to be able to do is upload the required ".doc" or ".pdf" files to a folder called "documents\" which is in the same location as the "upload.aspx" and then insert the location and filename of the uploaded file into the "fileLocation" field in the database !
im guessing some sort of ftp command in the code or something? seems so easy in theory but i cant get my head round how to do it. any ideas would be a great help!
p.s the database table is called tblPaper.
Thanks