Help In Query Or Code

Hi,


I need to bind to dropdown list, the conference names from the last one to the first one.


I'm using following query, the problem is it returns the conference names the number of dates created, since it's one table with all data I can't change it now.


Is there a way to get the names one time for each name without repeating?





string Sql = "SELECT DISTINCT conference_name,creation_date FROM Conference ORDER BY creation_date DESC";


SqlDataAdapter da = new SqlDataAdapter(Sql, myConn);


dataSet = new DataSet();


da.Fill(dataSet);


ddlConfName.DataTextField = "conference_name";


ddlConfName.DataSource = dataSet.Tables[0];


ddlConfName.DataBind();