0

I am trying to write a small application in C#, where I need to connect to SQL to fetch some data, for that I need SQL user id and password, for same client there are other applications running which gets connected to SQL Server and have config file in encrypted form. I am not very good in C# and .Net, and have difficulty of understanding these concepts, I tried to search in post for answers but didn't get any suitable reply for my question. Can I use that already in use config file in my new project, and read user is and password information which are in encrypted form and use to connect to SQL server?

Any good stuff for understanding the use of config files in C# will be much appreciated, with good examples.

Almas Mahfooz
  • 896
  • 1
  • 10
  • 19

4 Answers4

0

Look at: How to set SQL Server connection string?

the example is for MSSQL, for others it will be nearly the same.

user1519979
  • 1,854
  • 15
  • 26
  • Thanks for your reply, but actually I want to reuse the config file having encrypted user id and password, read those user id and password from config file of other application and use in my code to connect to SQL server,I have no issue in SQL connection as with hard coded values, it is working perfect. – Almas Mahfooz Jun 07 '18 at 09:19
  • just join these informations and set it as connectionstring: e.g.: conn.ConnectionString = "Data Source=" + ipAddress + ";Initial Catalog=" + databaseName + ";User id=" + decryptedUser + ";Password=" + decryptedPassword +";"; – user1519979 Jun 07 '18 at 09:21
  • Please see if my answer helped you!? – Pikachu620 Jun 07 '18 at 09:26
0

If you have administrative access to the SQL server, you can create an account that you can use for your connection.

If you have no admin rights, then you have to ask the admin to create an account for you... or tell you the credentials you can use.

PepitoSh
  • 1,774
  • 14
  • 13
0

In the app.config, add the follow lines inside the <configuration>:

<connectionStrings>
  <add name="PWD" connectionString="#$@AERG#$"/>
</connectionStrings>

And in the main program:

  1. Add the reference System.Configuration through the Project Manager.
  2. Add using System.Configuration; in the using segment.
  3. use ConfigurationManager.ConnectionStrings["PWD"].ToString() to access the encrypted password in the config file.

Please change it accordingly to fit your purpose!!!

Good luck!!!

Pikachu620
  • 483
  • 4
  • 17
  • instead of putting encrypted password in config file can't I read it directly from the config file of other application like, EMailSetting.config is a config file, it has settings related to email, my app is also sending email and will use same information for sending email as in EMailSetting.config. – Almas Mahfooz Jun 07 '18 at 10:54
0

Use this function

 /// <summary>
            /// Get values of the connection string in the following order :
            /// Server , Database,
            /// If the length of the list is 3 then the 3rd object is True (Integrated Security)
            /// If it is 4 then the 3rd object is the 3rd object is the username and the 4th is the password.
            /// 
            /// </summary>
            /// <returns></returns>
            public static List<string> GetCurrentConnectionString()
            {
                try
                {
                    List<string> lstConnStrData = new List<string>();
                    string[] aryConnStrData = new string[1];
                    // OPen the Config file as XML document and loop over it.
                    XmlDocument XmlDoc = new XmlDocument();
                    //Loading the Config file
                    XmlDoc.Load(AppDomain.CurrentDomain.SetupInformation.ConfigurationFile);
                    foreach (XmlElement xElement in XmlDoc.DocumentElement)
                    {
                        if (xElement.Name == "connectionStrings")
                        {
                            //setting the coonection string
                            aryConnStrData = xElement.ChildNodes[1].Attributes[1].Value.Split(';');
                            break;
                        }

                    }

                    // Now loop over the array that holds the conn str data and split each item on "=",
                    // and add the second splitted item to the list, so at the end the list will contains 
                    // the values of the connection string.

                    for (int i = 0; i <= aryConnStrData.Length - 2; i++)
                    {
                        lstConnStrData.Add(aryConnStrData[i].Split('=')[1]);
                    }
                    return lstConnStrData;
                }
                catch (Exception)
                {

                    throw;
                }
            }

OR

   public static List<string> SplitConnectionString(string ConnectionString)
    {
        try
        {
            List<string> lstConnStrData = new List<string>();
            string[] aryConnStrData = new string[1];

            aryConnStrData = ConnectionString.Split(';');

            // Now loop over the array that holds the conn str data and split each item on "=",
            // and add the second splitted item to the list, so at the end the list will contains 
            // the values of the connection string.

            for (int i = 0; i <= aryConnStrData.Length - 2; i++)
            {
                lstConnStrData.Add(aryConnStrData[i].Split('=')[1]);
            }
            return lstConnStrData;
        }
        catch (Exception)
        {

            throw;
        }
    }
Plexis Plexis
  • 302
  • 2
  • 12