CODEWITHSUNDEEP
c#
Deb Kumer
Deb Kumer

Reputation: 33

How can i save my connection string form to app config file?

I want to save my full path connection string 

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;User ID=myUsername;Password=myPassword;

in my app.config file's connection string section from C# Windows Forms textbox.

Like this:

<connectionStrings>
    <add name="TRN_DB"
         connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;Jet OLEDB:System Database=system.mdw;User ID=myUsername;Password=myPassword;providerName="System.Data.OleDb"/>
</connectionStrings>

Upvotes: 1

Views: 255

Answers (1)

Akbar Asghari
Akbar Asghari

Reputation: 691

hi please check this page

but you can't modify it because it's read only and you get this error

System.Configuration.ConfigurationErrorsException: 'The configuration is read only.'

you can show connectionString in TextBox with this code 

var connection = System.Configuration.ConfigurationManager.ConnectionStrings["TRN_DB"].ConnectionString;

Upvotes: 1

Related Questions