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
Answers were Sorted based on User's Feedback
Answer / debolina
For Save Images:
Private Sub Save()
Dim strConn, strQuery As String
Dim cmd As SqlCommand
Dim img As Image
Dim imagedata As Byte()
Dim imgFormat As Imaging.ImageFormat
Dim myParameter As SqlParameter
Try
img = Image.FromFile(Me.txtImage.Text)
imgFormat = img.RawFormat
imagedata = ConvertImageToByteArray(img, imgFormat)
strQuery = "Insert into TBL_STUDENT
(STUD_NAME,SUBJECT,NUMBER,IMAGES) values ('" & txtName.Text
& "','" & txtSubject.Text & "'," & txtNumber.Text & ",@Image)"
strConn = //Your Connection String
conn = New SqlConnection(strConn)
cmd = New SqlCommand(strQuery, conn)
myParameter = New SqlParameter("@Image",
SqlDbType.Image, imagedata.Length)
myParameter.Value = imagedata
cmd.Parameters.Add(myParameter)
conn.Open()
cmd.ExecuteNonQuery()
MsgBox("Saved Successfully", MsgBoxStyle.OkOnly)
Catch ex As Exception
End Try
End Sub
Private Shared Function ConvertImageToByteArray(ByVal
imageToConvert As System.Drawing.Image, ByVal formatOfImage
As Imaging.ImageFormat) As Byte()
Dim Ret As Byte()
Try
Using ms As New MemoryStream()
imageToConvert.Save(ms, formatOfImage)
Ret = ms.ToArray()
End Using
Catch generatedExceptionName As Exception
Throw
End Try
Return Ret
End Function
For Retrieve:
Private Sub RetrieveImages()
Dim strConn As String
Dim cmd As SqlCommand
Dim da As SqlDataAdapter
Try
strConn = //Connection string
conn = New SqlConnection(strConn)
cmd = New SqlCommand("Select * from
TBL_STUDENT", conn)
da = New SqlDataAdapter(cmd)
ds = New DataSet
da.Fill(ds)
Catch ex As Exception
End Try
End Sub
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
Answer / surabhi
i also need this codding the coding written aboye is not
working plzzz help me
Is This Answer Correct ? | 0 Yes | 0 No |
Explain about the performance of visual basic?
Explain the observations between vb.net and vc#.net?
Thank you for replying to my Question regarding Barcodes in VB.net. My next question is that how to use Barcode Fonts in VB.net I need a small code to Generate Barcodes in VB.net from a string of Values. This is the only problem i am left with in my project. Any body can help me please.
What is the use of assembly?
What is the diff between vb mdi form and .net mdi form?
Explain the differences between vb.net and c#, related to oops concepts?
How do you define a read only property in a class module?
How to run a dos command in vb.net?
What is branching logic control in VB.NET?
what are the difference between An input box and Message box ..?
There are three versions of VB6--Learning Edition, Professional and Enterprise. Is VB.Net similar?
What is late binding?