I used this and it's work with me :
using (MySqlConnection con = new MySqlConnection(ConString))
{
con.Open();
CmdString = "SELECT * FROM database.mytable order by mycolumn DESC ";
MySqlCommand cmd = new MySqlCommand(CmdString, con);
MySqlDataAdapter sda = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable("mytable");
sda.Fill(dt);
myDataGrid.ItemsSource = dt.DefaultView;
}
Thank you for help .