[RESOLVED] SQL: Select Query Results

[jmcilhinney]

There's nothing complex about the query. It's just something like:

SELECT Column1, Column2
FROM MyTable
ORDER BY Column2

Assuming you don't know how many rows there will be, you'd have to get the record count and then create that many TextBoxes and place them on your form in code. If you know the number of records beforehand then you can add the TextBoxes at design time.

Either way, I'd suggest adding the TextBoxes to an array and then using a For loop to loop through the TextBoxes and records simultaneously, populating the TextBoxes as you go. We can't really tell you how to do that because we don't know what language your app is written in. I guess it's VB but is that VB6 or VB.NET?