public static DataSet getProductList(string strWhere, int PageIndex, int NumberofRowsRetrieved, string SortColumn, int SortOrder)
{
DataSet ds = null;
try
{
DAL.DataProvider.SqlClientProvider oSqlClientProvider = new DAL.DataProvider.SqlClientProvider();
ds = oSqlClientProvider.GetProductListWithPagingAndSorting(strWhere, PageIndex, NumberofRowsRetrieved, SortColumn, SortOrder);
}
catch (System.Data.SqlClient.SqlException Exp)
{
//bool rethrow =
// ExceptionPolicy.HandleException(Exp, "StoreLocator Data Policy");
//if (rethrow)
//{
// throw;
//}
}
return(ds);
}