Microsoft Acces and Datagrid
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