Hello,

I am trying to display the results returned from my SQL call to the user in a pyramid format with 1 in the first row, 2 in the second and 3 in the third. If there are more than 6 records returned, I dont want to show them.

I guess the general question is WHAT is the best way to control the formatting and positioning of each record returned from a database using asp.net 2.0? For example, I might also want to change the properties of the first record returned, then the second, etc.

I was thinking of using a repeater control but how could I see what number I am on? If I could determine that I was on record #3 returned, I might be able to use some code to set up how to display it. Or, how can I add a bunch of controls (assume a textbox) to the page in a number of places and have each one associated with a different record returned from the database (i.e. textbox1 associated with record returned #1, textbox2 associated with record returned #2, etc)

Thanks,

Josh