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

Question

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.

yes, if i write:

Select * from player where number = '7';

its looking for semicolons after player and number.

Answer 1

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?