Adding a Incrementing Column to a Grid View

[Glenn]

I have a grid view which takes its data from an SQL query.

The query returns a league Table of results. I would like to a add a
column which show the poistion of result (i.e 1,2,3,4)

how can i get add a column which simply showns an incremented number
for each row.

 

[rjl]

just add a column and give it the value of the grid view current row
index.

 

[Jeff Dillon]

You could generate it in the original SQL statement. Use a temp table with
an identity column, and fill it with the original data, and then select from
the temp table.

Jeff