如何在C＃中动态创建连接字符串 [英] How to create connection string dynamically in C#

问题描述

如何在C＃中动态创建连接字符串，而不是使用字符串连接来创建连接字符串？

How to create connection string dynamically in C#, instead of creating it using string concatenation?

推荐答案

您可以创建动态连接字符串与C＃中的SqlConnectionStringBuilder类如下。

You can create dynamic connection string with SqlConnectionStringBuilder Class in C# as follows.

有关详细信息，请检查 http://msdn.microsoft.com/en-us/library/dce36088.aspx

for more details pls check http://msdn.microsoft.com/en-us/library/dce36088.aspx

private void Form1_Load(object sender, EventArgs e)
{
     SqlConnectionStringBuilder connectionString = new SqlConnectionStringBuilder();
     connectionString.DataSource = @".\SQLEXPRESS";
     connectionString.InitialCatalog = "MyDatabase";
     connectionString.IntegratedSecurity = true;
     MessageBox.Show(connectionString.ConnectionString);
}

这篇关于如何在C＃中动态创建连接字符串的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！