根据所选的数据库值更改connctionString [英] Change connctionString depending on selected database value

问题描述

大家好



在我的应用程序中，启动用户必须选择它的服务器名称，数据库名称。



所以请告诉我如何为不同的服务器和不同的数据库创建连接字符串。



谢谢。

Hi all

In my application, at starting user have to select it's server name, database name.

So please tell me how to create the connection string for different server and different database.

Thank you.

推荐答案

//希望这会有所帮助

SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder（）;

connectionStringBuilder.DataSource =localhost;

connectionStringBuilder.IntegratedSecurity = true;

connectionStringBuilder.InitialCatalog =SampleDB;



ConnectionStringSettings connSttng = new ConnectionStringSettings（）;

connSttng.Name =ConnectionStringName;

connSttng.ProviderName =Providername;

connSttng.ConnectionString = String.Format（DataSource = {0}; InitialCatalog = {1}; IntegratedSecurity = {2}，c onnectionStringBuilder.DataSource，connectionStringBuilder.InitialCatalog，connectionStringBuilder.IntegratedSecurity）;



配置config = WebConfigurationManager.OpenWebConfiguration（〜）;

config .ConnectionStrings.ConnectionStrings.Add（connSttng）;

config.Save（ConfigurationSaveMode.Modified，true）;

ConfigurationManager.RefreshSection（connectionStrings）;

//hope this will help
SqlConnectionStringBuilder connectionStringBuilder = new SqlConnectionStringBuilder();
connectionStringBuilder.DataSource = "localhost";
connectionStringBuilder.IntegratedSecurity = true;
connectionStringBuilder.InitialCatalog = "SampleDB";

ConnectionStringSettings connSttng = new ConnectionStringSettings();
connSttng.Name = "ConnectionStringName";
connSttng.ProviderName = "Providername";
connSttng.ConnectionString = String.Format("DataSource={0};InitialCatalog={1};IntegratedSecurity={2}", connectionStringBuilder.DataSource, connectionStringBuilder.InitialCatalog, connectionStringBuilder.IntegratedSecurity);

Configuration config = WebConfigurationManager.OpenWebConfiguration("~");
config.ConnectionStrings.ConnectionStrings.Add(connSttng);
config.Save(ConfigurationSaveMode.Modified, true);
ConfigurationManager.RefreshSection("connectionStrings");

这篇关于根据所选的数据库值更改connctionString的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！