i dont know how insert images on databases on visual basic 2008

Question

i'm beginner on visual basic 2008. i'm designing a database for my personal use, however i need to use one image for each one raw of my database, so i created a column named "images" and in data type "image". my problem is that in other columns i can directly write depending of the data type (by example on nvarchar (50)), but i don't know how insert directly or indirectly each one image for each raw.
thanks

Crish · Answer

Hi I had same problem . To solve this problem you can go for below link. http://www.vbdotnetheaven.com/UploadFile/rohatash/3876/Default.aspx

Hirendra Sisodiya · Answer

you can use this code: Private Sub FindImageInByte() Dim oFile As System.IO.FileInfo oFile = New System.IO.FileInfo(Filename) Dim oFileStream As System.IO.FileStream = oFile.OpenRead() Dim lBytes As Long = oFileStream.Length If (lBytes > 0) Then Dim fileData(lBytes - 1) As Byte oFileStream.Read(fileData 0 lBytes) oFileStream.Close() SaveToDB(fileData) End If End Sub Private Sub SaveToDB( ByVal memStreamOrg As Byte ()) Dim sqlConn As New SqlClient.SqlConnection sqlConn.ConnectionString = Put your connection string sqlConn.Open() Dim Command As New SqlClient.SqlCommand( Insert into tblImage (Image_Temp) values( @PicOrig )  sqlConn) Dim PicOrig As SqlClient.SqlParameter PicOrig = New SqlClient.SqlParameter( @PicOrig  SqlDbType.Image) PicOrig.Value = memStreamOrg Command.Parameters.Add(PicOrig) Command.ExecuteNonQuery() sqlConn.Close() End Sub thanks

Hirendra Sisodiya · Answer

hello Eduarodo sql image column accept only binary data you you need to convert image into byte() data. thanks