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);
}
}