VB.net Image Upaditng Problems

Question

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

James Axsom · Answer

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 Venugopal · Answer

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.