VB.net Image Upaditng Problems

Hello I am using Vb.net i want to update Image in PicturePox1 already image save and then when i click Datagirdview want to update but there Error "Empty path name is not legal".

Sub update()
If con.State = ConnectionState.Open Then
con.Close()
End If
con.Open()
qry = "Update Doc Set ID=@ID,IskaGade=@IskaGade,Aqoonsi=@Aqoonsi,Gate=@Gate,MarkhatiKowaaad=@MarkhatiKowaaad,MarkhatiLabaad=@MarkhatiLabaad,MarkhatiSadaxaad=@MarkhatiSadaxaad,Faahfaahin=@Faahfaahin,UserID=@UserID where RefNo=@RefNo"
cmd = New SqlCommand(qry, con)
Dim i As Short
cmd.Parameters.AddWithValue("@ID", txtid.Text)
cmd.Parameters.Add(New SqlClient.SqlParameter("@IskaGade", SqlDbType.Image)).Value = IO.File.ReadAllBytes(a.FileName)
cmd.Parameters.Add(New SqlClient.SqlParameter("@Aqoonsi", SqlDbType.Image)).Value = IO.File.ReadAllBytes(b.FileName)
cmd.Parameters.Add(New SqlClient.SqlParameter("@Gate", SqlDbType.Image)).Value = IO.File.ReadAllBytes(c.FileName)
cmd.Parameters.Add(New SqlClient.SqlParameter("@MarkhatiKowaaad", SqlDbType.Image)).Value = IO.File.ReadAllBytes(d.FileName)
cmd.Parameters.Add(New SqlClient.SqlParameter("@MarkhatiLabaad", SqlDbType.Image)).Value = IO.File.ReadAllBytes(ex.FileName)
cmd.Parameters.Add(New SqlClient.SqlParameter("@MarkhatiSadaxaad", SqlDbType.Image)).Value = IO.File.ReadAllBytes(fr.FileName)
cmd.Parameters.AddWithValue("@Faahfaahin", txtremarks.Text)
cmd.Parameters.AddWithValue("@Date", Date.Today.ToShortDateString)
cmd.Parameters.AddWithValue("@UserID", txtUserID.Text)
cmd.Parameters.AddWithValue("@RefNo", txtref.Text)
cmd.ExecuteNonQuery()
MsgBox("Record Updated Successfully")
filldatagrid()

Image Reader in Gridview

Sub readImageMarkhatithree(ByVal ID As String)
Dim dr As SqlDataReader, MyTest As Boolean = False
Dim sql As String
If con.State = ConnectionState.Open Then
con.Close()
End If
con.Open()
sql = "Select MarkhatiSadaxaad from Doc where id ='" & txtid.Text & "'"
cmd = New SqlCommand(sql, con)
cmd.CommandType = CommandType.Text
dr = cmd.ExecuteReader
Do While (dr.Read = True)
Dim bits As Byte()
bits = CType(dr.Item("MarkhatiSadaxaad"), Byte())
Dim memorybits As New MemoryStream(bits)
Dim bitmap As New Bitmap(memorybits)
Markhatisadaxaad.Image = bitmap
Markhatisadaxaad.SizeMode = PictureBoxSizeMode.StretchImage
Loop
dr.Close()
End Sub

I think Sankara is correct.

I think the problem may likely be occurring in one of the IO.File.ReadAllBytes.

As you may know, ReadAllBytes opens a file, converts it into a byte array, which how SQL Server stores an image. You pass the file path as string into ReadAllBytes, ReadAllBytes goes the to image per the path and converts it into a byte array. If the path string is empty its going to throw an error in your Update subroutine.

When the datagrid displays the image, its not getting a path to load the image, its getting the actual image stored in SQL Server. There is no path and no file to be opened.

So it seems to me that, a.FileName, b.FileName, c.FileName, d.FileName, ex.FileName or fr.FileName or any combination of these may be an empty string.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

James Axsom8y ago
I think Sankara is correct.

I think the problem may likely be occurring in one of the IO.File.ReadAllBytes.

As you may know, ReadAllBytes opens a file, converts it into a byte array, which how SQL Server stores an image. You pass the file path as string into ReadAllBytes, ReadAllBytes goes the to image per the path and converts it into a byte array. If the path string is empty its going to throw an error in your Update subroutine.

When the datagrid displays the image, its not getting a path to load the image, its getting the actual image stored in SQL Server. There is no path and no file to be opened.

So it seems to me that, a.FileName, b.FileName, c.FileName, d.FileName, ex.FileName or fr.FileName or any combination of these may be an empty string.
Sankara Krishnan Venugopal8y ago
HI,

It seems like the filename variable refers to an empty string. You should add the condition to resolve it.

Make sure, you are getting the image path from the variable. Hope this helps.