'find by last name. Create a query in the designer then call it

Private Sub btnSearch_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSearch.Click

        '---when they click the search toolbar button, get the records
        Dim name2Find As String = txtSearch.Text.Trim

        '---the Load method fills the tableadapter. It uses a Get method called GetDataByLastName
        'Right-click on the table adapter in the component tray & select edit queries in designer.
        CustomersTableAdapter.Load(_customers_03DataSet.Customers, name2Find)

    End Sub