How to store jpeg / gif / bmp image in database and how to
retrieve them? The most stressful condition is database is
distributed and stored images can be retrive from any
computer in network and any one can store images from other
computer!! plss help its urgent.......RAHUL RATHOD
Answer Posted / raj
Hi Rahul,
if you want to save image in SQL Server DataBase,
first we have to convert that image into bytes(BCoz SQL
Server support byte format).
using system.io.iostream we can convert image into stream
of bytes.
For example :
stfFilename is path that contain your image.
Public Shared Function LoadImage(ByVal stfFilename As
String) As System.Drawing.Image
Dim oStream As System.IO.Stream
Dim oAssembly As System.Reflection.Assembly
oAssembly = System.Reflection.Assembly.GetEntryAssembly
oStream = oAssembly.GetManifestResourceStream(stfFilename)
Return System.Drawing.Image.FromStream(oStream)
End Function
for retrieving image from DB just reverse concept.
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is multiple form in vb?
What are the different types of Lock available in Visual Basic?
What is the difference between c# and vb.net?
Explain the advantages of migrating to vb.net?
What is the purpose of objects present in asp.net?
What are the differences between server-side and client-side code?
What is a literal control?
What are the two main parts of .net?
Write program in VB.Net with SQL Server and Crystal Reports to develop a small windows application to add,edit,save, search and print Employee Information and send sourcecode as zip file. empcode : .............. empname : .............. dateofjoin : dd/mm/yyyy dateofbirth : dd/mm/yyyy TableName: EmpMaster EmpCode EmpName DOB DOJ TableName: EmpDocs EmpCode DocNo DocName ExpDate
What is the difference between value and reference types?
Define clr?
Which control is an example of an object in vb net?
What is branching logic control in VB.NET?
What is difference between metadata and manifest?
What would you do to remove microsoft visual basic name space?