connection string in windows form in C#

Question

0.00/5 (No votes)

See more:

i Have 5 to 6 classes in which i am using connection string in windows form application is there any method to declare it only once and use directly. can we use singleton class for this? please give some example

Posted 18-Mar-12 22:43pm

Neha89

Add a Solution

7 solutions

Solution 1

One way to do that is to have a file for CONSTANTS and move all your constants in that file. This file will contain a static class and all the application wide constants can become public static members of this class.

Another way of doing this is to have it in application settings. Project properties->Settings. Here you can have the connectionstring and access it as:

C#

Properties.Settings.Default.CONSTRING

Posted 18-Mar-12 22:50pm

Rahul Rajat Singh

Comments

Neha89 19-Mar-12 4:58am

Do you have any sample code for creating file for constants?

Solution 3

Add your connection string in app.config file & use second method of Rahul Rajat Singh's solution.

Posted 18-Mar-12 22:53pm

Prasad_Kulkarni

Comments

Neha89 19-Mar-12 4:57am

i stored it in app.config but still

ConnectionStringSettingsCollection connectionStrings = ConfigurationManager.ConnectionStrings;
string connString = connectionStrings["Connect"].ToString();

this much part is repeated in all classes.

Solution 4

Belowing Code Help to you for making your connection string--------

SqlConnectionStringBuilder bu = new SqlConnectionStringBuilder();

bu.DataSource = "mySqlServer";

bu.InitialCatalog = "myDatabase";

bu.IntegratedSecurity = false;

bu.UserId = "UserName";

bu.Password = "myPassword";

SqlConnection Conn = new SqlConnection(bu.ConnectionString);

Posted 18-Mar-12 22:53pm

Rakesh Meel

Updated 18-Mar-12 22:54pm

v2

Solution 6

Hi,

Your Solution:
http://www.dreamincode.net/forums/topic/70745-connection-string-in-appconfig/[^]
http://www.csharp-station.com/Tutorials/AdoDotNet/Lesson02.aspx[^]
http://www.techimo.com/forum/webmastering-programming/168066-sql-connection-string-c.html[^]

Posted 18-Mar-12 23:39pm

MaulikDusara

Solution 7

As requested by the poster:

The file would look like: (contants.cs)

C#

namespace MyWinApplication
{
    static class Constants
    {
        public static string CONN_STRING = "the actual string";
        public static int MAX_USERS = 300;
        public static int MAX_DB_CONNECTIONS = 500;
    }
}

and the usage will be like:

C#

new SqlConnection(Constants.CONN_STRING);

Posted 19-Mar-12 0:26am

Rahul Rajat Singh

Solution 5

refer this

http://www.connectionstrings.com/[^]

Posted 18-Mar-12 22:55pm

Bojjaiah

Add a Solution

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

uspatel · Accepted Answer · 2012-03-18T22:51:00

PutConnection string in app.config as

HTML

<configuration>
    <configsections>
    </configsections>
    <connectionstrings>
        <add name="dbConnection">
            connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\App_Data\HREChk.mdf;Integrated Security=True;User Instance=True"
            providerName="System.Data.SqlClient" />
    </add></connectionstrings>
</configuration>

and access this as

C#

String connString = ConfigurationManager.ConnectionStrings["dbConnection"].ToString();

See this Example also
Connection string in app.config

connection string in windows form in C#

7 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Solution 6

Solution 7

Solution 5

Add your solution here

Preview 0

connection string in windows form in C#

7 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Solution 6

Solution 7

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us