Monday, November 17, 2008

How to create a connection string programmatically

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;

6 comments:

Anonymous said...

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?

Anonymous said...

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?

saurav banthia said...

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

saurav banthia said...

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

Ananth M said...


This is my first visit to your site. Today I have got a new site.
I am really happy to be here. I am stay tuned here for your next blog...

hadoop training in Chennai

Training Coimbatore said...

great post

Hadoop training in coimbatore
Java training in coimbatore
Oracle training in coimbatore
Informatica training in coimbatore
Oracle training in coimbatore
Informatica training in coimbatore