How is the best way to do this?

Question

Hello I have run into an issue. I have a monster of a form I am autopopulating to from a sql database. I have 12 sections in the form that are exactly the same except a number changes on all the fields, I want to write a loop so that I can have it loop through twenty times and populate the data. this is what I have done as a test that was unsuccessful, can anyone help?

for (int a = 0; a < dataTableCOMPSALES.Rows.Count; a++)

{

DataRow rowCOMPSALES = myDataSetCOMPSALES.Tables["ComparableSale"].Rows[a];

string typeIndicator = rowCOMPSALES["SaleOrListingIndicator"].ToString();

if (typeIndicator == "S")

{

string saleListingNumber = "txtSale" + a + "ListingNumber";

+saleListingNumber+.Text = rowCOMPSALES["_ListingNumber"].ToString();

}

else

{

string listListingNumber = "txtList" + a + "ListingNumber";

}

Jan Montano · Answer

you could use... foreach (control ctrl in form1.Controls) // this will iterate through each of your control { // you can use ctrl.Name to check the name and then you could to your processing } Hope this helps.

cdog · Answer

basically I want to loop through and change the field name 20 times so in essence I change 20 textboxes that are named exactly the same save for one number example: text1box text2box text3box

Mike Gold · Answer

why do you want to loop through the data 20X to populate the form? Wouldn't that overwrite the data in your form 20X? Perhaps I'm misunderstanding what exactly it is you are trying to do.