You want to use something that is labeled as a sweet onion. Vidalia onions are the most common and are delicious. But lots of stores will have a sweet yellow or white onion, you can use whatever is available.