In my Data Access Layer (i'm using a dataset), I have a couple of queries that retrieves different columns from a database table. Meanwhile, I have a business logic layer which have one method that based on input parameters, selects one of the queries from the DAL.
Now, I wish to use an object data source as the data source for a gridview on my webpage due to how easy it is to implement paging and sorting. However, it seems that the select method for the object data source goes directly to the data access layer as opposed to the business logic layer.
Is it possible to point the select method of the object data source to the method in the BLL? Or am I stuck with making multiple object data sources for the different queries I have in the DAL?