I am using a quary to search and show results in a databound DGV on the fly
Like so
(THIS WORKS FINE)
Code:
            Try
                Me.FilesTableAdapter.NewProfile(Me.FilesDataSet.Files, NameTextbox.Text)
            Catch ex As System.Exception
                System.Windows.Forms.MessageBox.Show(ex.Message)
            End Try
i need to know how to delete all the found results

i.e

If someone clicks a Delete Button on the form then it runs this quary and deletes all found results