public OleDbDataReader SearchIterm(string cmd, string databasePath) { //access "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" //"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" (open .accdb database) //OleDbConnection cn = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + databasePath); DbHelp dbmanage = new DbHelp(EnumDbType.DbSqlServer, "server=NOLAN-DEBUG-PC\\SQLEXPRESS1;database=test;Trusted_Connection=SSPI;"); try { //cn.Open(); //OleDbCommand myCmd = new OleDbCommand(cmd, cn); //OleDbDataAdapter oda = new OleDbDataAdapter(myCmd); OleDbDataReader adr = (OleDbDataReader)dbmanage.ExecuteReader(cmd); return(adr); } catch (Exception openerror) { return(null); } }