System.Data.Common.DbConnectionStringBuilder.Add C# (CSharp) Méthode

Add() public méthode

public Add ( string keyword, object value ) : void
keyword string
value object
Résultat void
        public void Add(string keyword, object value)
        {
            this[keyword] = value;
        }

Usage Example

        private void instancesComboBox_SelectedIndexChanged(object sender, EventArgs e)
        {
            string server = (string)instancesComboBox.SelectedItem;

             DbConnectionStringBuilder builder = new DbConnectionStringBuilder();
             builder.Add("Data Source", server);
             builder.Add("Initial Catalog", "master");
             builder.Add("Integrated Security", "SSPI");

             using ( SqlConnection conn = new SqlConnection(builder.ConnectionString) )
             {
            SqlCommand cmd = new SqlCommand("select name from sys.databases", conn);
            conn.Open();

            using ( SqlDataReader reader = cmd.ExecuteReader() )
            {
               List<string> dbs = new List<string>();
               while ( reader.Read() )
               {
                  dbs.Add(reader.GetString(0));
               }
               dbsComboBox.DataSource = dbs;
            }
             }
        }
All Usage Examples Of System.Data.Common.DbConnectionStringBuilder::Add