绑定dorplist

   --绑定droplist   

  private void ShowGenre()
        {
            string sql = "select genre_id,genre_name from t_starsys_genre where state='True' order by sort_number";
            DataTable dt = OracleHelper.ExecuteDataSet(sql, null).Tables[0];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                ddlGenre.Items.Add(new ListItem(dt.Rows[i]["genre_name"].ToString(), dt.Rows[i]["genre_id"].ToString()));
                if (i == 0)
                    ddlGenre.SelectedIndex = ddlGenre.Items.IndexOf(ddlGenre.Items.FindByValue(dt.Rows[i]["genre_id"].ToString()));
            }
        }