c# - 如何使用组合框的存储值到 SQL 连接字符串？

Question

我已将组合框的输出存储到变量中：

var MyVariable = combobox.SelectedItem.ToString();

我的问题是如何将此变量用于 SQL 连接字符串？

string connectionString;
SqlConnection cnn;
connectionString = @"Data Source=DAYRMOTSTSQL05\SE;Initial Catalog=?;Integrated Security=True;";
cnn = new SqlConnection(connectionString);
cnn.Open();
cnn.Close();

我需要初始目录中的变量值，请帮我解决这个问题。

标签： c#sql-server

Answer 1

using (var cnn = new SqlConnection($"Data Source=DAYRMOTSTSQL05\\SE;Initial Catalog={combobox.SelectedItem};Integrated Security=True;"))
{
    cnn.Open();

} //using block will close the connection automatically, even if an exception is thrown
//The original code would have left the connection open if you had an exception