dr = fieldHockeyExperienceDS.Tables["Field Hockey Future Player Statistics Goalie"].Select("Year = 2006"); if (dr.Length > 0) { if (dr[0]["Level"].ToString().Trim().Length > 0) s2GoalieLevel2006.SelectedValue = dr[0]["Level"].ToString(); if (dr[0]["Games"].ToString().Trim().Length > 0) s2GoalieGames2006.Text = dr[0]["Games"].ToString(); if (dr[0]["Shutouts"].ToString().Trim().Length > 0) s2Shutouts2006.Text = dr[0]["Shutouts"].ToString(); if (dr[0]["Number_Of_Saves"].ToString().Trim().Length > 0) s2Saves2006.Text = dr[0]["Number_Of_Saves"].ToString(); if (dr[0]["Save_Percentage"].ToString().Trim().Length > 0) s2SavePercentage2006.Text = dr[0]["Save_Percentage"].ToString(); if (dr[0]["Awards"].ToString().Trim().Length > 0) s2GoalieAwards2006.Text = dr[0]["Awards"].ToString(); } dr = fieldHockeyExperienceDS.Tables["Field Hockey Future Player Statistics Goalie"].Select("Year = 2002"); if (dr.Length > 0) { if (dr[0]["Level"].ToString().Trim().Length > 0) s2GoalieLevel2002.SelectedValue = dr[0]["Level"].ToString(); if (dr[0]["Games"].ToString().Trim().Length > 0) //here is the error s2GoalieGames2002.Text = dr[0]["Games"].ToString(); if (dr[0]["Shutouts"].ToString().Trim().Length > 0) s2Shutouts2002.Text = dr[0]["Shutouts"].ToString(); if (dr[0]["Number_Of_Saves"].ToString().Trim().Length > 0) s2Saves2002.Text = dr[0]["Number_Of_Saves"].ToString(); if (dr[0]["Save_Percentage"].ToString().Trim().Length > 0) s2SavePercentage2002.Text = dr[0]["Save_Percentage"].ToString(); if (dr[0]["Awards"].ToString().Trim().Length > 0) s2GoalieAwards2002.Text = dr[0]["Awards"].ToString(); }