Example #1
0
        public MySqlStorage(IConnectionSettings connectionSettings)
        {

            string connection =  string.Format("server={0};port={1};username={2};password={3};database={4}",
                connectionSettings.getHost(), connectionSettings.getPort(), connectionSettings.getLogin(), connectionSettings.getPassword(), connectionSettings.getDatabaseName());

            //This is my insert query in which i am taking input from the user through windows forms 

            //This is  MySqlConnection here i have created the object and pass my connection string. 
            _mySqlConnection = new MySqlConnection(connection);
            try
            {

                _mySqlConnection.Open();
            }
            catch (MySql.Data.MySqlClient.MySqlException)
            {
                if (connectionFailed != null)
                {
                    connectionFailed("Не удалось подключиться к базе данных, проверьте файл настроек");
                }
            }
        }