Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ObjectDatasource - Does it support multiple data tables?

Thread Tools

ObjectDatasource - Does it support multiple data tables?

Posts: n/a

I'm working with the ObjectDatasource and the application is getting more
and more chatty. Is there a way I could make the ObjectDatasource support
multiple DataTables that could be retrieved as one Dataset? I'm wondering
how others out there work with ObjectDatasource?

The only option I now see to get this fixed is to manually make the call to
the Web services, retrieve the Dataset and assign the datatable to the
controls (Or can I just assign it to the ObjectDataSource?)


Reply With Quote
Steven Cheng[MSFT]
Posts: n/a
Welcome to ASPNET newsgroup Felix,

As for the multiple data tables query with objectdatasource, do you mean
that the query used by your datasource will need to cover mutiple tables or
you just need to query multiple tables to local side and cache them so that
objectdatasource can use later? IMO, since objectdatasource control is
used to bind our databound server control with some custom data access
component classes, we can consider the customization on the data access
component class. In our custom data access component class, we can
encapsulate the internal mutiple data query or caching in the class and
call them through your exposed methods (select, update ....). e.g:

we can have class named OrderDAO which is used to manipulate Order datas
which will refer to other table like customer, order details..... Then,
we can define some private methods on the OrderDAO class such as an Init
method which is called by the class once(in constructor or in Select
method) when necessary, it will access database and read multiple data
tables and cache the results (datatables) in applciation cache for
sequential use....

So how you customize the Data Access component class is up to you, this is
the most flexible function objectdatasource has provided us.


Steven Cheng
Microsoft Online Support

Get Secure!
(This posting is provided "AS IS", with no warranties, and confers no

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
ObjectDataSource Call MaxRowCount multiple times tshad ASP .Net 0 02-06-2010 01:00 AM
ObjectDataSource and GridView SortExpression with multiple columns problem Bogdan ASP .Net 1 07-31-2009 09:54 AM
one objectdatasource for multiple listboxes bugmenot ASP .Net 0 02-26-2008 03:48 AM
PDM does not support multiple uses of a given Maciej Krzeminski Cisco 4 08-05-2006 11:23 PM
ObjectDataSource method as another ObjectDataSource David Thielen ASP .Net Web Controls 3 03-23-2006 01:50 AM