protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
using (FlexibleTennisLeagueDataContext dataContext = new FlexibleTennisLeagueDataContext())
{
List <SelectLeagueAllResult> selectLeagueAllResults = dataContext.SelectLeagueAll().ToList();
cityDropDownList.Items.Add(new ListItem(string.Empty, string.Empty));
foreach (SelectLeagueAllResult result in selectLeagueAllResults)
{
cityDropDownList.Items.Add(new ListItem(result.LeagueCity + ", " + result.LeagueState, result.LeagueId.ToString()));
}
}
}
}