Microsoft Acces and Datagrid

Question

Here's all I want to do: connect to an ms access db do a SQL query (based on a search string entered in a text box) get results bind them in a datagrid can anyone guide me on how to do this? i have some code on how to do it but its based on a sqLconnection. I have included the sample. maybe someone can modify this code from a sql to a micrsoft connection. //Modify this string to correctly connect to your SQL Server. static SqlConnection con = new SqlConnection("server=YourServerName;uid=YourUserId;pwd=YourPassword;database=pubs"); SqlDataAdapter daAuthors = new SqlDataAdapter("Select * From Authors", con); DataSet ds = new DataSet(); DataView dv; CurrencyManager CM; thnx