SQL doesn't work in C# : I wrote a query to create a chart for a race. In this chart I don't consider the absents competitors, and I take the scratch competitors at the bottom of the chart.
I've tried the query in phpmyadmin and it works, but when I copy the same query in C# doesn't show me anything.

This is the query in SQL:

    SELECT conduttore,concorrente,razza,taglia,categoria,tempo,errori,assente,eliminato
    FROM classifiche
    WHERE taglia='small' AND categoria='agility' AND assente=0
    ORDER BY 'tempo','errori','eliminato' ASC

and this is the version in C#:

    public static string StringaConnessione = "Data Source=localhost;Database=classifica;userid=root;password='';";
       	public static MySqlConnection Connessione = new MySqlConnection(StringaConnessione);    
    void MostraBtnClick(object sender, EventArgs e)
		{
			Connessione.Open();
			MySqlDataAdapter SDA=new MySqlDataAdapter("SELECT conduttore,concorrente,razza,taglia,categoria,tempo,errori,assente,eliminato FROM classifiche WHERE taglia='small' AND categoria='agility' AND assente=0 ORDER BY tempo,errori,eliminato ASC",Connessione);
			DataTable DATA= new DataTable();
			SDA.Fill(DATA);
			dataGridView1.DataSource=DATA; 
			Connessione.Close();
		}

Can you help me, please?