Get a file from database - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Get a file from database

pechaspechas Posts: 1Member
I am writting a console application. I would like to pick up a file from my sql database by using a filepath that is written in a tabell in the databas. For exampel;
My tabell is named: File_Path
and the value in it are: 2005/10/563/123.xml
How can I pick up that file? I would like to use it by taking that file and make it a pdf.

Thank you

/Pechas

Comments

  • bradwangbradwang Posts: 197Member
    : I am writting a console application. I would like to pick up a file
    : from my sql database by using a filepath that is written in a tabell
    : in the databas. For exampel;
    : My tabell is named: File_Path
    : and the value in it are: 2005/10/563/123.xml
    : How can I pick up that file? I would like to use it by taking that
    : file and make it a pdf.
    :
    : Thank you
    :
    : /Pechas
    :

    Hello Perchas,

    First of all, you need to read the file path from your my sql database which I suppose you are capable of. Then you could load the xml file you have into a DataSet object. Here I have found an article for you: http://www.developerfusion.co.uk/show/4266/ which is using the Crystal Report dlls to generate PDF file from DataSet.

    Hope this helps and happy programming...

    Brad Wang
    .NET Freelancer from China
Sign In or Register to comment.