Retrieve a pdf document from database

[Lokesh M]

How can I retrieve a pdf document from database. Can any one give a query to save and retrieve pdf document?

NOTE : [This question was asked by Naresh]

[Barbie]

pdf can be stored in database as BLOB.

[Rajani]

Barbie

Thanks for the hint
Can you post one sample code
The associated queries such as to save/update pdf's and also
How to retrieve pdf and show it in frontend?

Thanks in adv
Rajani

[Barbie]

Copy the file contents in a byte array using the file stream and insert the byte array into the database.
The code will does it:

FileStream fls=new FileStream(filename);
byte[] blob=new byte[fls.Length];
fls.Read(blob,0,System.Convert.ToInt32(fls.Length));
string query="insert into applicant(name,resume) values(" + txtname.Text + "'," + blob+")";
OracleCommand cmd=new OracleCommand(query,conn);
cmd.ExecuteNonQuery();

For retreiving, get it in a byte array(using select stmt) and display it.

[Lokesh M]

Thanks for the sample code Barbie !

[Rajani]

WOW, This is really quick and cool, Thanks a ton Barbie... Way to go

Cheers
Rajani