In C# how to i query from an access database using a Windows Application?

ok I have a Windows app thats hooked up to an access database and i want the user to type in a football players name in a textbox, push a button and have it select the players info from the database (first name, last name, number, etc) right now i can see the whole table with all the info filled in on the datagrid when i run the app. I can get everything else to work except the select statement.In C# how to i query from an access database using a Windows Application?
What happens when you execute the query? Do you get an error, or what?





Edit:





Within that SQL query you should not need to have a semicolon. What is the c# code in which you are calling that query, and what is the error?