ObjectDataSource usage
-
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. I have createad stored procedure 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
modified on Tuesday, January 15, 2008 4:05:00 PM
-
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. I have createad stored procedure 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
modified on Tuesday, January 15, 2008 4:05:00 PM
You have been around here long enough to know that reposting the same question draws the ire of everyone here. Saying it is repost is helpful for us to ignore you. The same goes for URGENT.
only two letters away from being an asset
-
You have been around here long enough to know that reposting the same question draws the ire of everyone here. Saying it is repost is helpful for us to ignore you. The same goes for URGENT.
only two letters away from being an asset
-
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. I have createad stored procedure 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
modified on Tuesday, January 15, 2008 4:05:00 PM
Your problem is that the ObjectDataSource is the aborted whoreson of satan. You really shouldn't use it - in any way at all. It just binds your datasource to the UI and that's bad news - you're just asking for trouble with scalability. Instead, consider separating your UI from the business layer and the data layer. This way you can have much more control over how the data is retrieved, how you page it, and so on.
Deja View - the feeling that you've seen this post before.
-
Your problem is that the ObjectDataSource is the aborted whoreson of satan. You really shouldn't use it - in any way at all. It just binds your datasource to the UI and that's bad news - you're just asking for trouble with scalability. Instead, consider separating your UI from the business layer and the data layer. This way you can have much more control over how the data is retrieved, how you page it, and so on.
Deja View - the feeling that you've seen this post before.
Pete O'Hanlon wrote:
ObjectDataSource is the aborted whoreson of satan
Don't sugar coat it, let it out :laugh: :laugh:
only two letters away from being an asset