public static MySqlConnection Connection = new MySqlConnection(); public static void ExecuteInsertQuery(string Sql, Dictionary Values) { MySqlCommand Command = new MySqlCommand(); Command.Connection = Connection; if (Connection.State == ConnectionState.Closed) { Connection.Open(); } Command.CommandText = Sql; Debug.WriteLine(Sql); Command.Prepare(); foreach (KeyValuePair kvp in Values) { Debug.WriteLine(kvp.Key); Debug.WriteLine((kvp.Value).ToString()); Command.Parameters.AddWithValue(kvp.Key, kvp.Value); } Command.ExecuteNonQuery(); Connection.Close(); }