How to change the table adapter in an ObjectDataSource?

Scarlett72 used Ask the Experts™
Hi I have a reportviewer / .rdlc control in and aspx page.  the reportdatasource is objectdatasource1 and typename is tableadapter1,datatable1  I would like to change the datasource for this report and point it to tableadapter2.datatable2

Is this possible?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Analyst
You can manually edited the *.rldc file in a text editor and edit/update the XML.

You can change DataTables in rdlc reports programmatically:

You could also "Configure Data Source Properties for a Report "

but I think if you know what exactly needs to change the WordPad editor on that server where the *.RDLC exists should be sufficient.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial