How to change the table adapter in an ObjectDataSource?

Scarlett72
Scarlett72 used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

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

You can change DataTables in rdlc reports programmatically:
http://stackoverflow.com/questions/10124047/how-to-change-datatables-in-rdlc-reports-programmatically

You could also "Configure Data Source Properties for a Report "
http://msdn.microsoft.com/en-us/library/ms155882(v=sql.105).aspx

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