How to change the table adapter in an ObjectDataSource?

Posted on 2014-08-06
Medium Priority
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 40

Accepted Solution

lcohan earned 2000 total points
ID: 40244487
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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses
Course of the Month17 days, 6 hours left to enroll

862 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