The code snippet for creating a connection string programmatically in .NET C# follows:
/*
// Opening the configuration file for a DLL, i.e. %ProgramFiles%\Memba\Velodoc\Management Console\Memba.Console.dll.config
ExeConfigurationFileMap objExeConfigurationFileMap = new ExeConfigurationFileMap();
objExeConfigurationFileMap.ExeConfigFilename = System.Reflection.Assembly.GetExecutingAssembly().Location + ".config";
Configuration objExeConfiguration = ConfigurationManager.OpenMappedExeConfiguration(objExeConfigurationFileMap, ConfigurationUserLevel.None);
*/
// Opening the configuration file for an executable, i.e. C:\Windows\System32\mmc.config
Configuration objExeConfiguration = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
// Creating a connection string element from the connection string in web.config
ConnectionStringSettings objConnectionStringSettings = new
ConnectionStringSettings(
"MyDatabase",
"Data Source=.;Initial Catalog=MyDatabase;Integrated Security=True;Connect Timeout=30",
"System.Data.SqlClient"
);
// Get the connection strings section
ConnectionStringsSection objConnectionStringsSection = objExeConfiguration.ConnectionStrings;
// Add the new element
objConnectionStringsSection.ConnectionStrings.Clear();
objConnectionStringsSection.ConnectionStrings.Add(objConnectionStringSettings);
// Save the configuration file
objExeConfiguration.Save(ConfigurationSaveMode.Modified);
// Refresh and check
ConfigurationManager.RefreshSection(objConnectionStringsSection.SectionInformation.Name); // IMPORTANT!
Debug.Assert(ConfigurationManager.ConnectionStrings.Count == 1);
Debug.Assert(ConfigurationManager.ConnectionStrings[0].Name == objConnectionStringSettings.Name);
Debug.Assert(ConfigurationManager.ConnectionStrings[0].ConnectionString == objConnectionStringSettings.ConnectionString);
Debug.Assert(ConfigurationManager.ConnectionStrings[0].ProviderName == objConnectionStringSettings.ProviderName);
Note that this code assumes you have the following statements in your .cs file:
using System.Configuration;
using System.Diagnostics;
4 comments:
s to only work for an exe project, and given that you have all of your connection strings in the web config.
Do you know of a way to do this for a website project, pulling connection strings from another database/location?
This only seems to work for an exe project, and given that you have all of your connection strings in the web config.
Do you know of a way to do this for a website project, pulling connection strings from another database/location?
You can create a connection string through the usage of .udl file.
UDL File Creation :
1) Right-click on the desktop, or in the folder where you want to create the file.
2) Select New, then Text Document.
3) Give the Text Document any name with a .udl extension ("Show file extensions" must be enabled in folder options).
4) A window will pop up warning that "If you change a filename extension, the file may become unusable. Are you sure you want to change it?" Select Yes.
5) You have now successfully created a UDL file.
Now you need to implement the settings inside the .udl file according to your requirements. A video tutorial has been provided to explain you the whole procedure of using .udl file to create a connection string for MS SQL Server.
http://visiontechno.net/studymats/udlcreation.html
You can create a connection string through the usage of .udl file.
UDL File Creation :
1) Right-click on the desktop, or in the folder where you want to create the file.
2) Select New, then Text Document.
3) Give the Text Document any name with a .udl extension ("Show file extensions" must be enabled in folder options).
4) A window will pop up warning that "If you change a filename extension, the file may become unusable. Are you sure you want to change it?" Select Yes.
5) You have now successfully created a UDL file.
Now you need to implement the settings inside the .udl file according to your requirements. A video tutorial has been provided to explain you the whole procedure of using .udl file to create a connection string for MS SQL Server.
http://visiontechno.net/studymats/udlcreation.html
Post a Comment