Solved

How to change  connection string for a dataset the has an xsd file

Posted on 2009-07-05
1
1,042 Views
Last Modified: 2013-12-17
I made a dataset with its xsd file.I want to change connection string with parameter not changing directly app.config file.
0
Comment
Question by:nikavak
1 Comment
 
LVL 51

Accepted Solution

by:
Mark Wills earned 500 total points
ID: 24782490
XSD has a property called ConnectionModifier - think you have to change it to Public...

Have a quick read of : http://stackoverflow.com/questions/435444/changing-xsd-connectionstring-at-runtime-for-a-multitenant-app

Have you seen this : http://channel9.msdn.com/forums/TechOff/209406-Connection-String-for-Typed-Datasets/ it does ramble a bit, but there is a few solutions presented, and the final post is a step by step guide....  Also found this reference, though believe the connection string was read only, but there are some insights :  http://ryanfarley.com/blog/archive/2004/07/13/879.aspx
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

809 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