title: MySqlCommand.ExecuteNonQuery error and strange c#
body: <p>I try to insert pathname to mysql database, but its working but its strange. What I found is the path isnt the path of my project directory its something strange. when i use my program the result is "<strong>D:musicFOREIGN!!New folderarat cakepHilary Duff - Wake Up.mp3</strong>".
  and when I insert the query manually from phpmyadmin, its result "<strong>D:\music\FOREIGN!!\New folder\barat cakep\Hilary Duff - Wake Up.mp3</strong>", nothing strange. Am I did something wrong? here is my code:</p>
  
  <pre><code>public static void add_song(song input)
      {
          establised();
          try
          {
              MySqlCommand command = connection.CreateCommand();
              command.CommandText = string.Format("INSERT INTO song (ID_SONG, ID_GENRE, ID_CATEGORY, SONG_TITLE, SONG_ARTIST, SONG_LOCATION, SONG_PLAYED) select '', b.id_genre, c.id_category, '{0}', '{1}', '{2}', '0' from genre b, category c where b.genre = '{3}' and c.category = '{4}' ", input.title, input.artist, input.location, input.genre, input.category);
              command.ExecuteNonQuery();
          }
          catch (Exception e) { }
          release();
      }
  </code></pre>
  
  <p>and here is my example query:</p>
  
  <pre><code>"INSERT INTO song (ID_SONG, ID_GENRE, ID_CATEGORY, SONG_TITLE, SONG_ARTIST, SONG_LOCATION, SONG_PLAYED) select '', b.id_genre, c.id_category, 'Wake Up', 'Hilary Duff', 'D:\\music\\FOREIGN!!\\New folder\\barat cakep\\Hilary Duff - Wake Up.mp3', '0' from genre b, category c where b.genre = 'Pop' and c.category = 'international'"
  </code></pre>