How is the best way to do this?

cdog

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";

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jan Montano19y ago
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.
0
cdog19y ago
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
0
Mike Gold19y ago
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.
0