I got it to work. I used a different technique. Someone suggested that i create an object with the exact size of the row i was writing too, add the data into the object and use the rows.add method to add an entire row at a time.

However, I still want to know how to add data a column at a time and see the results, in addition to creating a different row. This info will be useful on projects in which I can't add entire rows at a time.


I had started to go the way of databinding, but I did know know enough to use them. I also tend to stay away from databinding as I feel I have more control doing it manual (I am sure that will change as I get more comfortable with visual basic as I am a Java guy).

The data comes form an oracle 8i database from which I only have read access too.