Search for a Specific Record in a DB

[bigz60]

Hello.

I am working with vb 2005 express and ms sql server 2005 db.

I have a form with several textboxes and comboboxes, etc. I have a binding navigator that is working fine for flipping one by one through the dataset.

I would like to add a button that would allow me to search the database for specific records by entering text into one or more of the textboxes.

For example, instead of flipping through all 200 records until I find John Doe, I would like to be able to enter Doe in the last name field and John in the first name field and pull up all records that satisfy the search criteria.

I am not sure if this is an easy task or not, but it will be needed as the dataset is growing larger every day.

Thanks in advance for any guidance.

 

[chiph]

In SQL Server Books On Line, investigate the SELECT keyword.

Chip H.


____________________________________________________________________
If you want to get the best response to a question, please read FAQ222-2244 first

 

[bigz60]

I will do. Thank you.

 

[PRPhx]

Also do a google search for parameterized queries. You will need to pass to your SELECT statement a parameter(s) to filter your select statement.
You will need to set up your parameters in your application, which in turn passes the info to your query.