How to change connection string in DataSet.xsd?

c# connection-string database-connection
Gold picture Gold · Feb 10, 2010 · Viewed 64.3k times · Source

I have build my project in C#, I add DataSet.xsd, and connect him to

Oracle DataBase in my computer - work Excellent !!!!

When I installed on the customer computer (that connect to his Oracle DataBase) -

it crushed.

I need to change the connection string on the DataSet.xsd file - but how to do it ?

Is there any xml file ? Or configuration file ?

Thanks in advance.

Answer

Qwerty.ie picture Qwerty.ie · Jun 8, 2011

You can also open the Dataset and select the TableAdapter that you want to update, right click and go to properties.

here you will see a "connection" property that you can easily change to settings in your web.config file or enter new connection details.

Related questions

How to fix "The ConnectionString property has not been initialized"

When I start my application I get: The ConnectionString property has not been initialized. Web.config: <connectionStrings> <add name="MyDB" connectionString="Data Source=localhost\sqlexpress;Initial Catalog=mydatabase;User Id=myuser;Password=mypassword;" /> </connectionStrings> …

Read More
SQL Express connection string: mdf file location relative to application location

I am using SQL Express databases as part of a unit test project in c#. My databases is located here: ./Databases/MyUnitTestDB.mdf I would like to use a relative path or variable in the app.config rather than having …

Read More
Persist Security Info Property=true and Persist Security Info Property=false

For the properties: Persist Security Info=true and Persist Security Info=false Can you tell me what is the difference between them, and if I don't put it in my connection what will happen? connect.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0; …

Read More