PDF File In SQLSERVER

Question

Hi friends What is the procedure to store pdf file in SqlServer? Explain it?

Javeed M Shaikh · Answer

Hi Michell You have to create the table with dataype Image and then while passing the data to the stored procedure you need to do the following: cmd.Parameters.Add(new SqlParameter(@PDFData here you have to provide the byte array of pdf file)); This is how you create the byte array: byte[] bytes = System.IO.File.ReadAllBytes(myfile.pdf); Please do not forget to mark Accepted Answer.