I am attempting to populate a text box with a large variable that contains large amounts of text from a varchar in SQL. The data is basically comments that are stored in a varchar(3000) column, and occupy multiple rows of a dataset.

My problem is that I am having difficulty maneuvering through those rows to grab that data, and concatenate it to a string that will eventually be displayed in a textbox. I am pretty sure that I could use a "while" loop to traverse each row, but am not sure how to indicate the rows.


TIA!