DotNetShoutout

Welcome!

DotNetShoutout is a place where you can find the latest Microsoft .NET stories to increase your skills and share your opinions.

Enjoy participating in this community and see which other people in our industry are getting Shoutouts.

faq »

7
Shouts

Shout it

Web 2.0 | Reading and Writing BLOB Data to MS SQL or Oracle Database

published 888 days, 14 hours, 57 minutes ago posted by

farooqkaiser 889 days, 6 hours, 33 minutes ago

In this article, i will examine how to store and retrieve binary files such as image or PDF into MS SQL or Oracle database. Reading a File into a Byte Array 1:byte[] mbarrImg = null; 2:using (FileStream fs = new FileStream(FileName, FileMode.Open, FileAccess.Read, FileShare.Read)) 3: { 4: mbarrImg = newbyte[fs.Length]; 5:int iBytesRead = fs.Read(m_barrImg, 0, (int)fs.Length); 6: fs.Close(); 7: }

Saving BLOB data from a file to Oracle