Searching for data in a table...HOW?

There is going to be data put into a textbox and I need to be able to search through a SQL Server table and have it find it then return that record. Does anyone know how to do that? I have NEVER done it before. Any help would be GREAT! Thanks!

Brenda

The SQL Query you use to populate your dataset, would be something like

VB Code:

"SELECT * FROM tablename WHERE fieldname LIKE '%" & TextBox1.Text & "%';"