Controls (table) dynamically encoded

Question

I would like to know if it is possible to populate different tables with one foreach.

I have 5 tables tbl0, tbl1, tbl2, tbl3, tbl4, and currently I use the code below once at the table.

//fill *dtTable* with SQL

foreach (DataRow dr in dtTable.Rows)
{         
   TableHeaderRow tHRow = new TableHeaderRow();
   TableHeaderCell tHeader = new TableHeaderCell();
   tHeader.Text = dr.Field<string>("Loc");
   tHRow.Cells.Add(tHeader);
   tbl0.Rows.Add(tHRow);

   //fill 'hl' with sql

   tCell.Controls.Add(hl);
   tRow.Controls.Add(tCell);
   tbl0.Rows.Add(tRow);
}

I have something like:

 //fill *dtTable* with SQL    

 int i = 0;
 foreach (DataRow dr in dtTable.Rows)
 {         
    string TABLENAME = "tbl"+i; 

    TableHeaderRow tHRow = new TableHeaderRow();
    TableHeaderCell tHeader = new TableHeaderCell();
    tHeader.Text = dr.Field<string>("Loc");
    tHRow.Cells.Add(tHeader);

    (Table)this.FindControl(TABLENAME).Rows.Add(tHRow); // does not funktion, just an idea

    //fill 'hl' with sql

    tCell.Controls.Add(hl);
    tRow.Controls.Add(tCell);

    (Table)this.FindControl(TABLENAME).Rows.Add(tRow); // does not funktion, just an idea
    i++;
}

How can I get the dynamic name TableName, so I don’t need the same code five times?

Answer 1

Another approach:

int i = 0;
var tables = new List<Table>();
tables.Add(tbl0);
tables.Add(tbl1);
tables.Add(tbl2);
tables.Add(tbl3);
tables.Add(tbl4);


foreach (DataRow dr in dtTable.Rows)
{   
    // validation
   if(i>tables.Count)
   {
      return;
   }

   var tbl in tables[i];
   TableHeaderRow tHRow = new TableHeaderRow();
   TableHeaderCell tHeader = new TableHeaderCell();
   tHeader.Text = dr.Field<string>("Loc");
   tHRow.Cells.Add(tHeader);

   tbl.Rows.Add(tHRow);

   //fill 'hl' with sql

   tCell.Controls.Add(hl);
   tRow.Controls.Add(tCell);

   tbl.Rows.Add(tRow);
   i++;
}

I do not like to use it (Table)this.FindControl(TABLENAME).Rows.Add(tRow);, because perhaps in the future you will change the identifier of the tables so that you also have to change the function.

Answer 2

, , - .

foreach (var table in new [] {tbl0, tbl1, tbl2, tbl3, tbl4}) {
    foreach (DataRow dr in table.Rows) {         
        string TABLENAME = "tbl"+i; 

        TableHeaderRow tHRow = new TableHeaderRow();
        TableHeaderCell tHeader = new TableHeaderCell();
        tHeader.Text = dr.Field<string>("Loc");
        tHRow.Cells.Add(tHeader);

        (Table)this.FindControl(TABLENAME).Rows.Add(tHRow);

        //fill 'hl' with sql

        tCell.Controls.Add(hl);
        tRow.Controls.Add(tCell);

        (Table)this.FindControl(TABLENAME).Rows.Add(tRow);
        i++;
    }
}