I have what I hope is a unique question:
In need to populate a combo Box with the information stored in 6 different columns on one row of a data table. I know how to do this if it just one column and one row.
To be specific, I have one row of data that contains 'Unit of Measure' information within 6 different column names. They are UMName, UMName2, UMName3, UMName4, UMName5 and UMName6. This data is attached to one specific part number. Would someone know how I can get the one piece of info from each one of these column into the combo box? Obviously a loop won't do it since all the info is within one row. So you know, I've been using the syntax as follows:
cmbxUnitMeasure.Items.Add(umName) 'also need umName2, umName3...... cmbxUnitMeasure.Text = "Select from..."
In advance, thanks for your help.