How to change the table adapter in an ObjectDataSource?

Posted on 2014-08-06
Last Modified: 2014-08-11
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?
Question by:Scarlett72
    1 Comment
    LVL 39

    Accepted Solution

    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.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Introduction Earlier I wrote an article about the new lookup functions ( that ship with SQL Server 2008 R2.  In this article I’m going to show you another new feature of SSRS 2008 R2, this time in the vis…
    Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
    This video discusses moving either the default database or any database to a new volume.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now