private void initialize_mysql_connection() { init_con = new MysqlC(); con = new MySqlConnection(init_con.temp_connection_string()); }
private void fill_combobox_country() { MysqlC init_con = new MysqlC(); MySqlConnection con = new MySqlConnection(init_con.temp_connection_string()); String query = "SELECT * FROM country WHERE language = '"+ Thread.CurrentThread.CurrentUICulture.Name.Substring(0,2)+"';"; MySqlCommand cmd = new MySqlCommand(query, con); MySqlDataReader reader; try { con.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { string country_name = reader.GetString("country"); Registration_comboBox_country.Items.Add(country_name); } } catch (Exception e) { logger.Error("RETRIVE_COUNTRY_FAILED: ", e); } finally { con.Close(); } }