C# how to set SQL database connection string runtime from text file

Question

1.00/5 (1 vote)

See more:

dear all
i have win form application using entity framework and create a connection string then export this connection to c:/folder name/CN.txt as " Server =CAVE; Database = IT_Manager; Trusted_Connection = True ;" i need to read the connection from text file when load login form if folder , file and valid connection exist run app with this connection else load connection string form to save the connection

What I have tried:

//app config

< connectionStrings>
     <add name="GYM_AdminEntities"  connectionString="metadata=res://*/Entities.Entities.csdl|res://*/Entities.Entities.ssdl|res://*/Entities.Entities.msl;provider=System.Data.SqlClient;provider connection 
     string="data source=CAVE;initial catalog=GYM_Admin;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework""
    providerName="System.Data.EntityClient" />
  </connectionStrings>
// class
public SetConnection()
        {
            config = 
               ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
        }


        public string getconnectionstring(string key)
        {
            return config.ConnectionStrings.ConnectionStrings[key].ConnectionString;
        }


        public void saveconnection(string key , string value)
        {
            config.ConnectionStrings.ConnectionStrings[key].ConnectionString = value;
            config.ConnectionStrings.ConnectionStrings[key].ProviderName = 
            "System.Data.EntityClient";
            config.Save(ConfigurationSaveMode.Modified);
        }
//   code
       string txtcn = File.ReadAllText(@"C:\GYM Admin\CN.txt");
                    Controls.SetConnection conn = new Controls.SetConnection();
                    conn.saveconnection("GYM_AdminEntities", txtcn);

Posted 16-Sep-18 11:20am

Wessam A Halim

Updated 18-Sep-18 12:08pm

v8

Add a Solution

Comments

[no name] 16-Sep-18 20:26pm

You need to show what you've tried. I don't see anything in that question that shows that you've attempted to solve this yourself. Use string[] lines = File.ReadAllLines("Path To File"); to read the file. using System.IO required.
Please update your question to show some effort.

Wessam A Halim 16-Sep-18 21:33pm

sorry i tried more than 10 code to update app config with new connection string text but i have error in all so i past the last one ... i'm update it now

2 solutions

Solution 1

This is a bit overkill for your application, but it's the way I do it: Instance Storage - A Simple Way to Share Configuration Data among Applications[^]

The simple way is just to add a Settings string to your app and load it from Properties.Settings.Default.MyConnectionString: Using Settings in C#[^]

Posted 16-Sep-18 19:44pm

OriginalGriff

Comments

Wessam A Halim 17-Sep-18 7:09am

i tried to create class to get and set connection from app config the ((code updated ))
but still didn't change anything in app config without errors

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wessam A Halim · Accepted Answer · 2018-09-18T12:08:00

this is the best solution to save the connection in local config file
using the same class (set connection )

          conn.Open();
      Controls.SetConnection con = new Controls.SetConnection();

con.saveconnection("Name",string.Format(@"metadata=res://*/Entities.Entities.csdl|res://*/Entities.Entities.ssdl|res://*/Entities.Entities.msl;provider=System.Data.SqlClient;provider connection string=""{0}; integrated security = True; MultipleActiveResultSets = True; App = EntityFramework""", ConnectionString));

      Application.Restart();