HI ,
i'm using VB.net 2003 with sql server 200 database . I'm storing images in database , it's working fine. but when the Database size is bigger, Now it's working very Slow, My Code is Below , the image displayed in Picture Box is Stored in Database.
Dim msImage As New MemoryStream
picture1.Image.Save(msImage, picture1.Image.RawFormat)
Dim arrImage() As Byte = msImage.GetBuffer
' Close the stream object to release the resource.
msImage.Close()
strsql = "INSERT INTO tblDesignDetails (imgDesign)" _
& " VALUES (@Picture)"
'' A SqlCommand object is used to execute the SQL statement.
cmd = New SqlCommand(strSQL, Cn)
With cmd
.Parameters.Add(New SqlParameter("@Picture", SqlDbType.Image)).Value = arrImage
end with
Thanx in Adv
Ganesh