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