asp:DropDownList

Hiya Im a bit stuck hope someone can help me.

Im working with SharePoint 2007, and SharePoint Designer. I have added an SQL database as a datasource and added an edit function basically what I want to do is when the user presses edit instead of it coming up as a text box where they can enter whatever they want I wnat it to be a drop down box.

So far I have this

Now I know how to manually insert items by using asp:listitem and this is ok when there is only 2 or 3 choices but when selecting from the database there could be anything upto 20 choices so basically what I want to do is take the choices directly from the SQL database.

Can anyone help me on how to do this?

Thanks 🙂