Geek asks and answers

What is the best method for handling a connection string in a windows form application?

My C # application uses DataSetand TableAdapters. They are created using the VS2008 GUI Tool.

Example:

Right click on project -> Add New Item -> DataSet

This method automatically adds the connection string to app.config.

But this is a complicated wired method for a connection string. I want to change the connection string in a simple way. But when I used the data set, the connection string is obtained from the application property. Is there any solution for this situation?

enter image description here

This is my string store in Settings.Designer.cs

    namespace WindowsFormsApplication2.Properties {


    [global::System.Runtime.CompilerServices.CompilerGeneratedAttribute()]
    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("Microsoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator", "9.0.0.0")]
    internal sealed partial class Settings : global::System.Configuration.ApplicationSettingsBase {

        private static Settings defaultInstance = ((Settings)(global::System.Configuration.ApplicationSettingsBase.Synchronized(new Settings())));

        public static Settings Default {
            get {
                return defaultInstance;
            }
        }

        [global::System.Configuration.ApplicationScopedSettingAttribute()]
        [global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
        [global::System.Configuration.SpecialSettingAttribute(global::System.Configuration.SpecialSetting.ConnectionString)]
        [global::System.Configuration.DefaultSettingValueAttribute("Data Source=SLCERT\\SQLEMK;Initial Catalog=TestDataBase;Integrated Security=True")]
        public string TestDataBaseConnectionString {
            get {
                return ((string)(this["TestDataBaseConnectionString"])); // this is the connection string get from the dataset's
            }
        }
    }
}

app.config contains

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <configSections>
    </configSections>
    <connectionStrings>
        <add name="WindowsFormsApplication2.Properties.Settings.TestDataBaseConnectionString"
            connectionString="Data Source=SLCERT\SQLEMK;Initial Catalog=TestDataBase;Integrated Security=True"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>
+5
source share
3 answers

, , /.

Web.config -

web.config app.config, .

. VS 2010

+6

JP Hellemons , - , ().NET 4.0. <connectionStrings/> , "DebugConnectionString" "ReleaseConnectionString" .

, , . , Visual Studio, DEBUG, , - :

#if DEBUG 
    return ConfigurationManager.ConnectionStrings["DebugConnectionString"];
#else
    return ConfigurationManager.ConnectionStrings["ReleaseConnectionString"];
#endif
+4

in app.config

<configuration>
<configSections>
</configSections>
<connectionStrings>
    <add name="DBCS" connectionString="Data Source=|DataDirectory|\Database.sdf;password=Password" 
        providerName="Microsoft.SqlServerCe.Client.3.5" /> 
</connectionStrings>

and access it as follows

static string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString.ToString();

turn on

System.Configuration;

Namespace

+2
source

More articles:


All Articles