Anonymous

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


 <asp:TextBox ID="s2GoalieGames2002" runat="server" />
                                     <asp:TextBox ID="s2Shutouts2002" runat="server" style="width:55px;" />
                                     <asp:TextBox ID="s2Saves2002" style="width:60px;" runat="server" />
                                     <asp:TextBox ID="s2SavePercentage2002" style="width:45px;" runat="server" />
                                     <asp:TextBox ID="s2GoalieAwards2002" style="width:115px;" runat="server" />