I created a procedure to retrieve the seaon that has the Current marker set, then used this value with the FindByText method of the dropdown:
string strCurrent = getCurrentSeason();
ddlSeason.SelectedIndex = ddlSeason.Items.IndexOf(ddlSeason.Items.FindByText(strCurrent));
protected string getCurrentSeason()
{
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString);
conn.Open();
string queryString = "SELECT [Season] FROM tblSeason WHERE [Current] = 1";
SqlCommand command = new SqlCommand(queryString, conn);
string strReturn = "";
SqlDataReader reader = null;
reader = command.ExecuteReader();
if (reader.Read())
{
strReturn = reader.GetString(0);
}
reader.Close();
reader.Dispose();
conn.Close();
conn.Dispose();
return strReturn;
}