C# findcontrol

I am dynamically creating the row and cell structure within an asp:Table and need to access the data in the table. The dynamic creation is because there will be a variable amount of data in the table. The table creation is fine but I am not able to programmatically find the appropriate controls to access the data.

html code

                <table id="tblGoals" class="GoalsTable" runat="server">
                    <tr>
                        <td colspan="4">
                            <h3 class="Center">Goals</h3>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="4">
                            <asp:Table ID="tblGoalDetails" CssClass="GoalDetails" runat="server" GridLines="Horizontal">
                            </asp:Table>
                        </td>
                    </tr>
                </table>

Select allOpen in new window

row and cell creation code

    //********************************************************************************
    // Name: LoadGoalsTable
    // Abstract: Loads goals for specific exercise in workout
    //********************************************************************************
    private void LoadGoalsTable(int intExerciseID)
    {
        int intGoalCounter = 0;
        string strGoalType;

        //look up goals for current exercize
        using (var myEntities = new dbWorkOutEntities())
        {
            var CurrentGoals = (from goals in myEntities.tPeopleWorkOutExerciseGoals
                                where goals.intPersonID == f_intPersonId
                                   && goals.intWorkOutID == f_intWorkOutId
                                   && goals.intExcersizeID == intExerciseID
                                orderby goals.intPeopleWorkOutExerciseGoalID
                                select goals);

            hdnNumberOfGoals.Value = Convert.ToString(CurrentGoals.Count());

            //If goals exist 
            if (CurrentGoals != null)
            {
                BuildHeader();

                //build goal rows
                foreach (var Goal in CurrentGoals)
                {
                    intGoalCounter += 1;
                    strGoalType = LookUpGoalType(Goal.intGoalTypeID);

                    TableRow tblRow = new TableRow();

                    //build cells and add controls

                    //PersonWorkOutGoalID with label
                    TableCell celGoalID = new TableCell();
                    celGoalID.CssClass = "Center";
                    Label lblGoalID = new Label();
                    lblGoalID.ID = "lblGoalID" + intGoalCounter.ToString();
                    lblGoalID.Text = Goal.intPeopleWorkOutExerciseGoalID.ToString();
                    celGoalID.Controls.Add(lblGoalID);
                    tblRow.Cells.Add(celGoalID);

                    //GoalType - with hidden field fot GoalTypeID
                    TableCell celGoalType = new TableCell();
                    celGoalType.CssClass = "Center";
                    celGoalType.Text = strGoalType;
                    HiddenField hdnGoalTypeID = new HiddenField();
                    hdnGoalTypeID.ID = "hdnGoalTypeID" + intGoalCounter.ToString();
                    hdnGoalTypeID.Value = Goal.intGoalTypeID.ToString();
                    celGoalID.Controls.Add(hdnGoalTypeID);
                    tblRow.Cells.Add(celGoalType);

                    //Goal with TextBox
                    TableCell celGoal = new TableCell();
                    TextBox txtGoal = new TextBox();
                    txtGoal.CssClass = "TableBoxes";
                    txtGoal.Text = Goal.intExcersizeGoal.ToString();
                    txtGoal.ID = "txtGoal" + intGoalCounter.ToString();
                    celGoal.Controls.Add(txtGoal);
                    tblRow.Cells.Add(celGoal);

                    //Actual with TextBox
                    TableCell celActual = new TableCell();
                    TextBox txtActual = new TextBox();
                    txtActual.CssClass = "TableBoxes";
                    txtActual.ID = "txtActual" + intGoalCounter.ToString();
                    celActual.Controls.Add(txtActual);
                    tblRow.Cells.Add(celActual);

                    tblGoalDetails.Rows.Add(tblRow);
                }
            }
        }
    }


    //********************************************************************************
    // Name: BuildHeader
    // Abstract: Builds header row for goal detail table
    //********************************************************************************
    private void BuildHeader()
    {
        //Build column headers
        TableHeaderRow hdrRow = new TableHeaderRow();
        //build header cells
        TableHeaderCell hdrCell1 = new TableHeaderCell();
        hdrCell1.Text = "Goal #";
        TableHeaderCell hdrCell2 = new TableHeaderCell();
        hdrCell2.Text = "Goal Type";
        TableHeaderCell hdrCell3 = new TableHeaderCell();
        hdrCell3.Text = "Goal";
        TableHeaderCell hdrCell4 = new TableHeaderCell();
        hdrCell4.Text = "Actual";

        //add header row
        hdrRow.Cells.Add(hdrCell1);
        hdrRow.Cells.Add(hdrCell2);
        hdrRow.Cells.Add(hdrCell3);
        hdrRow.Cells.Add(hdrCell4);
        tblGoalDetails.Rows.Add(hdrRow);
    }

Select allOpen in new window

access data code

    //********************************************************************************
    // Name: SaveResults
    // Abstract: Save results as work out is proceeding
    //********************************************************************************
    private void SaveResults(int intNumberOfGoals)
    {
        int intCounter = 1;
        string strHiddenGoalTypeID;
        int intGoalTypeID;
        string strGoalID;
        int intGoalID;
        string strGoal;
        int intGoal;
        string strActualID;
        int intActual;


        while (intCounter <= intNumberOfGoals)
        {
            //find HiddenField for and get GoalId
            strHiddenGoalTypeID = "hdnGoalTypeID" + intCounter.ToString(); // define control ID
            HiddenField hdnGoalTypeID = (HiddenField)tblGoalDetails.FindControl(strHiddenGoalTypeID);  //find control
            intGoalTypeID = Convert.ToInt32(hdnGoalTypeID.Value); //get data

            //find lable and get value for goalid
            strGoalID = "lblGoalID" + intCounter.ToString();
            Label lblGoalID = (Label)tblGoalDetails.FindControl(strGoalID);
            intGoalID = Convert.ToInt32(lblGoalID.Text);

            //find textbox and get value for goal
            strGoal = "txtGoal" + intCounter.ToString();
            TextBox txtGoal = (TextBox)tblGoalDetails.FindControl(strGoal);
            intActual = Convert.ToInt32(txtGoal.Text);

            //find textbox and get value for actual
            strActualID = "txtActual" + intCounter.ToString();
            TextBox txtActual = (TextBox)tblGoalDetails.FindControl(strActualID);
            intGoal = Convert.ToInt32(txtActual.Text);

            using (var myEntities = new dbWorkOutEntities())
            {
                //Add new role
                myEntities.tPeopleWorkOutExerciseResults.Add(new tPeopleWorkOutExerciseResult()
                {
                    intPersonID = f_intPersonId,
                    intWorkOutID = f_intWorkOutId,
                    intExcersizeID = Convert.ToInt32(hdnExerciseID.Value),
                    intGoalTypeID = intGoalTypeID,
                    intPeopleWorkOutExerciseGoalID = intGoalID,
                    intExerciseGoal = intGoal,
                    intExcersizeResult = intActual,
                    dtmDatePerformed = DateTime.Now
                });

                //make perssistent
                myEntities.SaveChanges();
            }
            intCounter += 1;
        }
    }

Select allOpen in new window

Thanks for any help.