How to configure app.config file in C#?

Question

I have my TCP port number, credentials and an IP address. How do I apply all of this to an app.config file to make it link to my database on another computer? I would like to apply it to my app.config file.

Pretty hard to say when we have no idea what your application does or why it would need a TCP anything. — John Wu, Aug 29 '17 at 02:51
Please elaborate as I'm pretty confused about what it is you're asking. — Kirk Woll, Aug 29 '17 at 02:51
@JohnWu Hi this does not require to know how the what the application does.. Im researched before and it mentioned i need TCP port number — Darren, Aug 29 '17 at 02:53
@KirkWoll I am asking how to configure the app.config file to link to the database i have on another server. Sorry for the typo in my question — Darren, Aug 29 '17 at 02:54
Maybe check [this article](https://www.codeproject.com/Tips/416198/How-to-get-Connection-String-from-App-Config-in-Cs). — John Wu, Aug 29 '17 at 02:56
connectionString="Data Source=ip adresss->project location.;Initial Catalog=Title;Integrated Security=True"/> — Darren, Aug 29 '17 at 02:59
If reading from config file (which so far looks like duplicate of question *as asked*) is not the problem you are facing make sure to [edit] your post to clarify what you know and what exactly you have problem with. If for example you looking for help constructing connection string make sure to show how other similar posts and https://www.connectionstrings.com/ did not solve your particular case. — Alexei Levenkov, Aug 29 '17 at 04:12

Xela · Answer 1 · 2017-08-29T03:04:13.210

0

Make sure System.Configuration is referenced in your project.

To add database configuration in your webconfig: eg:

<configuration>
    <startup> 
        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6" />
    </startup>
      <connectionString>
        <add name="MyDatabase" connectionString="[Your connection string]"/>
      </connectionString>
</configuration>

To access it from C#:

var connectionString = ConfigurationManager.ConnectionStrings["MyDatabase"];

edited Aug 29 '17 at 03:04

answered Aug 29 '17 at 02:53

Xela

2,322
1
17
32

Hi Xela how to i check if system.configuration is referenced to my project? – Darren Aug 29 '17 at 02:56
Is it related to the connectionstring? – Darren Aug 29 '17 at 02:57
Nope, connection string uses similar functionality, but connection strings are for Database connection settings. – Xela Aug 29 '17 at 02:59
Hi i think there is a misunderstanding i would like to link my database from another computer to my project... – Darren Aug 29 '17 at 03:00
The other computer is a computer will act as a server which will be on 24 hrs – Darren Aug 29 '17 at 03:03
Have a look at my updated answer, you can check if it is referenced by expanding the references item in your solution explorer and looking for it. – Xela Aug 29 '17 at 03:04
How do i obtain the connection string for the other computer? – Darren Aug 29 '17 at 03:30
What database engine are you using sql server? – Xela Aug 29 '17 at 03:31
MySql or i have phpmyadmin in the "server computer"@Xela – Darren Aug 29 '17 at 03:51
and i am using app.config not web.config – Darren Aug 29 '17 at 05:31

score 0 · Answer 2 · edited Aug 29 '17 at 06:20

0

Specify data source in connection string with IP as below

data source=ip\sever instance

edited Aug 29 '17 at 06:20

Gautam Savaliya

1,403
2
20
31

answered Aug 29 '17 at 03:46

Ranjit Powar

1
1

score 0 · Accepted Answer · answered Aug 29 '17 at 03:56

0

<?xml version="1.0"?>
<configuration>
  <connectionStrings>
    <add name="sampleConnString" 
    connectionString="Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword;"/>
  </connectionStrings>
</configuration>

The key is the Network Library=DBMSSOCN; which tells your code to connect using TCP/IP. 1433 is the defualt port used by SQL Server (assuming your database is SQL Server). TCP/IP is often the best for a firewalled environment.

answered Aug 29 '17 at 03:56

Abhay

928
1
10
28

Hi so if my TCP port number is different i put the port number there? – Darren Aug 29 '17 at 05:39
@Darren..provide some more information...your database? driver? – Abhay Aug 29 '17 at 05:46
not really sure but i was only told that my TCP port is using a certain number so how do i write for my TCP? My database is using SQL server but i am migrating it to mySQL – Darren Aug 29 '17 at 06:46
the port number i was given is 5000... – Darren Aug 29 '17 at 06:48
If you are connecting with SQL Server..then you can use above connection string..1) tcp:[\],......2)tcp:[\], (try these options in Data Source value) – Abhay Aug 29 '17 at 08:07

How to configure app.config file in C#?

3 Answers3