Hi Gary,
For a single DataSet, you can select "Configure" menu on the Dataset
designer to open the "TableAdapter Configuration Wizard" and select
"Previous" steps to reconfigure the database connection string.
I understand that you have lots of DataSet, which is tedious to
re-configure each DataSet. However, there're no user interface could let
you easily change all DataSet's database name. Given that the .xsd file is
also a text file, I think you can use find/replace to change the database
name manually:
1) Backup files if necessary
2) Close all documents in VS2005
3) Select all your .xsd files in Solution Explorer and right-click, select
"View Code"
4) Use menu "Edit/Find and Replace/Replace in Files", choose "All open
documents" in "Look in" field; and replace accordingly: based on my test,
you should only need to replace
DbObjectName="Paris.
with
DbObjectName="Milan.
Hope this helps.
Regards,
Walter Wang (
[email protected], remove 'online.')
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
