So, I have a dataset which is filled with data after a mysql SELECT Statement, I'll call the dataset dsResults.Tables("Results")
Inside the dataset is data that I want to be filled into their respective text boxes. The columns in the dataset are expected to vary, for example, sometimes it may include the month Oct,Nov,Dec and sometimes I will include other months (just an example. Now each "month" in the dataset goes to respective textbox in the form. I will put all textboxes in the form and then hide all of them. After the Select statement executes and fill the dataset with data, I will then unhide the textboxes which their columns exists in the dataset and fill them with respective data from the dataset, while leaving other textboxes hidden.
I think may be it may be possible to do this with a loop? A loop that can read contents of the dataset and then unhide the respective textboxes (this is what I don't know how to do) and fill these textboxes with the data from their dataset.
Any idea please?