try this one.
<pre lang="c#">
DataSet ds = new DataSet();
OdbcConnection con = new OdbcConnection(ConnStr);
OdbcDataAdapter da = new OdbcDataAdapter("SELECT ...", con);
con.Open();
da.Fill(ds);
dt = ds.Tables[0];
dropdownlist.DataSource = ds
dropdownlist.DataTextField = "Team"
dropdownlist.DataValueField = "Team"
dropdownlist.DataBind()
con.Close();
</pre>
Best Regards,
iamsupergrasya