The solution.
Private Sub Find_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Find.Click
If txtboxLastName.Text <> "" Then
Try
Me.Table1TableAdapter.FillBy(Me.AmDBDataSet.Table1 , txtboxLastName.Text + "%")
Catch ex As System.Exception
System.Windows.Forms.MessageBox.Show(ex.Message)
End Try
In the query builder type: SELECT * From Table WHERE LastName LIKE ?
|