public static DataTable Search(String searchQuery, String searchField, IDbConnection conn, String sql)
{
DataBaseSearch d = new DataBaseSearch();
d.exactPhraseSearch = false;
DataSet ds = d.ExecuteSqlStatement(conn, sql);
return(d.SearchHelper(searchQuery, searchField, ds));
}
public static DataTable Search(String searchQuery, String searchField, DataTable dt)
{
DataBaseSearch d = new DataBaseSearch();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
return(d.SearchHelper(searchQuery, searchField, ds));
}
public static DataTable Search_UseStorProc(String searchQuery, String searchField, IDbConnection conn, String SP_name, bool exactPhraseSearch)
{
DataBaseSearch d = new DataBaseSearch();
d.exactPhraseSearch = exactPhraseSearch;
DataSet ds = d.ExecuteStoredProcedure(conn, SP_name);
return(d.SearchHelper(searchQuery, searchField, ds));
}