Member Avatar for sadhawan

Hi guys,
can anyone tell me how can i store pdf files and images in sql databse.
Thanks

  • 2 Contributors
  • 2 Replies
  • 57 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by sadhawan
Member Avatar for nick.crane

You will need to read the file in to a byte array; try using System.IO.File.ReadAllBytes(filename); Then pass this as a parameter to a varbinary(MAX) column in you DB.
Don't forget to store the filename and extension; if you store them seperately you will later be able to sort/filter on file type much easier.

Edited by nick.crane because: n/a
Member Avatar for sadhawan

is there an example that you can show me.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.