Fill textboxes on listbox selection

See more:

C#

Well what I'm trying to do is fill a few textboxes on a list box selection. Here is the code I have:

if(!string.IsNullOrEmpty(this.UserList.SelectedItem.ToString()))
        {
            string value;
            value = UserList.SelectedValue.ToString();
            MySqlCommand sql1 = new MySqlCommand("SELECT * FROM `users` WHERE `name` = ''"+value+"''", myConnection.GetConnection());
            MySqlDataAdapter DA = new MySqlDataAdapter(sql1);
            DataSet DS = new DataSet();
            DA.Fill(DS, "users");
            if(DS.Tables["users"].Rows.Count > 0)
            {
            this.Usernametxtbox.Text = DS.Tables["users"].Rows[0] ["name"].ToString();
            }
            else
            {
               MessageBox.Show("No data to populate the feilds");
            }
        }
        else
        {
         MessageBox.Show("Selected Value is null");
        }
}

And I can't seem to figure out why it's basically telling me I have the wrong Sql syntax, I have checked the Sql query in phpmyadmin and it works fine, so I cant figure out what I'm doing wrong.

Here is the exact error, it highlights DA.Fill(DS, "users"); and then it says You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'System.Data.DataRowView''' at line 1