Dim SqlConn As New SqlClient.SqlConnection(StrSqlConn)
SqlConn.Open()
Dim SqlCommand2 As New SqlClient.SqlCommand("delete from sherkatDetail", SqlConn)
SqlCommand2.ExecuteNonQuery()
SqlConn.Close()
SqlConn.Open()
Dim SqlCommand As New SqlClient.SqlCommand("insert into sherkatDetail (NAmeSh,Telsh, mobsh,adressSh,picsh) values('" & TextBox6.Text & "','" & TextBox3.Text & "','" & _
TextBox5.Text & "','" & TextBox4.Text & "', @pictureX)", SqlConn)
Dim ArrPic As Byte()
Dim ms As New IO.MemoryStream
Dim bmp As New Bitmap(PictureBox1.Image)
bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg)
ArrPic = ms.GetBuffer
ms.Close()
SqlCommand.Parameters.Add(New SqlClient.SqlParameter("@pictureX", SqlDbType.Image)).Value = ArrPic
SqlCommand.ExecuteNonQuery()
SqlConn.Close()