Hi,

Just wonder how can i delete an entire row at once in sql server database including images and textfields.

i mean, if i have an update button for inserting images and i have got another navigator which adds information to the database, how could i delete a selected row in sql server database...

In dataset, i used to remove a specific row in database by doing:

me.customersbindingsource.removecurrent()
So, this one doesn't delete anything when the image is included.

1.
Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
2.
Dim pictureLocation As String
3.
Dim a As New OpenFileDialog
4.
a.Filter = ("Image files| *.jpg")
5.
pictureLocation = a.FileName
6.
a.ShowDialog()
7.
Using conn As New System.Data.SqlClient.SqlConnection("Data Source=MUSTAFA\MUSTAFA;Initial Catalog=TestMe;User ID=sa;Password=123")
8.
conn.Open()
9.
Using cmd As New SqlClient.SqlCommand("update customers set picturem=@picturem ", conn)
10.
cmd.Parameters.Add(New SqlClient.SqlParameter("@picturem", SqlDbType.VarBinary)).Value = IO.File.ReadAllBytes(a.FileName)
11.
cmd.ExecuteNonQuery()
12.
End Using
13.
End Using
14.
End Sub


Regards,
Hossy