I have a gridview that I have bound to a DataSet that displays a customer's address information. (Select FNAME, LNAME, STREET, CITY, STATE, ZIP FROM CUSTOMERS)
I have a textbox that a user will type a search criteria into and click a button. What I am trying to do is run the sql again with that criteria applied and return the results to the user by updating this GridView.
This should be simple and I have done it before in Access. But, I am stumped right now and could use some help.
Table adapter is named CUSTOMERSTableAdapter
Binding source is named CUSTOMERSBindingSource
Data set is named ECOMLIVEDataSet
If my button was named btnCustomerSearch, what code should execute on the _click event to revise the SQL?
Thanks in advance. Maybe somebody can point to a tutorial online somewhere or help explain this.