--绑定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()));
}
}