objectDataSource Design question

objectDataSource Design question

am 15.01.2008 16:10:28 von palm

I am working on a product that has ~ 30 web pages. Each page has
various number of controls ( between 20 - 40 controls that include
gridview, text boxes, combo boxes etc). This product should have
ability to connect to different type of data sources ( Oracle, SQL
Server, mySQL etc). I am using ObjectDataSource to populate controls
on these pages. I am trying to minimize back and forth communication
between the pages and backend database. So i have createa stored
procuede that will gather all the data required on each page (meaning
one stored procedure per web page that give data needed by all
controls on a given web page). I am wondering what is the best way of
displaying this data by splitting rows return from stored procedure in
the ObjectDataSource. Any links, code examples or hints will be higly
appreciated.

TIA